M5: ANOVA Scenario Assignment Scenario Script Caption: Mieke has been working to tackle a difficult problem and she needs your help. She wants to know the most effective location for displaying Princess' new granola bar in retail grocery stores. Mieke: Where we put our products in our grocery stores has a pretty significant impact on sales. Does the granola bar sells better in the aisles, or in promotional displays at the end of shelves or is most popular when it's stocked in the checkout lanes as an impulse item? Caption: The Marketing Department conducted an experiment where they stocked the granola bar in three different locations in five different grocery stores in a representative market. They have collected data on how many of these granola bars sold at each store, based on where they were located in the store. Assignment Conduct an ANOVA test at a significance of 5%. Interpret the results and explain where the granola bar should be shelved and why. With this information, complete the following: 1. Conduct an ANOVA test at a significance of 5%. 2. Interpret the results and explain which location you would recommend and why. Location (Modules sold) Store Aisle End-Cap Checkout Lane 1 789 612 718 2 762 655 655 3 722 725 725 4 745 609 645 5 802 632 622 Due Dates 11:59pm ET, Sunday. Grading Criteria and Guidelines Grading criteria and detailed instructions for submission of assignments are available on the course website. Store Aisle 1 2 3 4 5 Mean EndCap Checkout Lane 789 762 722 745 802 612 655 725 609 632 718 655 725 645 622 764 646.6 673 Sum 3820 3233 3365 Average 764 646.6 673 Anova: Single Factor SUMMARY Groups Aisle End-Cap Checkout Lane Count 5 5 5 ANOVA Source of Variation SS Between Grou 37934.5333 Within Group 21677.2 Total F from table 59611.7333 3.89 df MS 2 18967.2667 12 1806.43333 14 P<=0.05 differences? kout Lane Variance 1049.5 2260.3 2109.5 F P-value F crit 10.4998432 0.00231222 3.88529383 Anova: Single Factor SUMMARY Groups Aisle End-Cap Checkout Lane Count 5 5 5 ANOVA Source of Variation SS Between Grou 37934.5333 Within Group 21677.2 Total 59611.7333 Sum 3820 3233 3365 df Average 764 646.6 673 Variance 1049.5 2260.3 2109.5 MS F 2 18967.2667 10.4998432 12 1806.43333 14 P-value F crit 0.00231222 3.88529383 MEMORANDUM TO: Mrs. Bonnie Robeson FROM: M. Pappas DATE: September 22nd, 2017 SUBJECT: Granola bar most effective display location analysis It is recommended that the most effective display location for the new granola bars is the aisle. A one-way ANOVA test was conducted and revealed that the three display locations of aisle, end-cap and checkout lane were statistically different. A Tukey test was performed to display significant difference between the aisle and end-cap /check out locations but no significant difference between the end-cap and check out locations. APPENDIX