Use Excel to find the estimated simple regression equation that relates the depe

Question

Use Excel to find the estimated simple regression equation that relates the dependent variable y (MPG) to the independent variable x (Weight) for an amp 12 cars. Include residual analysis and the probability plot. a. Write the model for this regression. b. Write the estimated simple linear regression equation here (rounding to thousandths): c. Based on the residual plot, which of the underlying regression assumptions (linearity, independence, normal distribution of errors, and equal variance among error terms) is violated in this regression? Circle one response. LINEARITY INDEPENDENCE NORMALITY EQUAL VARIANCES NO VIOLATIONS d. Based on the residual plot, is this model appropriate? Circle the appropriate response. YES NO e. Based on the normal probability plot, are the error terms normally distribution Circle the appropriate response. YES NO

Explanation / Answer

a) the model for this regression is y = ax + b +error

b) MPG = 56.09 - 0.01164 * Weight

c) Though i don't see significant violations, not many points are very close to the line. I would go with

Linearity

d) NO. Some of the residual values are high

e)

The normal probability plot of errors is normal. It is not skewed as the diagonal passes through the points

answer YES

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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