The marketing manager of a large supermarket chain wants to determine how sales of the soft drinks are affected by shelf space and product placement. The soft drinks were placed either at the front or back of the aisle. Data collected from a random sample of 20 equal-sized stores is summarized in the attached Excel spreadsheet 1.xls (see the attached Excel spreadsheet).

a. Write out the multiple regression equation.

b. Estimate the regression coefficients using ordinary least squares and interpret them.

c. Predict the weekly sales for a store with 10 feet of shelf space situated at the back of the aisle.

d. At the 0.05 level of significance determine whether each independent variable makes a contribution to the regression model.

Attachment:- 1.xls