Question

Amount Spent on Energy: The table to the right shows the amount spent (in dollars) on energy in one year for a random sample of households from four regions in the United States. Conduct a test at the alpha equal .05 level to determine if there is a difference in the mean amount spent in dollars on energy Run the ANOVA analysis using excel data analysis tools on this sheet to show the work. Answer the following questions on the answer sheet: 2a. State the Null Hypothesis 2b. What is the Resulting F value? 2c. What is the resulting F critical value? 2d. What is the p value? 2e. What is the decision (accept or reject the null hypothesis?

Northeast	Midwest	South	West
2826	1695	1227	840
776	1325	1972	1694
2345	1727	1653	1599
1349	1679	1080	661
1056	1575	1646	1002
1276	1899	1348	856
2396	1074	1750	1491
2343	1410
1029	1485
2745
1004

Answer 1

2a. State the Null Hypothesis

• The null hypothesis (H0) is that there is no difference between the groups and equality between means. (mean amount spent in dollars on energy same in different four regions in the United States)
• The alternative hypothesis (H1) is that there is a difference between the means and groups. (mean amount spent in dollars on energy not same in different four regions in the United States

2b. What is the Resulting F value?

Using Excel Output:

2c. What is the resulting F critical value?

F_critical =2.922

2d. What is the p value?

P-value = 0.1841

2e. What is the decision (accept or reject the null hypothesis?

P-value > 0.05 so we do not reject the null hypothesis means we accept the null hypothesis.

Hope this will b helpful.Thanks and God Bless You :)