Chi Square.xlsx - No HS Diploma Data HS...

No HS Diploma HS Diploma
Data
"Disconnected" 22 38
"Casually Involved" 25 32
"Enthusiastic" 33 31
Total 80 101
No HS Diploma HS Diploma
"Disconnected" 24.62 31.08
"Casually Involved" 31.10 39.27
"Enthusiastic" 24.28 30.66
Total 80 101
Calculations
DF 6.00
P-Value 0.0577080534
By Hand
(Obs - Exp)
-2.62 6.92 2.54
-6.10 -7.27 6.40
8.72 0.34 -8.94
(Obs - Exp)^2
6.84 47.93 6.44
37.23 52.80 41.00
75.99 0.12 79.96
( (Obs - Exp)^2 ) / Exp
0.278 1.542