Population Size
SpEd Teacher
School Year Grad Rate WA IEP Grad Rate WA WA (US
Attrition rate WA
2011 76% 56% 10% Census)
6827000
2012 79% 55% 12% 6897000
2013 78% 54% 14% 6964000
2014 78% 55% 15% 7055000
2015 80% 57% 17% 7164000
2016 79% 58% 18% 7295000
2017 82% 59% 19% 7423000
2018 80% 69% 21% 7524000
2019 80% 65% 25% 7615000
2020 82% 64% 30% 7705000
x 79% 59% 18% 7246900
r
F-Test Two-Sample for Variances
IEP Grad Teacher Attrition
Mean 0.586 0.226
Variance 0.00322666667 0.0358044444444
Observations 10 10
df 9 9
F 11.0964187328
P(F<=f) one-tail 0.00069655204
F Critical one-tail3.17889310446
Group 1 Group 2 Group 3
Mean 0.586 Mean 0.181 Mean
Standard Error 0.01796292478 Standard Error 0.0191166012786 Standard Error
Median 0.575 Median 0.175 Median
Mode 0.52 Mode 0.1 Mode
Standard Deviati 0.05680375574 Standard Deviation 0.0604520011616 Standard Deviati
Sample Variance 0.00322666667 Sample Variance 0.0036544444444 Sample Variance
Kurtosis -0.8976048995 Kurtosis -0.3693476536815 Kurtosis
Skewness 0.59626947908 Skewness 0.6257544631845 Skewness
Range 0.17 Range 0.2 Range
Minimum 0.52 Minimum 0.1 Minimum
Maximum 0.69 Maximum 0.3 Maximum
Sum 5.86 Sum 1.81 Sum
Count 10 Count 10 Count
Largest(1) 0.69 Largest(1) 0.3 Largest(1)
Smallest(1) 0.52 Smallest(1) 0.1 Smallest(1)
Confidence Level 0.04063393215 Confidence Level 0.0432436637523 Confidence Level
1 2 3 4
Teacher Attrition 1 0.9498519099859 0.958514475634 0.98425098425
Population 0.94985190999 1 0.9494375140339 0.98527266184
Class Size 0.95851447563 0.9494375140339 1 0.9661226995
Pay 0.98425098425 0.9852726618369 0.9661226995004 1
IEP Graduation Rates vs Teacher Attrition
Anova: Two-Way Without Replication
SUMMARY Count Sum Average Variance
Row 1 2 0.62 0.31 0.0882
Row 2 2 0.65 0.325 0.08405
Row 3 2 0.68 0.34 0.08
Row 4 2 0.7 0.35 0.08
Row 5 2 0.74 0.37 0.08
Row 6 2 0.76 0.38 0.08
Row 7 2 0.78 0.39 0.08
Row 8 2 0.9 0.45 0.1152
Row 9 2 0.9 0.45 0.08
Row 10 2 0.94 0.47 0.0578
Column 1 10 5.86 0.586 0.00322666667
Column 2 10 1.81 0.181 0.00365444444
ANOVA
Source of Variation SS df MS F
Rows 0.056805 9 0.0063116666667 11.083902439
Columns 0.820125 1 0.820125 1440.2195122
Error 0.005125 9 0.0005694444444
Total 0.882055 19
Group 1 Group 2
Group 1 0.002904 0.002584
Group 2 0.002584 0.003289
Elementary Avg Teacher IEP Grad Rate SpEd Teacher
Grad Rate TX
Class Size WA Pay WA TX Attrition rate TX
19 48000 89% 78% 12%
19 50000 90% 81% 15%
19 53000 88% 77% 19%
19 54000 90% 81% 23%
19 58000 89% 77% 27%
20 60000 91% 82% 29%
21 62000 92% 82% 30%
22 67000 90% 77% 31%
23 70000 90% 78% 32%
24 75000
20.5 59700 Slope 0.9231433506
Intercept -0.3655008636
R² 0.6
IEP Grad Rates & Teacher Att
0.35
0.3
f(x) = 0.923143350604491 x − 0.36550086355785
Teacher Attrition Rate
0.25
R² = 0.600085279292308
0.2
0.15
0.1
0.05
0
0.52 0.54 0.56 0.58 0.6 0.62 0.64 0.66 0.68 0.7
IEP Graduation Rate
Group 4 Group 5
7246900 Mean 20.5 Mean 59700
98766.7791652 Standard Error 0.60092521258 Standard Error 2808.91438104
7229500 Median 19.5 Median 59000
6827000 Mode 19 Mode 48000
312327.979321 Standard Deviati 1.90029237517 Standard Deviati 8882.56719648
97548766667 Sample Variance 3.61111111111 Sample Variance 78900000
-1.4023017829 Kurtosis -0.9207100592 Kurtosis -1.0249186893
0.09883292829 Skewness 0.76804642554 Skewness 0.34599243196
878000 Range 5 Range 27000
6827000 Minimum 19 Minimum 48000
7705000 Maximum 24 Maximum 75000
72469000 Sum 205 Sum 597000
10 Count 10 Count 10
7705000 Largest(1) 24 Largest(1) 75000
6827000 Smallest(1) 19 Smallest(1) 48000
223420.33115 Confidence Level 1.35935292337 Confidence Level 6354.04522135
P-value F crit
0.00069962179 3.17889310446
3.0400016E-11 5.1173550292
tes & Teacher Attrition Rate
0604491 x − 0.365500863557858
292308
SpEd Teacher Attrition rate
WA
Linear (SpEd Teacher Attrition
rate WA)
.62 0.64 0.66 0.68 0.7
on Rate
SpEd Teacher
Elementary
Attrition rate
Class Size WA
WA
10% 19 Slope 0.03
12% 19 Intercept -0.434
14% 19 R² 0.889
15% 19
17% 19
18% 20
19% 21
21% 22
25% 23
30% 24
SpEd Teacher
Elementary
Attrition rate
Class Size WA Predicted Residual
WA 10% 19 -0.431 19.431
12% 19 -0.4304 19.4304
14% 19 -0.4298 19.4298
15% 19 -0.4295 19.4295
17% 19 -0.4289 19.4289
18% 20 -0.4286 20.4286
19% 21 -0.4283 21.4283
21% 22 -0.4277 22.4277
25% 23 -0.4265 23.4265
30% 24 -0.425 24.425
Class Size Variable
0.35
0.3
f(x) = 0.03 x − 0.434
Teacher Attrition Rate
0.25 R² = 0.889328063241107
SpEd Teacher Attrition rate
0.2 WA
Linear (SpEd Teacher Attrition
0.15 rate WA)
0.1
0.05
0
18 19 20 21 22 23 24 25
Average Class Size
Residual Class Size
30
25
20
Residual
Residual
15
Linear (Residual)
10
0
0.05 0.1 0.15 0.2 0.25 0.3 0.35
SpEd Teacher Attrition rate WA
Population Size
IEP Grad Rate WA
WA (US Census)
56% 6827000 Slope 1.3929443E-07
55% 6897000 Intercept 4120955.959
54% 6964000 R² 0.736 0.8
55% 7055000
57% 7164000 0.7
58% 7295000 0.6 f(x) = 1.
R² = 0.7
59% 7423000
IEP Grad Rates
0.5
69% 7524000
65% 7615000 0.4
64% 7705000
0.3
0.2
0.1
0
6600000 6800000 70000
Population Variable
0.8
0.7
0.6 f(x) = 1.3929443153732E-07 x − 0.417452815907804
R² = 0.735517902485403
IEP Grad Rates
0.5
Column A
0.4
Linear (Column A)
0.3
0.2
0.1
0
6600000 6800000 7000000 7200000 7400000 7600000 7800000
Population
Avg Teacher Pay
IEP Grad Rate WA
WA
56% 48000 y Slope 4.8528376E-06
55% 50000 x Intercept 0.3022855936
54% 53000 R2 0.722
55% 54000
57% 58000
58% 60000
59% 62000
69% 67000
65% 70000
64% 75000
Mean
IEP Grad Rate WA Avg Teacher Pay
WA Predicted IEP Grad Rate WA
56% 48000 0.30228831119 56%
55% 50000 0.30228826266 55%
54% 53000 0.30228821413 54%
55% 54000 0.30228826266 55%
57% 58000 0.30228835972 57%
58% 60000 0.30228840825 58%
59% 62000 0.30228845677 59%
69% 67000 0.30228894206 69%
65% 70000 0.30228874794 65%
64% 75000 0.30228869942 64%
Slope
Intercept
R²
Slope
Intercept
R²
Teacher Attrition
0.226
0.0358044444444
10
9
Group 2 Group 4
Mean Mean
Standard Error Standard Error
Median Median
Mode Mode
Standard DeviationStandard Deviation
Sample Variance Sample Variance
Kurtosis Kurtosis
Skewness Skewness
Range Range
Minimum Minimum
Maximum Maximum
Sum Sum
Count Count
Largest(1) Largest(1)
Smallest(1) Smallest(1)
Confidence Level Confidence Level
2
0.9498519099859
1
0.9494375140339
0.9852726618369
Sum
0.62
0.65
0.68
0.7
0.74
0.76
0.78
0.9
0.9
0.94
5.86
1.81
df F crit
9 3.17889310446
1 5.1173550292
9
19
Group 2
0.002584
0.003289
IEP Grad + Pay
0.8
0.7
f(x) = 4.85283762850303E-06 x + 0.302285593578369
0.6 R² = 0.722058655778127
0.5 Column C
Linear (Column C)
0.4
0.3
0.2
Residual
47999.6977117 0.1
49999.6977117
0
52999.6977118 45000 50000 55000 60000 65000 70000 75000 80000
53999.6977117
57999.6977116 Residual vs. IEP Grad Rate WA
59999.6977116 80000
61999.6977115
70000
66999.6977111
69999.6977113 60000
74999.6977113
50000
Residual
Residual
40000
Linear (Residual)
30000
20000
10000
0
0.52 0.54 0.56 0.58 0.6 0.62 0.64 0.66 0.68 0.7
IEP Grad Rate WA
Column C
Linear (Column C)
000
WA
Residual
Linear (Residual)
States 2015 2016 2017 2018 2019
New York x 22% x x
California 31%
Washington 25%
Ohio 15%
Kansas 13%
Texas 31%
State Graduation
Rates
Education
Dropout Rate
State Total
Student Dropout Rate with IEP Graduation Rates
NY 2019 12% 87%
CA 2019 32% 83%
WA 2018 50% 80%
OH 2018 26% 89%
KA Unavailable** 20% 90%
TX 2018 26% 84%
New York California Washinton Ohio Kansas Texas
Washington
Washington OSPI Data report (2018) p.13 for historical graduation rate data
https://www.k12.wa.us/sites/default/files/public/specialed/data/pubdocs/WA-State-APR-FFY-2018.pdf
Graduation Rates (2013-2018)
https://www.k12.wa.us/sites/default/files/public/specialed/data/pubdocs/FFY-2019-Washington-State.pdf
https://www.k12.wa.us/sites/default/files/public/communications/2019-01-GraduationDropoutStatistics.pdf
Texas
Texas Teacher Attrition Rates
https://tea.texas.gov/sites/default/files/employed-teacher-attrition-and-new-hires-tgs210519.pdf
Texas Attrition Rates (2011-2018)
https://tea.texas.gov/sites/default/files/Employed%20Teacher%20Attrition%20and%20New%20Hires%202011-201
Texas Teacher Attrition, Special Educators at twice the rate of others
https://files.eric.ed.gov/fulltext/ED578907.pdf
Texas Dropout Rates (2018)
https://tea.texas.gov/sites/default/files/dropcomp_2017-18_v3.pdf
All Reports https://tea.texas.gov/reports-and-data/school-performance/accountability-research/completion-graduatio
Washington teacher attrition rates
FY-2018.pdf https://ies.ed.gov/ncee/edlabs/regions/northwest/wamaps/teacher-turnover.asp
Washington Schools/Class size
ington-State.pdf http://www.wsipp.wa.gov/ReportFile/1122/Wsipp_K-12-Class-Size-Reductions-and-Student-Outcom
poutStatistics.pdf
2020 Report Card
https://washingtonstatereportcard.ospi.k12.wa.us/ReportCard/ViewSchoolOrDistrict/103300
w%20Hires%202011-2018.pdf
rch/completion-graduation-and-dropout-reports
uctions-and-Student-Outcomes-A-Review-of-the-Evidence-and-Benefit-Cost-Analysis_Full-Report.pdf
oolOrDistrict/103300
