regression_chart.xlsx

Sheet2

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8947244911
R Square 0.8005319149
Adjusted R Square 0.6509308511
Standard Error 4.3301270189
Observations 8
ANOVA
df SS MS F Significance F
Regression 3 301 100.3333333333 5.3511111111 0.0694393173
Residual 4 75 18.75
Total 7 376
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 13 3.0618621785 4.2457822208 0.0132024377 4.4989077418 21.5010922582 4.4989077418 21.5010922582
size 2 3.0618621785 0.6531972647 0.5492716224 -6.5010922582 10.5010922582 -6.5010922582 10.5010922582
location -7.5 3.0618621785 -2.4494897428 0.0704839969 -16.0010922582 1.0010922582 -16.0010922582 1.0010922582
type 9.5 3.0618621785 3.1026870075 0.0361268851 0.9989077418 18.0010922582 0.9989077418 18.0010922582
PROBABILITY OUTPUT
Percentile errors
6.25 2
18.75 6
31.25 15
43.75 16
56.25 18
68.75 19
81.25 21
93.75 23

Normal Probability Plot

6.25 18.75 31.25 43.75 56.25 68.75 81.25 93.75 2 6 15 16 18 19 21 23

Sample Percentile

errors

Sheet1

size location type errors
0 0 0 15
1 0 0 18
0 1 0 6
1 1 0 2
0 0 1 19
1 0 1 23
0 1 1 16
1 1 1 21