* REQUIRE all relative data in Excel.docThe marketing manager of a large superma

* REQUIRE all relative data in Excel.docThe 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.doc.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.
3.4
5
05.0999999999999996
5
13.5
5
04.3
10
05.2
10
05.2
10
14.7
15
05.6
15
05.7
15
15.8
20
06.4
20
07.1
20
14.4000000000000004
10
05.4
10
06.1
10
15
15
05.8
15
03.2
5
04.2
10
05
10
0Sales
Space
Place
Place = 1 indicates front of aisle
Place = 0 indicates back of aisle
Space = feet of shelf space
Sales given in 1000/week
Attachments: