Statistics project

profilecynthia3232
statisticsexcelsolving.xlsx
Home>Mathematics homework help>Statistics homework help>Statistics project

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
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
X Variable 1 0.0270381153 0.0120409964 2.245504802 0.0658468117 -0.0024251416 0.0565013721 -0.0024251416 0.0565013721
X Variable 2 0.097052345 0.0301471217 3.2192905781 0.0181533886 0.0232849955 0.1708196945 0.0232849955 0.1708196945
X Variable 3 0.5246751681 0.0591582486 8.8690111744 0.0001143334 0.3799201484 0.6694301877 0.3799201484 0.6694301877

Sheet3

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
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
X Variable 1 0.0431137431 0.0228799281 1.8843478394 0.101515211 -0.0109886898 0.0972161761 -0.0109886898 0.0972161761
X Variable 2 0.6337820234 0.0423843528 14.9532075202 0.0000014354 0.5335589548 0.7340050919 0.5335589548 0.7340050919