Question 2 (of 2) value 5.00 points the following table, consisting of 20 observ

Question

Question 2 (of 2) value 5.00 points the following table, consisting of 20 observations of the variable y and time t. 1 10.39 6 11.84 11 1747 16 14.97 2 13.887 14.62 12 15.84 17 19.16 3 13.80 8 13.24 13 14.67 18 17.31 4 13.17 9 15.12 14 16.66 19 17.93 5 13.64 10 12.63 15 18.48 20 16.69 Click here for the Excel Data File b-1. Estimate a linear trend model and a quadratic trend model. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.) VariableLinear Trend Quadratic Trend Intercept NA Adjusted R2 b-2. Which trend model describes the data well? O Quadratic trend model based on the R2 measure. Quadratic trend model based on the adjusted R2 measure. Linear trend model based on the R2 measure 0 Linear trend model based on the adjusted R2 measure. Hints ReferenceseBook & Resources

Explanation / Answer

1. a) Linear Trend Model Analysis: y versus t

The Linear Trend Model equation is
y = 11.74 + 0.3172 t

Here intercept = 11.74, t = 0.3172 and

R2 = 64.5% Adjusted R2= 62.5%.

  a) Quadratic Trend Model Analysis: y versus t

Quadratic Trend

The Quadratic Trend model equation is
y = 11.51 + 0.3804 t - 0.00301 t2

Here intercept = 11.51 , t = 0.3804, t2 = 0.00301 and

R2 = 64.6% and Adjusted R2= 60.5%.

2) Both R2 and adjusted R2 measure how well model fits the data but there is only difference between the R2 assumes that every single variable explains the variation in the dependent variable. The adjusted R2 tells you the percentage of variation explained by only the independent variables that actually affect the dependent variable.

So adjusted R2 is better then R2. Therefore Linear Model Based on adjusted R2 describe the data well.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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