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 |
2666192 |
2509 |
- |
2436 |
= |
73 |
* |
(17 |
/ |
47) |
= |
26.40425527 |
4 |
2666193 |
2559 |
- |
2485 |
= |
74 |
* |
(19 |
/ |
47) |
= |
29.91489361 |
5 |
2666196 |
2528 |
- |
2528 |
= |
0 |
* |
(11 |
/ |
47) |
= |
0.0 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Lakeside Joint
|
56 |
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 |
81246 |
2495 |
- |
2436 |
= |
59 |
* |
(13 |
/ |
48) |
= |
15.97916665 |
4 |
81249 |
2557 |
- |
2485 |
= |
72 |
* |
(18 |
/ |
48) |
= |
27.0 |
5 |
81251 |
2572 |
- |
2528 |
= |
44 |
* |
(17 |
/ |
48) |
= |
15.5833333 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Lakeside Joint
|
59 |
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 |
83495 |
0 |
- |
2436 |
= |
|
* |
(0 |
/ |
41) |
= |
|
4 |
83496 |
2535 |
- |
2485 |
= |
50 |
* |
(16 |
/ |
41) |
= |
19.5121951 |
5 |
83499 |
2559 |
- |
2528 |
= |
31 |
* |
(17 |
/ |
41) |
= |
12.85365853 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Lakeside Joint
|
32 |
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 |
83721 |
2518 |
- |
2436 |
= |
82 |
* |
(14 |
/ |
37) |
= |
31.027027 |
4 |
83723 |
0 |
- |
2485 |
= |
|
* |
(0 |
/ |
37) |
= |
|
5 |
83725 |
2570 |
- |
2528 |
= |
42 |
* |
(16 |
/ |
37) |
= |
18.16216214 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Lakeside Joint
|
49 |
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 |
84332 |
0 |
- |
2436 |
= |
|
* |
(9 |
/ |
29) |
= |
|
4 |
84333 |
2539 |
- |
2485 |
= |
54 |
* |
(15 |
/ |
29) |
= |
27.93103447 |
5 |
84334 |
0 |
- |
2528 |
= |
|
* |
(5 |
/ |
29) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Lakeside Joint
|
28 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
56
|
59
|
32
|
49
|
28
|
224.0 |
44.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 86.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 2.8
For the lines, you have the data necessary to plot the chart.