Solved

TABLE 14-5
a Microeconomist Wants to Determine How Corporate

Question 15

Multiple Choice

TABLE 14-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.
 Regression Statistics  Multiple R 0.830 R Square 0.689 Adjusted R Square 0.662 Standard Error 17501.643 Observations 26\begin{array}{l}\text { Regression Statistics }\\\begin{array} { l r } \hline \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}\end{array}

ANOVA
 d f  S S  M S  F  Significance F Regression215579777040778988852025.4320.0001Residual 237045072780306307512Total 2522624849820\begin{array}{lcrrrr}\hline & \text { d f }&\text { S S } & \text { M S } & \text { F }&\text { Significance F } \\\hline \text {Regression} & 2 & 15579777040 & 7789888520 & 25.432 & 0.0001 \\\text {Residual }& 23 & 7045072780 & 306307512 & & \\\text {Total }& 25 & 22624849820 & & & \\\hline\end{array}

 Coefficients  Standard Error t Stat  p-value  Intercept 15800.00006038.29992.6170.0154 C apital 0.12450.20450.6090.5485 W ages 7.07621.47294.8040.0001\begin{array} { l c c c c } & \text { Coefficients } & \text { Standard Error} & \text { t Stat } & \text { p-value } \\\text { Intercept } & 15800.0000 & 6038.2999 & 2.617 & 0.0154 \\\text { C apital } & 0.1245 & 0.2045 & 0.609 & 0.5485 \\\text { W ages } & 7.0762 & 1.4729 & 4.804 & 0.0001 \\\hline\end{array}

-Referring to Table 14-5, one company in the sample had sales of $21.439 billion (Sales = 21,439) . This company spent $300 million on capital and $700 million on wages. What is the residual (in millions of dollars) for this data point?


A) - 648.31
B) 648.31
C) 790.69
D) - 790.69

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions