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 |
3097014 |
2428 |
- |
2436 |
= |
-8 |
* |
(37 |
/ |
175) |
= |
-1.69142857 |
4 |
3097015 |
2466 |
- |
2485 |
= |
-19 |
* |
(34 |
/ |
175) |
= |
-3.69142857 |
5 |
3097018 |
2468 |
- |
2528 |
= |
-60 |
* |
(24 |
/ |
175) |
= |
-8.22857142 |
6 |
3097019 |
2514 |
- |
2552 |
= |
-38 |
* |
(22 |
/ |
175) |
= |
-4.77714283 |
7 |
3097022 |
2512 |
- |
2567 |
= |
-55 |
* |
(32 |
/ |
175) |
= |
-10.05714281 |
8 |
3097023 |
2506 |
- |
2586 |
= |
-80 |
* |
(26 |
/ |
175) |
= |
-11.88571424 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Twain Harte
|
-40 |
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 |
95465 |
2427 |
- |
2436 |
= |
-9 |
* |
(27 |
/ |
169) |
= |
-1.43786982 |
4 |
95467 |
2494 |
- |
2485 |
= |
9 |
* |
(34 |
/ |
169) |
= |
1.81065088 |
5 |
95469 |
2489 |
- |
2528 |
= |
-39 |
* |
(32 |
/ |
169) |
= |
-7.38461537 |
6 |
95471 |
2516 |
- |
2552 |
= |
-36 |
* |
(27 |
/ |
169) |
= |
-5.75147927 |
7 |
95473 |
2579 |
- |
2567 |
= |
12 |
* |
(20 |
/ |
169) |
= |
1.42011834 |
8 |
95475 |
2567 |
- |
2586 |
= |
-19 |
* |
(29 |
/ |
169) |
= |
-3.26035503 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Twain Harte
|
-15 |
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 |
98242 |
2469 |
- |
2436 |
= |
33 |
* |
(29 |
/ |
172) |
= |
5.56395348 |
4 |
98244 |
2494 |
- |
2485 |
= |
9 |
* |
(25 |
/ |
172) |
= |
1.30813953 |
5 |
98246 |
2514 |
- |
2528 |
= |
-14 |
* |
(36 |
/ |
172) |
= |
-2.93023255 |
6 |
98247 |
2494 |
- |
2552 |
= |
-58 |
* |
(32 |
/ |
172) |
= |
-10.79069764 |
7 |
98250 |
2520 |
- |
2567 |
= |
-47 |
* |
(29 |
/ |
172) |
= |
-7.9244186 |
8 |
98252 |
2574 |
- |
2586 |
= |
-12 |
* |
(21 |
/ |
172) |
= |
-1.46511628 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Twain Harte
|
-16 |
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 |
98402 |
2451 |
- |
2436 |
= |
15 |
* |
(31 |
/ |
188) |
= |
2.47340426 |
4 |
98405 |
2543 |
- |
2485 |
= |
58 |
* |
(30 |
/ |
188) |
= |
9.25531914 |
5 |
98406 |
2489 |
- |
2528 |
= |
-39 |
* |
(32 |
/ |
188) |
= |
-6.63829784 |
6 |
98409 |
2517 |
- |
2552 |
= |
-35 |
* |
(35 |
/ |
188) |
= |
-6.51595742 |
7 |
98410 |
2513 |
- |
2567 |
= |
-54 |
* |
(32 |
/ |
188) |
= |
-9.19148931 |
8 |
98413 |
2557 |
- |
2586 |
= |
-29 |
* |
(28 |
/ |
188) |
= |
-4.31914893 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Twain Harte
|
-15 |
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 |
99068 |
2476 |
- |
2436 |
= |
40 |
* |
(25 |
/ |
180) |
= |
5.55555552 |
4 |
99069 |
2494 |
- |
2485 |
= |
9 |
* |
(36 |
/ |
180) |
= |
1.8 |
5 |
99070 |
2560 |
- |
2528 |
= |
32 |
* |
(31 |
/ |
180) |
= |
5.5111111 |
6 |
99071 |
2482 |
- |
2552 |
= |
-70 |
* |
(28 |
/ |
180) |
= |
-10.88888885 |
7 |
99072 |
2568 |
- |
2567 |
= |
1 |
* |
(32 |
/ |
180) |
= |
0.17777778 |
8 |
99073 |
2455 |
- |
2586 |
= |
-131 |
* |
(28 |
/ |
180) |
= |
-20.37777771 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Twain Harte
|
-18 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-40
|
-15
|
-16
|
-15
|
-18
|
-104.0 |
-20.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 9.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -50.8
For the lines, you have the data necessary to plot the chart.