9781118041581

TABLE 4A.3

Multiple-Regression

Results

EF GHIJ K LM

1

2 SUMMARY OUTPUT

3

4

5 Regression Statistics

6 Multiple R 0.881

7 R Square 0.776

8 Adjust R Square 0.721

9 Standard Error 14.766

10 Observations 16

11

12 ANOVA

13 df S S M S F Signif F

14 Regression 3 9,089.6 3,029.9 13.90 0.0003

15 Residual 12 2,616.4 218.0

16 Total 15 11,706.0

17

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

19 Intercept 28.84 174.67 0.165 0.872

20 Price 2.124 0.340 6.238 0.00004 2.865 1.382

21 Competitor’s P 1.035 0.467 2.218 0.04664 0.018 2.051

22 Income 3.089 0.999 3.093 0.00931 0.913 5.266

23

186 Appendix to Chapter 4 Regression Using Spreadsheets

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