Exercise 3-34 Name:
Fill in the correct data in the gray-shaded cells and run a
regression in Excel. Excel may have different answers
than the solution manual due to the precision of Excel.
a.
50 175$
44 162$
40 154$
35 142$
53 185$
58 200$
60 202$
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.99724953
R Square 0.994506626
Adjusted R Square
0.993407951
Standard Error 1.860160722
Observations 7
ANOVA
df SS MS
Regression 1 3132.12758 3132.12758
Residual 5 17.3009896 3.46019791
Total 6 3149.42857
Coefficients
Standard Error
t Stat
Intercept 55.04672897 4.02510713 13.675842
X Variable 1 2.454920286 0.08159586 30.0863326
Y = a + bX
X=165 459.54$
Number of
Shipments
Received
Cost of
Receiving
Reports
Solution
F
905.187409 7.6091E-07
P-value Lower 95% Upper 95%
3.7495E-05 44.6998617 65.3935962 44.6998617
7.6091E-07 2.24517144 2.66466913 2.24517144