SHARED - Reliability Estimator Employing KR21

	A	B	C	E	F	G	L	M	N	O
1	Reliablity Estimator Employing KR21
2	- Only enter data into the fields that are shaded purple. - Blank cells are ignored. - The ID and Date fields are optional - Copy this sheet by File -> Make a Copy. The copy will be editable. - To see what the reliablity of the exam would be if lengthened, enter the number of items in the new exam in cell E13 ("New Exam Length")						0	0	0	0
3							1	1	0	0
4							2	2	0	0
5	BVC ID	Date	Raw Scores (Do not enter 0's)				3	3	1	1
6			16		Raw	Percent	4	4	0	0
7			21	Maximum possible raw score (k)	24		5	5	1	1
8			21	Standard deviation (s)	4.63	19%	6	6	0	0
9			15	mean (X)	16.78	70%	7	7	1	1
10			19	n	54		8	8	1	1
11			18				9	9	0	0
12			24	Kudar-Richardson 21	0.80	0.00 to 0.49 is too low; 0.50 to 0.70 is good; 0.70 to 0.95 is excellent	10	10	1	1
13			20				11	11	1	1
14			21	New exam length	40		12	12	3	3
15			18	Spearman-Brown Prophesy	0.87		13	13	3	3
16			18				14	14	3	3
17			19				15	15	3	3
18			22				16	16	3	3
19			18				17	17	4	4
20			21				18	18	8	8
21			19				19	19	5	5
22			18				20	20	4	4
23			18				21	21	5	5
24			19				22	22	3	3
25			24				23	23	2	2
26			18				24	24	2	2
27			16				25		0
28			18				26		0
29			21				27		0
30			20				28		0
31			12				29		0
32			22				30		0
33			15				31		0
34			12				32		0
35			13				33		0
36			7				34		0
37			17				35		0
38			15				36		0
39			12				37		0
40			13				38		0
41			8				39		0
42			22				40		0
43			11				41		0
44			10				42		0
45			13				43		0
46			19				44		0
47			23				45		0
48			14				46		0
49			14				47		0
50			14				48		0
51			17				49		0
52			17				50		0
53			16				51		0
54			17				52		0
55			20				53		0
56			20				54		0
57			3				55		0
58			23				56		0
59			5				57		0
60							58		0
61							59		0
62							60		0
63							61		0
64							62		0
65							63		0
66							64		0
67							65		0
68							66		0
69							67		0
70							68		0
71							69		0
72							70		0
73							71		0
74							72		0
75							73		0
76							74		0
77							75		0
78							76		0
79							77		0
80							78		0
81							79		0
82							80		0
83							81		0
84							82		0
85									0
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100