SUMMARY OUTPUT

(Using Excel's regression from add-in analysis package)
Regression Statistics
Multiple R 0.935605577
R Square 0.875357796
Variance accounted for using r
Adjusted R Square 0.865769934
Variance accounted for using sum of squares
Standard Error 6.101140451
Observations 15
ANOVA
  df SS MS F Significance F
Regression 1 3398.49 3398.49 91.30 0.00000
Residual 13 483.91 37.22  
Total 14 3882.40      
  Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept (a hat- estimated x- intercept)
31.5024 7.32 4.30 0.00 15.69 47.31
Permits(Beta hat-estimated slope) 0.5464 0.06 9.56 0.00 0.42 0.67
   
RESIDUAL OUTPUT
Y-hat
Observation Predicted Sales (000) Residuals
1 78.49 -1.49
2 82.32 -3.32
3 83.41 -3.41
4 88.33 -5.33
5 107.45 -6.45
6 129.85 -12.85
7 121.66 7.34
8 111.82 8.18
9 96.52 0.48
10 103.62 2.38
11 100.35 -1.35
12 116.74 4.26
13 101.99 1.01
14 83.95 2.05
15 90.51 8.49