Does amount of education play a role in the healthiness of an individual? The following data represent the level of health and the highest degree earned for a random sample of individuals form the General Social Survey.
Excellent 
Good 
Fair 
Poor 

Less than High School 
72 
202 
199 
62 
High School 
465 
877 
358 
108 
Junior College 
80 
138 
49 
11 
Bachelor 
229 
276 
64 
12 
Graduate 
130 
147 
32 
2 
a) copy the table to your Excel; calculate row total, column total and grand total.
b) calculate expected values.
c) use Excel to calculate Pvalue (=CHISQ.TEST(actual range, expected range)
d) use Pvalue approach to draw a conclusion.
a)\
Observed  Oi  Excellent  Good  Fair  Poor  Total 
Less than High School  72  202  199  62  535  
High School  465  877  358  108  1808  
Junior College  80  138  49  11  278  
Bachelor  229  276  64  12  581  
Graduate  130  147  32  2  311  
total  976  1640  702  195  3513 
b)
Expected  E_{i}=row total*column total/grand total  Excellent  Good  Fair  Poor  Total 
Less than High School  148.6365  249.7580  106.9086  29.6968  535  
High School  502.3080  844.0421  361.2912  100.3587  1808  
Junior College  77.2354  129.7808  55.5525  15.4313  278  
Bachelor  161.4165  271.2326  116.1008  32.2502  581  
Graduate  86.4036  145.1865  62.1469  17.2630  311  
total  976  1640  702  195  3513  
c)
p value =0.0000
d)as p value is significantly low we can conclude that amount of education play a role in the healthiness of an individual
Get Answers For Free
Most questions answered within 1 hours.