Here is an Excel printout of a regression problem. Use this for the following 4 questions.

Here is an Excel printout of a regression problem. Use this for the following 4 questions.

Here is an Excel printout of a regression problem. Use this for the following 4 questions.

Regression Statistics
Multiple R 0.2288
R Square 0.0524
Adjusted R Square 0.0415
Standard Error 2.5166
Observations 89
ANOVA
df SS MS F p
Regress. 1 30.45 30.45 4.81 0.0310
Residual 87 550.99 6.33
Total 88 581.44
Coefficients Standard Error t Stat P-value
Intercept 33.12 27.6000 1.2000 0.2334
X -2.56 1.1675 -2.1927 0.0310


Find the "percentage of variance accounted for".


a. 22.88%
b. 5.24%
c. 4.15%
d. 2.5166%


Answer: b. 5.24%


What is the value of r?

a. -0.2288
b. 0.2288
c. 0.0524
d. -0.0524
e. 1.0000


Answer: a. -0.2288

What is the predicted value for X=10?

a. 25.60
b. 31.20
c. 7.52
d. 58.72


Answer: c. 7.52

Find a 95% C.L.I. for the answer to the previous problem, where x=10. (y(hat) denotes the answer to previous question.)


a. y(hat) +/- 2.5166
b. y(hat) +/- 1.960
c. y(hat) +/- 16.07
d. y(hat) +/- 4.933


Answer: d. y(hat) +/- 4.933


Learn More :