Step2CK Predictor

	A	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q	R	S	T	U	V
1	Shelf				Raw Score	Quarter	Predicted Score	r^2	Scaling Factor	Scaled Score	Percentage of Prediction		Score	Predicted Score	m	b	r^2	r^2	Scaling Factor	Scaled Score	Percentage of Prediction
2	FM	m	b	r^2	0	1	209.72	0	#DIV/0!	#DIV/0!	#DIV/0!	UWSA1	0	93.537	0.6378	93.537	0.585	0	#DIV/0!	0	#DIV/0!
3	Quarter											UWSA2	0	63.227	0.7529	63.227	0.5958	0	#DIV/0!	0	#DIV/0!
4	1	0.5779	209.72	0.201								Free120	Percentage	Predicted Score	m	b	r^2	r^2		Scaled Score	Percentage of Prediction
5	2	0.6256	207.01	0.1741									0	128.85	1.4733	128.85	0.3497	0	#DIV/0!	0	#DIV/0!
6	3	1.0602	168.73	0.2573								UW%	Percentage	Predicted Score	m	b	r^2	r^2		Scaled Score	Percentage of Prediction
7	4	1.2258	156.52	0.4388									0	176.59	1.0593	176.59	0.405	0	#DIV/0!	0	#DIV/0!
8					Raw Score	Quarter	Predicted Score	r^2	Scaling Factor	Scaled Score	Percentage of Prediction
9	IM	m	b	r^2	0	3	143.3	0	#DIV/0!	#DIV/0!	#DIV/0!		Score	Predicted Score	m	b	r^2	r^2	Scaling Factor	Scaled Score	Percentage of Prediction
10	Quarter											NBME 6	0	155.15	0.4182	155.15	0.524	0	#DIV/0!	0	#DIV/0!
11	1	0.7999	192.2	0.3031								NBME 7	0	138.57	0.4921	138.57	0.4753	0	#DIV/0!	0	#DIV/0!
12	2	1.2091	160.73	0.4637								NBME 8	0	139.33	0.4747	139.33	0.5304	0	#DIV/0!	0	#DIV/0!
13	3	1.3905	143.3	0.5063
14	4	1.4559	136.05	0.6392
15					Raw Score	Quarter	Predicted Score	r^2	Scaling Factor	Scaled Score	Percentage of Prediction				Predicted Score	#DIV/0!
16	OB/Gyn	m	b	r^2	0	2	177.12	0	#DIV/0!	#DIV/0!	#DIV/0!	Key
17	Quarter													Editable (Allows 0 value)
18	1	1.4154	141.59	0.4841										Editable (Does not allow 0 value)
19	2	0.9663	177.12	0.3152										Editable if error from collected value or for future years
20	3	0.7395	194.41	0.3149									ALL OTHER COLORS	DO NOT EDIT!!!!!!!!!!!!!!CONTAIN FORMULAS
21	4	1.1368	164.78	0.4317
22					Raw Score	Quarter	Predicted Score	r^2	Scaling Factor	Scaled Score	Percentage of Prediction
23	Peds	m	b	r^2	0	1	168.89	0	#DIV/0!	#DIV/0!	#DIV/0!
24	Quarter
25	1	1.0895	168.89	0.4788
26	2	1.1379	162.47	0.3639
27	3	1.2591	150.93	0.4762
28	4	1.4192	134.87	0.4035
29					Raw Score	Quarter	Predicted Score	r^2	Scaling Factor	Scaled Score	Percentage of Prediction
30	Psych	m	b	r^2	0	2	181.69	0	#DIV/0!	#DIV/0!	#DIV/0!
31	Quarter
32	1	1.2692	146.44	0.3139
33	2	0.8819	181.69	0.2607
34	3	0.8807	181.89	0.2401
35	4	1.0734	162.07	0.1924
36					Raw Score	Quarter	Predicted Score	r^2	Scaling Factor	Scaled Score	Percentage of Prediction
37	Surgery	m	b	r^2	0	4	156.83	0	#DIV/0!	#DIV/0!	#DIV/0!
38	Quarter
39	1	0.8401	193.28	0.3548
40	2	0.7396	199.1	0.2988
41	3	1.006	173.82	0.2602
42	4	1.2403	156.83	0.4628
43								Combined R values
44								0
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100