2015
Step 1 |
|
Step 2 |
|
Step 3 |
Get Mean Scale Score from line numbers in this
data file.
|
|
Subtract 'met min'
Scale Score.
from Mean Scale Score to get
Distance From Standard
|
|
Multiply Distance From Standard by
proportion of students in grade.
|
Grade |
Line number |
Mean Scale Score |
- |
Scale Score: met min |
= |
Distance from standard |
* |
(Students tested in grade |
/ |
Students) tested in school |
= |
Weighted Distance From Standard |
3 |
1247964 |
2485 |
- |
2436 |
= |
49 |
* |
(150 |
/ |
950) |
= |
7.73684206 |
4 |
1247967 |
2524 |
- |
2485 |
= |
39 |
* |
(168 |
/ |
950) |
= |
6.8968421 |
5 |
1247968 |
2522 |
- |
2528 |
= |
-6 |
* |
(159 |
/ |
950) |
= |
-1.00421053 |
6 |
1247971 |
2554 |
- |
2552 |
= |
2 |
* |
(165 |
/ |
950) |
= |
0.34736842 |
7 |
1247972 |
2583 |
- |
2567 |
= |
16 |
* |
(153 |
/ |
950) |
= |
2.5768421 |
8 |
1247975 |
2623 |
- |
2586 |
= |
37 |
* |
(155 |
/ |
950) |
= |
6.03684208 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Larkspur-Corte Madera
|
23 |
2016
Step 1 |
|
Step 2 |
|
Step 3 |
Get Mean Scale Score from line numbers in this
data file.
|
|
Subtract 'met min'
Scale Score.
from Mean Scale Score to get
Distance From Standard
|
|
Multiply Distance From Standard by
proportion of students in grade.
|
Grade |
Line number |
Mean Scale Score |
- |
Scale Score: met min |
= |
Distance from standard |
* |
(Students tested in grade |
/ |
Students) tested in school |
= |
Weighted Distance From Standard |
3 |
38900 |
2487 |
- |
2436 |
= |
51 |
* |
(176 |
/ |
986) |
= |
9.10344824 |
4 |
38902 |
2532 |
- |
2485 |
= |
47 |
* |
(153 |
/ |
986) |
= |
7.29310341 |
5 |
38905 |
2546 |
- |
2528 |
= |
18 |
* |
(176 |
/ |
986) |
= |
3.21298173 |
6 |
38907 |
2543 |
- |
2552 |
= |
-9 |
* |
(170 |
/ |
986) |
= |
-1.55172414 |
7 |
38909 |
2575 |
- |
2567 |
= |
8 |
* |
(161 |
/ |
986) |
= |
1.30628803 |
8 |
38911 |
2581 |
- |
2586 |
= |
-5 |
* |
(150 |
/ |
986) |
= |
-0.76064909 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Larkspur-Corte Madera
|
19 |
2017
Step 1 |
|
Step 2 |
|
Step 3 |
Get Mean Scale Score from line numbers in this
data file.
|
|
Subtract 'met min'
Scale Score.
from Mean Scale Score to get
Distance From Standard
|
|
Multiply Distance From Standard by
proportion of students in grade.
|
Grade |
Line number |
Mean Scale Score |
- |
Scale Score: met min |
= |
Distance from standard |
* |
(Students tested in grade |
/ |
Students) tested in school |
= |
Weighted Distance From Standard |
3 |
39864 |
2472 |
- |
2436 |
= |
36 |
* |
(178 |
/ |
1002) |
= |
6.39520956 |
4 |
39866 |
2539 |
- |
2485 |
= |
54 |
* |
(166 |
/ |
1002) |
= |
8.94610775 |
5 |
39867 |
2557 |
- |
2528 |
= |
29 |
* |
(162 |
/ |
1002) |
= |
4.68862273 |
6 |
39869 |
2586 |
- |
2552 |
= |
34 |
* |
(170 |
/ |
1002) |
= |
5.76846305 |
7 |
39871 |
2588 |
- |
2567 |
= |
21 |
* |
(172 |
/ |
1002) |
= |
3.60479041 |
8 |
39874 |
2625 |
- |
2586 |
= |
39 |
* |
(154 |
/ |
1002) |
= |
5.99401195 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Larkspur-Corte Madera
|
35 |
2018
Step 1 |
|
Step 2 |
|
Step 3 |
Get Mean Scale Score from line numbers in this
data file.
|
|
Subtract 'met min'
Scale Score.
from Mean Scale Score to get
Distance From Standard
|
|
Multiply Distance From Standard by
proportion of students in grade.
|
Grade |
Line number |
Mean Scale Score |
- |
Scale Score: met min |
= |
Distance from standard |
* |
(Students tested in grade |
/ |
Students) tested in school |
= |
Weighted Distance From Standard |
3 |
39891 |
2491 |
- |
2436 |
= |
55 |
* |
(161 |
/ |
1016) |
= |
8.71555113 |
4 |
39892 |
2541 |
- |
2485 |
= |
56 |
* |
(176 |
/ |
1016) |
= |
9.70078738 |
5 |
39895 |
2558 |
- |
2528 |
= |
30 |
* |
(180 |
/ |
1016) |
= |
5.31496062 |
6 |
39896 |
2588 |
- |
2552 |
= |
36 |
* |
(152 |
/ |
1016) |
= |
5.38582676 |
7 |
39898 |
2620 |
- |
2567 |
= |
53 |
* |
(174 |
/ |
1016) |
= |
9.07677163 |
8 |
39900 |
2608 |
- |
2586 |
= |
22 |
* |
(173 |
/ |
1016) |
= |
3.74606298 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Larkspur-Corte Madera
|
42 |
2019
Step 1 |
|
Step 2 |
|
Step 3 |
Get Mean Scale Score from line numbers in this
data file.
|
|
Subtract 'met min'
Scale Score.
from Mean Scale Score to get
Distance From Standard
|
|
Multiply Distance From Standard by
proportion of students in grade.
|
Grade |
Line number |
Mean Scale Score |
- |
Scale Score: met min |
= |
Distance from standard |
* |
(Students tested in grade |
/ |
Students) tested in school |
= |
Weighted Distance From Standard |
3 |
40049 |
2509 |
- |
2436 |
= |
73 |
* |
(157 |
/ |
1017) |
= |
11.26941982 |
4 |
40050 |
2547 |
- |
2485 |
= |
62 |
* |
(165 |
/ |
1017) |
= |
10.05899699 |
5 |
40051 |
2561 |
- |
2528 |
= |
33 |
* |
(180 |
/ |
1017) |
= |
5.84070795 |
6 |
40052 |
2587 |
- |
2552 |
= |
35 |
* |
(184 |
/ |
1017) |
= |
6.33235005 |
7 |
40053 |
2627 |
- |
2567 |
= |
60 |
* |
(157 |
/ |
1017) |
= |
9.26253684 |
8 |
40054 |
2630 |
- |
2586 |
= |
44 |
* |
(174 |
/ |
1017) |
= |
7.52802358 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Larkspur-Corte Madera
|
50 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
23
|
19
|
35
|
42
|
50
|
169.0 |
33.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 69.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -2.2
For the lines, you have the data necessary to plot the chart.