Question

Question 5 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 High School Junior College 80 Bachelor Graduate 202 199 62 465 877 358 108 138 229 276 64 12 49 11 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.

Answer 1

Ans:

a,b)

	Observed(fo)
	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
	Expected(fe)
	Excellent	good	fair	poor	Total
Less than high school	148.64	249.76	106.91	29.70	535
high school	502.31	844.04	361.29	100.36	1808
junior college	77.24	129.78	55.55	15.43	278
Bachelor	161.42	271.23	116.10	32.25	581
Graduate	86.40	145.19	62.15	17.26	311
Total	976	1640	702	195	3513
	Chi square=(fo-fe)^2/fe
	Excellent	good	fair	poor	Total
Less than high school	39.514	9.132	79.328	35.138	163.112
high school	2.771	1.287	0.030	0.582	4.670
junior college	0.099	0.521	0.773	1.272	2.665
Bachelor	28.297	0.084	23.380	12.715	64.476
Graduate	21.997	0.023	14.624	13.495	50.139
Total	92.677	11.046	118.135	63.203	285.061

c)

Test statistic:

Chi square=285.061

df=(5-1)*(4-1)=12

p-value=CHIDIST(285.061,12)=0.0000

d)Reject the null hypothesis.

There is sufficient evidence to conclude that education play a role in the healthiness of an individual.