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

question 241

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,what is the p-value for testing whether Wages have a negative impact on corporate sales?

• A)0.0001
• B)0.00005
• C)0.05
• D)0.99995

Analyze activities that affect cash flows from operating activities.

Calculate net cash provided or used by investing and financing activities.

Identify and explain the importance of significant noncash investing and financing activities.

Comprehend the use of spreadsheets in preparing the Statement of Cash Flows.