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.

 Kuder-Richardson #21 Formula for estimate test reliability
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Kuder-Richardson #21 Formula for estimate test reliability

#1
November 4th 07, 02:30 PM posted to microsoft.public.excel.misc
 external usenet poster Posts: 35
Kuder-Richardson #21 Formula for estimate test reliability

Good Morning!

I am trying to figure out how to adapt the Kruder-Richardson 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(k-X))
----- -----------
k-1 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))
----- --------------
50-1 (50)(25)

R = (1.02) (1- 301)
----
1250

R = (1.02) (0.76) = 0.78

http://www.savefile.com/projects/808560688

#2
November 4th 07, 03:17 PM posted to microsoft.public.excel.misc
 JE McGimpsey external usenet poster Posts: 4,624
Kuder-Richardson #21 Formula for estimate test reliability

#3
November 4th 07, 03:37 PM posted to microsoft.public.excel.misc
 Bernd P external usenet poster Posts: 806
Kuder-Richardson #21 Formula for estimate test reliability

Hello,

If you google for "Kuder-Richardson 21 Formula excel" then you will
find

Some things are easier copied than re-invented.

Regards,
Bernd

#4
November 4th 07, 03:48 PM posted to microsoft.public.excel.misc
 JE McGimpsey external usenet poster Posts: 4,624
Kuder-Richardson #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 re-invented.

#5
November 4th 07, 09:49 PM posted to microsoft.public.excel.misc
 external usenet poster Posts: 35
Kuder-Richardson #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 re-invented.- Hide quoted text -

>
> - Show quoted text -

Thank you both!

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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

All times are GMT +1. The time now is 05:17 PM.