Remember Me?

 #1     November 4th 07, 02:30 PM posted to microsoft.public.excel.misc 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 Thank you in advance. http://www.savefile.com/projects/808560688

#2
November 4th 07, 03:17 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 4,624
Kuder-Richardson #21 Formula for estimate test reliability

#3
November 4th 07, 03:37 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2007 Posts: 806
Kuder-Richardson #21 Formula for estimate test reliability

Hello,

If you google for "Kuder-Richardson 21 Formula excel" then you will
find
which links to a [IMHO] nice sample spreadsheet

Some things are easier copied than re-invented.

Regards,
Bernd

#4
November 4th 07, 03:48 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 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 First recorded activity by ExcelBanter: Nov 2006 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 Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post couture57 Excel Discussion (Misc queries) 7 March 26th 08 12:43 AM Gerigto Excel Discussion (Misc queries) 5 September 5th 07 03:04 AM mgirving Excel Worksheet Functions 2 September 1st 06 03:47 PM Monkey.wrench Excel Worksheet Functions 1 January 13th 06 09:37 PM DIDI50 Excel Discussion (Misc queries) 0 January 19th 05 12:13 AM

All times are GMT +1. The time now is 08:02 PM.