Question: Use regression analysis to develop a straight-line approximation of the relationship between the two variables. Use POM-QM or MS-Excel template file posted in Moodle. Use
- Use regression analysis to develop a straight-line approximation of the relationship between the two variables. Use POM-QM or MS-Excel template file posted in Moodle.
- Use the equation developed in part (a) to forecast sales for an advertising expenditure of $8000.
- Interpret the values of r and r2 obtained from the analysis.
20 points) Denny's collected the following data on the relationship between advertising and sales at a sample of five restaurants.
| Advertising Expenditure ($) | Sales ($) |
| 1000 | 19000 |
| 4000 | 44000 |
| 6000 | 40000 |
| 10000 | 52000 |
| 14000 | 53000 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
