1. The marketing manager of a large supermarket chain would liketo use shelf space to predict the sales of a specialty pet food.Data are collected from a random sample of 8 equal-sized stores,with the following results:
Store | Shelf Space (in square feet) | Weekly Sales (in Dollars) |
1 | 4 | 120 |
2 | 4 | 150 |
3 | 8 | 160 |
4 | 8 | 180 |
5 | 12 | 200 |
6 | 16 | 210 |
7 | 16 | 240 |
8 | 20 | 260 |
Use Excel to find the regression results for this problem.Include Excel results with your submission.
a. at the 0.05 level of significance, is there evidence of alinear relationship between shelf space and weekly sales?
b. construct a 95% confidence interval estimate of thepopulation slope, β1.
