SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
df SS MS F
Significance F
Regression
1 6.92E+08 6.92E+08 108.8096 1.62E-05
Residual 7 44489230 6355604
Total 8 7.36E+08
Coefficients
Standard Error
t Stat P-value
Lower 95%
Upper 95%
Lower 95.0%
Intercept 6329.838 1538.013 4.115595 0.004484 2693.018 9966.658 2693.018
X Variable 1
271.1468 25.99386 10.43118 1.62E-05 209.6811 332.6124 209.6811
Upper 95.0%
9966.658
332.6124
Problem 3-44 Name:
Fill in the correct data in columns C and F and run a regression in Excel.
Excel may have different answers than the solution manual due to the
precision of Excel. The word “wrong” will appear if your input is
incorrect, except for the cost formulas because formats may vary.
a.
10 8,000$
14 9,200$
22 12,000$
28 14,200$
40 18,500$
62 28,000$
100 34,000$
90 30,000$
80 24,000$
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
df MS F
Regression 1 691550769.7 108.8096008
Residual 7 6355604.328
Total 8
Coefficients t Stat P-value Lower 95%
Intercept 6329.8384 4.1155952 0.004484289 2693.018452
271.146759 10.431184 1.61862E-05 209.6810862
Number of Charters
Standard Error
Number of Charters
Labor Costs
$6329.84 + ($271.15 x # Charters)
0.969306949
0.939555961
0.930921099
2521.032393
9
SS
691550769.7
44489230.3
736040000
Solution
1538.01288
25.99386198
b.
12,000$ 8,000$
18,000$ 9,200$
26,000$ 12,000$
36,000$ 14,200$
60,000$ 18,500$
82,000$ 28,000$
120,000$ 34,000$
100,000$ 30,000$
96,000$ 24,000$
SUMMARY OUTPUT
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
df MS F
Regression 1 706311245.7 166.3096501
Residual 7 4246964.895
Total 8
Coefficients t Stat P-value Lower 95%
Intercept 5393.8566 4.1199552 0.004459816 2298.086308
0.23519144 12.89611 3.91593E-06 0.192066884
Gross Receipts
Y = a + bX
$5393.86 + ($0.235 x Gross Receipts)
Gross Receipts
Labor Costs
Standard Error
1309.20272
0.018237394
SS
706311245.7
29728754.26
736040000
0.953839847
2060.81656
9
Regression Statistics
0.979596787
0.959609866
Significance F
1.61862E-05
Upper 95%
Lower 95.0%
Upper 95.0%
9966.658358 2693.01845 9966.65836
332.6124311 209.681086 332.612431
Significance F
3.91593E-06
Upper 95%
Lower 95.0%
Upper 95.0%
8489.626884 2298.08631 8489.62688
0.278315991 0.19206688 0.27831599