Question

You want to compare the means of several different groups to determine if all are equal or if any are significantly different from

the rest. For instance on the Insurance file you may wish to see if there is any significant differences in satisfaction among

individuals with different levels of education. You have rearranged the Insurance File to give the following:

	College degree	Graduate degree	Some College
	5	3	4
	3	4	1
	5	5	4
	3	5	2
	3	5	3
	3	4	4
	3	5	4
	4	5
	2
Average	3.444444444	4.5	3.142857143
Count	9	8	7

Use the ANOVA single factor in the Data Analysis add-in in Excel and answer the following questions. Use alpha of .05.

1.  The F value is equal to the variance _________ groups divided by the variance ___________groups.

2.  Our F value is ?

3.  Since the F value is greater than F Crit, you must (reject or fail to reject) the null?

4.  What is the P-value? (four decimals)

5.  Given this P-value you must ("reject" or "fail to reject") the null?

Answer 1