Questions: Conduct an ANOVA test at a signicance of 5%. Interpret the results and explain where the granola bar should be shelved and why. With the information contained in the accompanying Excel le, complete the following: 1. Conduct an ANOVA test at a signicance of 5%. 2. Interpret the results and explain which location you would recommend and why. Store Aisle End-Cap Checkout Lane 1 738 712 833 2 726 685 795 3 722 725 782 4 715 699 754 5 767 632 772 Answers: Attached are the supporting data and calculations using Microsoft Excel. H0 = There is no difference in sales of the granola bars at the three different locations Ha = There is a difference in sales of the granola bars at the three different locations 1) Using the ANOVA function on excel and the data with a significance of 5% provided we come up with: ANOVA SUMMARY Aim Mun cementum mm Sourceormm \" Bemeeuswm \"Mm a Tomftm 337913333 n As we're testing the difference in sales based on location, we'll be looking at these two values: F = 13 .553 p-value = 0.00le From the F-table with a = 0.05 we conclude: Do not reject if F 3.89 So, since F: 13.553 > 3.89 and p-value: 0.0008 49.58 787.2 - 690.6 = 96.6 > 49.58 |733.6 - 690.6 = 43