Answer a-g using the output D The pvalue for X2 is mising Compute the value usin

Question

Answer a-g using the output D The pvalue for X2 is mising Compute the value using apprpratembrs from the Excel output Could you simplify the model and have fewer independent variables? If so, how? Use a 5% level of significance. Justify using appropriate regression output g) SUMMARY OUTPUI Multiple R R Square Adjusted R Sqsare 0.74 0.54 0.43 14.16 Standard Error Observations ANOVA 4.70 0.02 Residual Total 2830 59 240762 5238.20 943 53 20063 12 97.74 0.03 0.21 6 33 4568 425.87 -0.05 0.48 0.31 1.59 65.92 0.14 0.85 0.41 0.03 112.86 002 XI x2 x3 0.0 -0.15 0.02 0.17 5.97 -0.06 0.52 -0.05 1.02 0.15 30

Explanation / Answer

as per chegg policies i am answering 4 parts.

a) y = -179.97 – 0.01*x1 + 0.15*x2 + 3.14*x3

b) predicted Yhat = -179.97-0.01*2500+0.15*200+3.14*85 = 91.93

c) ho: model is not significant. h1: model is significant

With F = 4.7 and p-value < 0.05 (alpha), I reject ho and conclude that model is significant. That is at least one of the SLOPE is different from 0

With F = 4.7 and p-value > 0.01 (alpha), I fail to reject ho and conclude that model is NOT significant. That is all slopes are equal to zero.

d) with a unit increase in x1 there is 0.01 units decrease in y

e) 95% CI for X2 = beta2 +- t(a/2,n-k-1)*SE_beta = -0.15+-2.179*.15 = (-0.4768, .17685). since this interval contains zero, I can say that slope of X2 is not different from zero.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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