for anyone
ScatterPlot
| Advertisement ($'000) | Sales ($'000) | |
| 1068 | 4489 | |
| 1026 | 5611 | |
| 767 | 3290 | |
| 885 | 4113 | |
| 1156 | 4883 | |
| 1146 | 5425 | |
| 892 | 4414 | |
| 938 | 5506 | |
| 769 | 3346 | |
| 677 | 3673 | |
| 1184 | 6542 | |
| 1009 | 5088 | |
| Slope | 4.9215957983 | |
| Intercept | -25.1682340648 |
Scatter Plot of Sales & Advertisement
Sales ($'000)
y = 4.9216x - 25.168
R² = 0.6785
1068 1026 767 885 1156 1146 892 938 769 677 1184 1009 4489 5611 3290 4113 4883 5425 4414 5506 3346 3673 6542 5088
Advertisement ($'000)
Sales ($'000)
Regression
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.8237332977 | |||||||
| R Square | 0.6785365458 | |||||||
| Adjusted R Square | 0.6463902004 | |||||||
| Standard Error | 592.7335727464 | |||||||
| Observations | 12 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 7415845.78405917 | 7415845.78405917 | 21.1077351717 | 0.0009886904 | |||
| Residual | 10 | 3513330.8826075 | 351333.08826075 | |||||
| Total | 11 | 10929176.6666667 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | -25.1682340648 | 1042.2599271088 | -0.0241477518 | 0.9812098234 | -2347.4680715242 | 2297.1316033947 | -2347.4680715242 | 2297.1316033947 |
| X Variable 1 | 4.9215957983 | 1.0712359149 | 4.5943155281 | 0.0009886904 | 2.5347334365 | 7.30845816 | 2.5347334365 | 7.30845816 |