Please help me with the question below. I have asked this on here twice before but the solutions didnt explain how to get to the F-statistic, F critical and P-value. I'm seeing two answers: F=12.07 p=0.0033 and F=13.55 p-value 0.00083. Can you help with solving this by using ANOVA formulas? I'm using excel ANOVA formulas and getting the F=13.55 p-value = 0.00083. Is this correct? Thank you!! 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 placed the granola bars at one of three locations in five stores for each treatment in similar stores. The data have been collected and now requires analysis. 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 the information contained in the accompanying Excel file, 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.

Excel data:

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