In: Statistics and Probability
| 85 | 1,810 |
| 90 | 4,825 |
| 79 | 438 |
| 82 | 775 |
| 84 | 1,213 |
| 96 | 8,692 |
| 88 | 2,356 |
| 76 | 266 |
| 93 | 4,930 |
| 97 | 9,138 |
| 89 | 2,714 |
| 83 | 1,082 |
| 85 | 1,290 |
| 90 | 3,970 |
| 82 | 894 |
| 91 | 2,906 |
| 90 | 4,615 |
| 84 | 1,168 |
| 79 | 462 |
| 81 | 1,018 |
| 95 | 5,950 |
What is multiple R, R square, & Adjusted R square?
Do regression model results indicate significance, meaning the results can be accepted? Yes or No.
For every 1 increase in Temperature, how much do sales increase?
You didn't mention which column represent temperature and which is sales.
I assume first one is temperature and other one is sale.
I used excel for calculation purpose.
output is as follows:
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.922351 | |||||||
| R Square | 0.850732 | |||||||
| Adjusted R Square | 0.842876 | |||||||
| Standard Error | 1041.057 | |||||||
| Observations | 21 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 1.17E+08 | 1.17E+08 | 108.2876 | 2.7611E-09 | |||
| Residual | 19 | 20592210 | 1083801 | |||||
| Total | 20 | 1.38E+08 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | -32511.2 | 3408.723 | -9.53766 | 1.12E-08 | -39645.78693 | -25376.7 | -39645.8 | -25376.7 |
| X Variable 1 | 408.6026 | 39.26555 | 10.40613 | 2.76E-09 | 326.4188809 | 490.7864 | 326.4189 | 490.7864 |
Highlighted column gives multiple R, R square, & Adjusted R square.
Since calculated value of f is greater than significant f.
We conclude that regression is significant. that is we can accept the result.
If we increase temperature by 1 sales will increased by 408.606