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.