A company is trying to compare electricity usage between three of its stores. To

Question

A company is trying to compare electricity usage between three of its stores. Total electricity usage (in 1000 kwHr) is collected for five months Month Store-an T- Store Jan FebMar Apr May 1 787 64 629 565 667 848 630 765 642 687 724 643 568 565 661 2) (30 pts) Perform an ANOVA analysis( = 0.05) to determine whether there is a statistically significant difference in electricity usage between stores. To remove the effect of month-to- month variation in the analysis, treat the months as blocks. Your analysis should include the following a) Completed ANOVA table * Sums of Squares - Degrees of Freedom Mean Squares . fo fcritical b) c) P-Value Conclusion about electricity use of the different stores, stated using statistical language: "There (is/is not) sufficient evidence at the to conclude that.. 0.05 level of significance

Explanation / Answer

From EXCEL

a) Sum of squares

b) Degrees of freedom

c) Mean sum of squares

d) F cal=1.36

e) f critical=3.885

b)

P value=0.294

P >0.05 we accept the null hypothesis Hence the results are not significant

Anova: Single Factor SUMMARY Groups Count Sum Average Variance store1 5 3291 658.2 6609.2 store2 5 3572 714.4 8381.3 store3 5 3161 632.2 4502.7 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 17652.13 2 8826.067 1.35833 0.293922 3.885294 Within Groups 77972.8 12 6497.733 Total 95624.93 14

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.