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.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.