(12
(Choose
1
answer)
(Seepicture)
A 16,520.07
A microeconomist wants to determine how corporate sales are influenced by capital and wage spending by companies. She proceeds to randomly select 26 large corporations and record information in millions of dollars. The Microsoft Excel output below shows results of this multiple regression.
SUMMARY OUTPUT
B.20,455.98
Regression Statistics
Multiple R
0.83
R Square
0.689
Adjusted R Square
0.662
Standard Error
17501.64
Observations
26
C.17.277.49
D.15,800.00
ANOVA
df
Regression.
Residual
Total
SS
MS
F
Signif F
0.0001
2 1.56E+10
7.79E+09 25.432
23 7.05E+09 3.06E+08
25 2.26E+10
Coeff StdError Stat
Intercept
Capital
Wages
15800 6038.3
0.1245 0.2045
7.0762 1.4729
P-value
2.617
0.0154
0.609 0.5485
4.804 0.0001
What are the predicted sales (in millions of dollars) for a company spending $100 million on capital and $100 million on wages?
