Q. AP-10: The marketing manager of a large supermarket chain wants to determine Elucidate how sales of the soft drinks are affected by shelf space also 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 sodas1.xls (see the side menu bar of this PDF).

a. Write down out the multiple regression equation.

b. Estimate the regression coefficients using ordinary least squares also 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