Question
TASKistogothroughthisanswersandsummarizeintoaSHORTREPORT (half page not full page) andassumethereaderishavingnobackgroundonstatistic,henceclearreportisappreciated.Pleasedon'tbetoolong as it is brief report. Tables can mention as appendix. Regression Analysis The manager of a fast-food restaurant
TASKistogothroughthisanswersandsummarizeintoaSHORTREPORT (half page not full page) andassumethereaderishavingnobackgroundonstatistic,henceclearreportisappreciated.Pleasedon'tbetoolong as it is brief report. Tables can mention as appendix.
Regression Analysis
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 |
1. Interpret the value of intercept coefficient & the slope of the regression line
The expected sales value when the number of vouchers in 0 is 11.5676. While each increase of 1 in number of vouchers is estimated to result in an increase in sales by 0.4618.
2. Determine the coefficient of determination and discuss what the coefficients tell you about the relationship between the two variables.
The coefficient of the determination is 0.7267 and this indicates a very strong correlation between number of vouchers and sales. This also indicates that the percentage of variation in sales that can be explained by the number of vouchers is 72.67%.
3. Use the regression equation toPredict weekly sales in the fast-food restaurant if 10 vouchers are printed in the local newspaper.
predicted weekly sales = 16.1853
4. Plot the residuals against the predicted values.Plot the residuals against the predicted values ofy. Does the variance appear to be constant
Explanation:
Here are the results using excel:
Regression Statistics | |
Multiple R | 0.85244715 |
R Square | 0.72666614 |
Adjusted R Square | 0.69249941 |
Standard Error | 1.43011209 |
Observations | 10 |
Coefficients | Standard Error | t Stat | P-value | |
Intercept | 11.5676471 | 0.8341319 | 13.8678872 | 7.0696E-07 |
Number of vouchers | 0.46176471 | 0.10012787 | 4.61174984 | 0.00172871 |
Observation | Predicted Sales | Residuals |
1 | 13.4147059 | -0.6147059 |
2 | 14.8 | 0.6 |
3 | 13.8764706 | 0.02352941 |
4 | 12.9529412 | -1.7529412 |
5 | 20.3411765 | -1.6411765 |
6 | 16.1852941 | 1.71470588 |
7 | 15.2617647 | 1.53823529 |
8 | 14.3382353 | 1.56176471 |
9 | 12.9529412 | -1.4529412 |
10 | 13.8764706 | 0.02352941 |