Sheet2
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.9923987915 |
| R Square | 0.9848553615 |
| Adjusted R Square | 0.9772830422 |
| Standard Error | 1.249867779 |
| Observations | 10 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 3 | 609.5269832094 | 203.1756610698 | 130.0599362677 | 0.0000075552 |
| Residual | 6 | 9.3730167906 | 1.5621694651 |
| Total | 9 | 618.9 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | -10.1702433155 | 3.4731285927 | -2.9282656959 | 0.0263464283 | -18.6686828296 | -1.6718038014 | -18.6686828296 | -1.6718038014 |
| Food Sales | 0.0270381153 | 0.0120409964 | 2.245504802 | 0.0658468117 | -0.0024251416 | 0.0565013721 | -0.0024251416 | 0.0565013721 |
| Non Food Sales | 0.097052345 | 0.0301471217 | 3.2192905781 | 0.0181533886 | 0.0232849955 | 0.1708196945 | 0.0232849955 | 0.1708196945 |
| Store Size | 0.5246751681 | 0.0591582486 | 8.8690111744 | 0.0001143334 | 0.3799201484 | 0.6694301877 | 0.3799201484 | 0.6694301877 |
| RESIDUAL OUTPUT |
| Observation | Predicted Profit | Residuals |
| 1 | 19.8368448056 | 0.1631551944 |
| 2 | 14.39869518 | 0.60130482 |
| 3 | 17.1615346474 | -0.1615346474 |
| 4 | 10.3322077695 | -1.3322077695 |
| 5 | 16.2773791201 | -0.2773791201 |
| 6 | 28.7110979942 | -1.7110979942 |
| 7 | 34.864915814 | 0.135084186 |
| 8 | 6.9302748479 | 0.0697251521 |
| 9 | 21.4501346144 | 0.5498653856 |
| 10 | 21.0369152069 | 1.9630847931 |
Sheet3
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.9859655574 |
| R Square | 0.9721280803 |
| Adjusted R Square | 0.9641646747 |
| Standard Error | 1.5698012203 |
| Observations | 10 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 2 | 601.6500689004 | 300.8250344502 | 122.0744146159 | 0.0000036148 |
| Residual | 7 | 17.2499310996 | 2.4642758714 |
| Total | 9 | 618.9 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | -3.7583583133 | 2.4832522808 | -1.5134822758 | 0.1739235067 | -9.6303168792 | 2.1136002526 | -9.6303168792 | 2.1136002526 |
| Non Food Sales | 0.0431137431 | 0.0228799281 | 1.8843478394 | 0.101515211 | -0.0109886898 | 0.0972161761 | -0.0109886898 | 0.0972161761 |
| Store Size | 0.6337820234 | 0.0423843528 | 14.9532075202 | 0.0000014354 | 0.5335589548 | 0.7340050919 | 0.5335589548 | 0.7340050919 |
| RESIDUAL OUTPUT |
| Observation | Predicted Profit | Residuals |
| 1 | 19.9329935147 | 0.0670064853 |
| 2 | 14.4099930285 | 0.5900069715 |
| 3 | 16.9321969983 | 0.0678030017 |
| 4 | 9.6587985392 | -0.6587985392 |
| 5 | 17.9971164531 | -1.9971164531 |
| 6 | 28.7153729836 | -1.7153729836 |
| 7 | 33.6304396938 | 1.3695603062 |
| 8 | 6.3045093261 | 0.6954906739 |
| 9 | 22.929448659 | -0.929448659 |
| 10 | 20.4891308035 | 2.5108691965 |
Sheet1
| Supermarket Number | Food Sales | Non Food Sales | Store Size | Profit |
| 1 | 305 | 35 | 35 | 20 |
| 2 | 130 | 98 | 22 | 15 |
| 3 | 189 | 83 | 27 | 17 |
| 4 | 175 | 76 | 16 | 9 |
| 5 | 101 | 93 | 28 | 16 |
| 6 | 269 | 77 | 46 | 27 |
| 7 | 421 | 44 | 56 | 35 |
| 8 | 195 | 57 | 12 | 7 |
| 9 | 282 | 31 | 40 | 22 |
| 10 | 203 | 92 | 32 | 23 |