2 Shifting effects of weights.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	Q	R	S	T	U
1		A	B	C	D	E	F	G	H	I	J	K	L
2		Scenario 1 - only secondary grade weight
3								Eq Ratio: 60 ÷ 66.00 =			0.909
4						K-6	7-12	Sparsity	Wght						Summary
5			K-6	7-12	ADM tot	0.0	0.2	Eligible	0.0	Wghtd ADM	District Ratio	Eq Ratio	EqPup				1 weighting factor	2 weighting factors
6	1.	District 1	5	15	20	-	3.0	no	-	23.0	0.870	0.909	20.9			ADM tot	EqPup	EqPup
7	2.	District 2	10	10	20	-	2.0	yes	-	22.0	0.909	0.909	20.0	1.	District 1	20	20.9	19.7
8	3.	District 3	15	5	20	-	1.0	yes	-	21.0	0.952	0.909	19.1	2.	District 2	20	20.0	20.6
9	4.	State			60					66.0	0.909		60.0	3.	District 3	20	19.1	19.7
10														4.	State	60	60.0	60.0
11
12		A	B	C	D	E	F	G	H	I	J	K	L
13		Scenario 2 - secondary weight plus a sparsity weight
14								Eq Ratio: 60 ÷ 70.00 =			0.857
15						K-6	7-12	Sparsity	Wght
16			K-6	7-12	ADM tot	0.0	0.2	Eligible	0.1	Wghtd ADM	District Ratio	Eq Ratio	EqPup
17	5.	District 1	5	15	20	-	3.0	no	-	23.0	0.870	0.857	19.7
18	6.	District 2	10	10	20	-	2.0	yes	2.0	24.0	0.833	0.857	20.6
19	7.	District 3	15	5	20	-	1.0	yes	2.0	23.0	0.870	0.857	19.7
20	8.	State			60					70.0	0.857		60.0
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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