Question

# Does amount of education play a role in the healthiness of an individual? The following data...

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 P-value (=CHISQ.TEST(actual range, expected range)

d) use P-value 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 Ei=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

#### Earn Coins

Coins can be redeemed for fabulous gifts.