9781118041581

Appendix to Chapter 4 Regression Using Spreadsheets 185

TABLE 4A.2

Simple Regression

Results

EF GHIJ K LM

1

2 SUMMARY OUTPUT

3

4

5 Regression Statistics

6 Multiple R 0.765

7 R Square 0.586

8 Adjust R Square 0.556

9 Standard Error 18.607

10 Observations 16

11

12 ANOVA

13 df S S M S F Signif F

14 Regression 1 6,858.8 6,858.8 19.81 0.00055

15 Residual 14 4,847.2 346.2

16 Total 15 11,706.0

17

18 Coefficients Stand Error t Stat P-value Lower 95% Upper 95%

19 Intercept 478.55 88.039 5.436 0.00009

20 Price 1.633 0.367 4.451 0.00055 2.419 0.846

21

c04EstimatingandForecastingDemand.qxd 9/5/11 5:49 PM Page 185