Consider the Following Data and Excel Output for a Simple

Consider the following data and Excel output for a simple linear regression model.How much of the total variation in the dependent variable (Y) is explained by the independent variable (X) ?
$$\begin{array} { | c | c | c | } \hline \text { Period } & \text { Y } & \text { X } \\\hline \text { Period 1 } & 10 & 1 \\\hline \text { Period 2 } & 11 & 2 \\\hline \text { Period 3 } & 9 & 3 \\\hline \text { Period 4 } & 12 & 4 \\\hline \text { Period 5 } & 13 & 5 \\\hline \text { Period 6 } & 12 & 6 \\\hline \text { Period 7 } & 15 & 7 \\\hline\end{array}$$
$$\begin{array} { | l | l | } \hline \text { Intercept } & 2.267 \\\hline \text { Slope } & 0.843 \\\hline \text { SE } & 1.810 \\\hline \text { Correlation } & 0.890 \\\hline \text { r-squared } & 0.791 \\\hline\end{array}$$

A) 2.267
B) 0.843
C) 1.810
D) 0.890
E) 0.791

Correct Answer:

Verified

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

Access For Free