Refer to the FINAL EXAM ANOVA Excel spreadsheet. Thirty hardware stores are incl
ID: 3368491 • Letter: R
Question
Refer to the FINAL EXAM ANOVA Excel spreadsheet. Thirty hardware stores are included in a study of customer behaviors regarding different containers for paint. The company is trying out plastic and metal containers, as well as a novel idea in paint packaging: selling it in a plain brown paper bag. Ten stores are assigned randomly to each type of container and the number of units of paint sold in a given week in each store is recorded. The table shows the number of units of paint sold in the test week per store.
Do sales depend on type of container? If so, which containers are significantly better or worse?
a. State the null and alternate hypotheses. (Plain English is acceptable -- no need for equations).
b. Conduct the appropriate Analysis of Variance test to test these hypotheses.
c. Did you find a significant difference among the containers? If yes, carefully explain your findings, to the best of your abilities.
ANOVA PROBLEM (independent means) Plastic Metal Paper Bag Store 442 370 407 418 427 390 432 426 442 432 365 405 396 370 424 401 391 426 373 320 63 60 62 52 63 71 40 74 49 81 4 8 10Explanation / Answer
a] null hypothesis : sales depend on type of container. Vs H1: sales do not depend on type of container .
b] Analysis of Variance
Source DF Adj SS Adj MS F-Value P-Value
factor 2 781760 390880 694.24 0.000
Error 27 15202 563
Total 29 796962
c] here pvalue = 0.000 < alpha = 005
Reject null hypothesis. Therefore there is significant difference among the containers.