PETFOOD

The marketing manager of a large supermarket chain would like to determine the effect of shelf space and whether the product was placed at the front or back of the aisle on the sales of pet food. A random sample of 12 equal-sized stores is selected with the following results

USE EXCEL FILE PETFOOD

0 indicates Back of Store

1 indicates Front of Store

1. State the multiple regression equation.
2. Interpret the meaning of the slopes in this problem.
3. Predict the weekly sales of the pet food for a store with 8 feet of shelf space situated at the back of the aisle, and construct a 95% confidence interval estimate and a 95% prediction interval.
   
4. Perform a residual analysis on the results and determine the adequacy of the model.
5. Is there a significant relationship between sales and the two independent variables (shelf space and aisle position) at the 0.05 level of significance?
6. At the 0.05 level of significance, determine whether each independent variable makes a contribution to the regression model. Indicate the most appropriate regression model for this set of data.
7. Construct 95% confidence interval estimates of the population slope for the relationship between sales and shelf space, and between sales and aisle location.
8. Compare the slope in (b) with the slope for the simple linear regression model of problem 12.4 on page 419. Explain the difference in the results.

Price: $23.45

Solution: The downloadable solution consists of 12 pages, 1145 words and 4 charts.
Deliverable: Word Document