Consider the following EXCEL regression output. a. How many independent variable

Question

Consider the following EXCEL regression output. a. How many independent variables are involved? b. What is the estimated regression equation? c. At the 0.1 significance level, which of the independent variables are statistically significant? d. Is the overall model significant at the 0.1 significance level? Why? e. What percentage of the statistical variation is explained by the independent variables? f. Based on this regression result, what is the value of the dependent variable when age = 10, height = 60, and weight = 85? g. Based on the regression output, make a statement regarding the reliability of the estimation resulting from part f.

Explanation / Answer

a) three independent variables, x1, x2 and x3

b) Y = -136.54 + 9.53x1 + 3.34x2 - 0.597x3

c) only x2 is significantely different, since p value = 0.0952 < 0.1

d) Yes significant, since p value = 0.01429 < 0.1

e) r^2 = 47.38%

f) if x1 = 10, x2 = 60 ,x3 = 85

then Y = 108.55

g) Yes given prediction may not be significant , since there is ooderate correlation between them

Here correlation is r = 0.688

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.