Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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

ID: 3226634 • Letter: C

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 his 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

With p-value < 0.1, I reject ho and conclude that only x2 is significant.

With p-values > 0.1, I fail to reject ho and conclude that x1 and x3 is not significant

4. Ho; model is not significant, v/s h1: model is significant

With F = 4.802 and p-value <.01, I reject ho and conclude that model is significant.

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote