Question

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.

Answer 1

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