Question

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 sell 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.

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.

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

Please help me solve this using EXCEL. I need the Excel step by step analysis, and a brief explanation on #2. Thanks.

Answer 1