The regression function was used in Excel to fit a linear trend line to a given
ID: 3174084 • Letter: T
Question
The regression function was used in Excel to fit a linear trend line to a given time series. The following output was generated: Regression Statistics Multiple R 0.692820323 R Square 0.48 Adjusted R Square 0.35 Standard Error 1.74164673 Observations 6 ANOVA df SS MS F Regression 1 11.2 11.2 3.692308 Residual 4 12.13333333 3.033333 Total 5 23.33333333 Coefficients Standard Error t Stat P-value Intercept 8.866666667 1.621384868 5.468576 0.005439 X Variable 1 0.8 0.4163332 1.921538 0.127046 What is the linear trend equation:
Explanation / Answer
Intercept is 8.8667
The coefficient of the x- variable is 0.8
The linear trend equation is y = 8.8667 + 0.8x