Statistics homework help

Problem 1
A popular consumer staple was displayed in different locations in the same aisle of a grocery store to determine what, if any, effect different placement might have on its sales. The product was placed at one of three heights on the aisle – low, medium, and high – and at one of three locations in the store – at the front of the store, at the middle of the store, and at the rear of the store. The number of units sold of the product at various height and distance combinations was recorded each week for five weeks, and the following results were obtained:

The data can be found in staple.xlsx. What effect does the product location have on the sales?
Where would you suggest to place the staples?

For this you should:

(a) Produce a profile plot of the mean number of items sold.
Comment on this graph and relate it to your future planned tests.

(b) Analyze the data with an analysis of variance. Perform all the necessary tests (including testing for interaction and, if necessary, for main effects), and state the hypotheses and conclusions for all of them. When testing for interaction, make sure you explain what interaction means in the context of this problem.

(c) Perform any relevant comparison of means procedures. Use Tukey’s Method.

(d) State your recommendations on where the product should be placed.