Examlex

Solved

SCENARIO 13-5
a Microeconomist Wants to Determine How Corporate Sales

question 17

Multiple Choice

SCENARIO 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 OUTPUT
Regression Statistics
 Multiple R 0.830 R Square 0.689 Adjusted R Square 0.662 Standard Error 17501.643 Observations 26\begin{array} { l l } \text { Multiple R } & 0.830 \\ \text { R Square } & 0.689 \\ \text { Adjusted R Square } & 0.662 \\ \text { Standard Error } & 17501.643 \\ \text { Observations } & 26 \end{array}
ANOVA
df SS  MS F Signif F Regression 215579777040778988852025.4320.0001 Residual 237045072780306307512 Total 2522624849820\begin{array} { l r c c c c } & d f & \text { SS } & \text { MS } & F & \text { Signif } F \\ \text { Regression } & 2 & 15579777040 & 7789888520 & 25.432 & 0.0001 \\ \text { Residual } & 23 & 7045072780 & 306307512 & & \\ \text { Total } & 25 & 22624849820 & & & \end{array}


 Coeff  StdError t Stat  P-value  Intercept 15800.00006038.29992.6170.0154 Capital 0.12450.20450.6090.5485 Wages 7.07621.47294.8040.0001\begin{array}{lrrrr} & \text { Coeff } & \text { StdError } & t \text { Stat } & \text { P-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}

-Referring to SCENARIO 13-5, suppose the microeconomist wants to test whether the coefficient on Capital is significantly different from 0.What is the value of the relevant t-statistic?


Definitions:

Related Questions