Examlex

Solved

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

question 70

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
 MultipleR 0.991 R Square 0.982 Adj. R Square 0.976 Std. Error 0.299 Observations 10\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
df SS  MS F Signiff  Regression 233.416316.7082186.3250.0001 Residual 70.62770.0897 Total 934.0440 Coeff  StdError t Stat p value  Intercept 1.63350.56740.1520.8837 GDP 0.76540.057413.3400.0001 Price 0.00060.00280.2190.8330\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 r2 value of 0.971.What additional percentage of the total variation of consumption has been explained by including aggregate prices in the multiple regression?


Definitions:

Manhattan Island

An island at the mouth of the Hudson River in New York City; historically significant as the founding location of New York.

Permanent Settlement

A term often associated with the agreement made by the British with landlords in colonial India, fixing revenues to be raised from land, making the landlords intermediaries between the farmers and the colonial government.

Bahamas

An archipelago situated in the Atlantic Ocean, known for its picturesque beaches, clear waters, and vibrant culture; a sovereign country.

Related Questions