| Electronic Data Processing, Inc. |
(basic example
from Hirschey, ch 5) |
|
|
|
|
| data from text in A3:C16 |
|
|
personal |
|
|
units |
selling exp |
|
to enable regression: |
|
| Jan. |
2500 |
43000 |
|
tools, add ins, analysis tool
pack, |
|
| Feb. |
2250 |
39000 |
|
| Mar |
1750 |
35000 |
|
to use regression: |
|
| Apr |
1500 |
34000 |
|
tools, data analysis, regression |
|
| May |
1000 |
26000 |
|
|
| Jun |
2500 |
41000 |
|
| Jul |
2750 |
40000 |
|
| Aug |
1750 |
33000 |
|
| Sep |
1250 |
26000 |
|
| Oct |
3000 |
45000 |
|
| Nov |
2000 |
32000 |
|
| Dec |
2000 |
34000 |
|
|
| SUMMARY
OUTPUT (results of regression) |
|
|
| Regression Statistics |
|
| Multiple R |
0.9368257 |
|
| R Square |
0.8776423 |
|
| Adjusted R Square |
0.8654065 |
|
| Standard Error |
222.80952 |
|
| Observations |
12 |
|
|
| ANOVA |
|
| |
df |
SS |
MS |
F |
Significance F |
|
| Regression |
1 |
3560850.835 |
3560851 |
71.7276 |
7.12E-06 |
|
| Residual |
10 |
496440.832 |
49644.1 |
|
| Total |
11 |
4057291.667 |
|
|
|
|
|
| |
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
|
| Intercept |
-1292.3061 |
396.4503079 |
-3.2597 |
0.008579 |
-2175.65 |
-408.96 |
-2175.6525 |
-408.959809 |
|
| X Variable 1 |
0.0928918 |
0.010968167 |
8.46921 |
7.12E-06 |
0.068453 |
0.11733 |
0.0684532 |
0.11733036 |
|
|
| RESIDUAL
OUTPUT |
|
|
| Observation |
Predicted Y |
Residuals |
|
| 1 |
2702.0396 |
-202.03958 |
|
| 2 |
2330.4725 |
-80.47253635 |
|
| 3 |
1958.9055 |
-208.9054927 |
|
| 4 |
1866.0137 |
-366.0137318 |
|
| 5 |
1122.8796 |
-122.8796446 |
|
| 6 |
2516.2561 |
-16.25605816 |
|
| 7 |
2423.3643 |
326.6357027 |
|
| 8 |
1773.122 |
-23.12197092 |
|
| 9 |
1122.8796 |
127.1203554 |
|
| 10 |
2887.8231 |
112.1768982 |
|
| 11 |
1680.2302 |
319.76979 |
|
| 12 |
1866.0137 |
133.9862682 |
|
|
|
|
|
|
|
|
|
|
|
|