Instruction 13 ANOVA Note: Adj R Square = Adjusted R Square; Std

Multiple Choice

Instruction 13.15
An economist is interested to see how consumption for an economy (in $ billions) is influenced by gross domestic product ($ billions) and aggregate price (consumer price index) . The Microsoft Excel output of this regression is partially reproduced below.
OUTPUT
SUMMARY
Regression Statistics
$\begin{array} { l l } \text { MultipleR } & 0.991 \\ \text { R Square } & 0.982 \\ \text { Adj. R Square } & 0.976 \\ \text { Std. Error } & 0.299 \\ \text { Observations } & 10 \end{array}$

ANOVA
$\begin{array} { l l l l l l } & d f & \text { SS } & \text { MS } & F & \text { Signiff } \\ \text { Regression } & 2 & 33.4163 & 16.7082 & 186.325 & 0.0001 \\ \text { Residual } & 7 & 0.6277 & 0.0897 & & \\ \text { Total } & 9 & 34.0440 & & & \\ & & & & & \\ & \text { Coeff } & \text { StdError } & t \text { Stat } & p \text { value } & \\ \text { Intercept } & - 1.6335 & 0.5674 & - 0.152 & 0.8837 & \\ \text { GDP } & 0.7654 & 0.0574 & 13.340 & 0.0001 & \\ \text { Price } & - 0.0006 & 0.0028 & - 0.219 & 0.8330 & \end{array}$ Note: Adj. R Square = Adjusted R Square; Std. Error = Standard Error
-Referring to Instruction 13.15,when the economist used a simple linear regression model with consumption as the dependent variable and GDP as the independent variable,he obtained an r² value of 0.971.What additional percentage of the total variation of consumption has been explained by including aggregate prices in the multiple regression?

A) 98.2
B) 1.1
C) 11.1
D) 2.8