Question
Regression Analysis. Report Brief The manager of a fast-food restaurant wants to determine how sales in each week are related to the number of discount
Regression Analysis.
Report Brief
The manager of a fast-food restaurant wants to determine how sales in each week are related to the number of discount vouchers (#) printed in the local newspaper during the week. The number of vouchers and sales ($000s) from 10 randomly selected weeks is given below:
Number of vouchers | Sales |
4 | 12.8 |
7 | 15.4 |
5 | 13.9 |
3 | 11.2 |
19 | 18.7 |
10 | 17.9 |
8 | 16.8 |
6 | 15.9 |
3 | 11.5 |
5 | 13.9 |
Your task is in four parts:
Using the above data, run the least square regression analysis to estimate the impact of number of vouchers have on restaurant's weekly sales. Present the excel summary output in an appropriate table.
- Interpret the value of intercept coefficient & the slope of the regression line
- Determine the coefficient of determination and discuss what the coefficients tell you about the relationship between the two variables.
- Use the regression equation toPredict weekly sales in the fast-food restaurant if 10 vouchers are printed in the local newspaper.
- Plot the residuals against the predicted values.Plot the residuals against the predicted values of y. Does the variance appear to be constant
Guidelines:
Your report should be understandable to a person who has no background in statistics, while also allowing a data analyst to verify your interpretation of your results.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started