If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




KuderRichardson #21 Formula for estimate test reliability
Good Morning!
I am trying to figure out how to adapt the KruderRichardson Formula #21 to excel. First of all this is not a homework assignment. Secondly, I appologize for linking a file but I could not get the fonts for the formula right. What the formla does is to estimate test reliability. I can figure it out long hand but would greatly appreciate it in excel thanks in advance. R=( k) (1 X(kX))   k1 kS where R= test reliability k = number of items on the test X = mean of raw scores from the total test S = vfariance from the raw scores of the total test Suppose we had a 50 item test and the mean score was 43 and the variance was 25.0. We would have R= (50) (1 43(50  43))   501 (50)(25) R = (1.02) (1 301)  1250 R = (1.02) (0.76) = 0.78 Thank you in advance. http://www.savefile.com/projects/808560688 
Ads 
#3




KuderRichardson #21 Formula for estimate test reliability
Hello,
If you google for "KuderRichardson 21 Formula excel" then you will find http://www.gifted.uconn.edu/siegle/r...eliability.htm which links to a [IMHO] nice sample spreadsheet http://www.gifted.uconn.edu/siegle/r...alculator2.xls Some things are easier copied than reinvented. Regards, Bernd 
#4




KuderRichardson #21 Formula for estimate test reliability
A caveat 
There are tens of thousands of workbooks out there that can be copied. A significant fraction of them, including ones posted by academics, have errors or have poor boundary event error checking. Validating someone else's worksheet for a simple calculation like this can often be *more* difficult than building from scratch... In article . com>, Bernd P > wrote: > Some things are easier copied than reinvented. 
#5




KuderRichardson #21 Formula for estimate test reliability
On Nov 4, 10:48 am, JE McGimpsey > wrote:
> A caveat  > > There are tens of thousands of workbooks out there that can be copied. A > significant fraction of them, including ones posted by academics, have > errors or have poor boundary event error checking. > > Validating someone else's worksheet for a simple calculation like this > can often be *more* difficult than building from scratch... > > In article . com>, > Bernd P > wrote: > > > > > Some things are easier copied than reinvented. Hide quoted text  > >  Show quoted text  Thank you both! 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
How to indicate that a value is an estimate?  couture57  Excel Discussion (Misc queries)  7  March 26th 08 12:43 AM 
Reliability and Confidence and Excel  Gerigto  Excel Discussion (Misc queries)  5  September 5th 07 03:04 AM 
How to set up a cost estimate spreadsheet?  mgirving  Excel Worksheet Functions  2  September 1st 06 03:47 PM 
How to estimate a future service date?  Monkey.wrench  Excel Worksheet Functions  1  January 13th 06 09:37 PM 
Template for estimate  DIDI50  Excel Discussion (Misc queries)  0  January 19th 05 12:13 AM 