Instruction 13-5
a Microeconomist Wants to Determine How Corporate Sales $\mathrm { R }$

Multiple Choice

Instruction 13-5
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
Regression Statistics
\begin{tabular} { l r } Multiple $\mathrm { R }$ & $0.830$ \\ \hline Square & $0.689$ \end{tabular}
R Square $\quad 0.689$
Adj. R Square $\quad 0.662$
Std. Error $\quad 17501.643$
Observations 26
ANOVA
$\begin{array} { l l l l l l } & \boldsymbol { d f } & \text { SS } & \text { MS } & \boldsymbol { F } & \text { Siguif } \boldsymbol { F } \\ \text { Regression } & 2 & 15579777040 & 7789888520 & 25.432 & 0.0001 \\ \text { Residual } & 23 & 7045072780 & 306307512 & & \\ \text { Total } & 25 & 22624849820 & & & \end{array}$
$\begin{array} { l l l l l } & \text { Coeff } & \text { StdError } & \boldsymbol { t } \text { Stat } & \boldsymbol { P } \text {-value } \\ \text { Intercept } & 15800.0000 & 6038.2999 & 2.617 & 0.0154 \\ \text { Capital } & 0.1245 & 0.2045 & 0.609 & 0.5485 \\ \text { Wages } & 7.0762 & 1.4729 & 4.804 & 0.0001 \end{array}$ Note: Adj.R Square = Adjusted R Square;Std.Error = Standard Error
-Referring to Instruction 13-5,when the microeconomist used a simple linear regression model with sales as the dependent variable and wages as the independent variable,he obtained an r² value of 0.601.What additional percentage of the total variation of sales has been explained by including capital spending in the multiple regression?

A) 60.1%
B) 22.9%
C) 8.8%
D) 31.1%