Conduct an analysis of variance (ANOVA).

Here is the situation: Try to determine whether the property taxes assessed in three counties (A, B, and C) are significantly different from each other. Each county has 5 large business that contribute tens of thousands of dollars in property taxes to their local governments.

This assignment is by hand, here are the data:

County Property Taxes (in thousands $)
County 1	County 2	County 3
30	30	40
34	35	41
36	37	43
38	38	44
40	40	50

If you want to use the Data Analysis tools for this assignment it is listed below. The data set is below (It is "ANOVA Data File Week 7").

Tell me the following:

1. What is the average amount of tax collected in each county? (5 pts)
2. What is the grand mean for all counties? (5 pts)
3. What is the value of k? (5 pts)
4. What is the value of N? (5 pts)
5. What is the value of the sums of squares within groups? (10 pts)
6. What is the value of the sums of squares between groups? (10 pts)
7. What is the value of the degrees of freedom between groups? (5 pts)
8. What is the value of the degrees of freedom within groups? (5 pts)
9. Fill out the following table using the answers from questions 1 - 8 and solve for the F ratio. (25 pts)
10. Is the F ratio significant? What is the critical value for F in Table A.4 in the Appendix of your text? (15 pts)
11. What does your finding mean? Are there significant differences, or not? (10 pts)

Source of Variation	Sum of Squared Deviation	Degrees of Freedom	Variance Estimate	F Ratio
Between Groups (stresses)
Within Groups (error)
Total

ANOVA data for Week 7 below:

County Property Taxes (in thousands $)
County 1	County 2	County 3
30	30	40
34	35	41
36	37	43
38	38	44
40	40	50

Stress Anxiety Below:

No Stress	Mental Math	Role Playing	Mock Interview
10	17	15	16
10	14	11	20
12	14	12	14
11	13	14	16
7	11	16	19
7	17	17	16
12	14	10	18