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 
74729 
2331 
 
2436 
= 
105 
* 
(51 
/ 
162) 
= 
33.05555547 
4 
74732 
2365 
 
2485 
= 
120 
* 
(55 
/ 
162) 
= 
40.74074064 
5 
74733 
2375 
 
2528 
= 
153 
* 
(56 
/ 
162) 
= 
52.88888884 
Step 4 
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Rise Community

127 
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 
2010 
2330 
 

= 
106 
* 
(37 
/ 
143) 
= 
27.42657335 
4 
2011 
2366 
 

= 
119 
* 
(54 
/ 
143) 
= 
44.93706286 
5 
2013 
2421 
 

= 
107 
* 
(52 
/ 
143) 
= 
38.90909084 
Step 4 
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Rise Community

111 
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 
2068 
2321 
 

= 
115 
* 
(41 
/ 
115) 
= 
40.99999999 
4 
2070 
2328 
 

= 
157 
* 
(34 
/ 
115) 
= 
46.41739116 
5 
2071 
2417 
 

= 
111 
* 
(40 
/ 
115) 
= 
38.60869555 
Step 4 
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Rise Community

126 
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 
2071 
2349 
 

= 
87 
* 
(43 
/ 
119) 
= 
31.43697472 
4 
2073 
2364 
 

= 
121 
* 
(44 
/ 
119) 
= 
44.73949578 
5 
2075 
2384 
 

= 
144 
* 
(32 
/ 
119) 
= 
38.72268907 
Step 4 
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Rise Community

115 
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 
2081 
2366 
 

= 
70 
* 
(37 
/ 
126) 
= 
20.55555551 
4 
2082 
2393 
 

= 
92 
* 
(42 
/ 
126) 
= 
30.66666664 
5 
2083 
2393 
 

= 
135 
* 
(47 
/ 
126) 
= 
50.35714286 
Step 4 
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Rise Community

102 
Last steps
Compute the average
2015 
2016 
2017 
2018 
2019 
Sum 
Average 
127

111

126

115

102

581.0 
116.2 
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3: 86.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3: 146.2
You know have all of the data necessary to plot the chart in this page!