Question: Use regression analysis to fit a quadratic trend model to the data set. a. What is the estimated regression function? b. Compare the adjusted-R2 value
Use regression analysis to fit a quadratic trend model to the data set.
a. What is the estimated regression function?
b. Compare the adjusted-R2 value for this model to that of the linear trend model. What is implied by this comparison?
c. Prepare a line graph comparing the quadratic trend predictions against the original data.
d. What are the forecasts for each of the first six months in 2006 using this technique?
e. Calculate multiplicative seasonal indices for each month using the results of the quadratic trend model.
f. Use these seasonal indices to compute seasonal forecasts for each of the first six months in 2006.
g. Calculate additive seasonal indices for each month using the results of the quadratic trend model.
h. Use these seasonal indices to compute seasonal forecasts for each of the first six months in 2006.
Step by Step Solution
3.52 Rating (162 Votes )
There are 3 Steps involved in it
a b The adjustedR2 for this model is 459 This is lower than the adjustedR2 for the linear trend model suggesting that the quadratic term is unnecessary d Forecast for Month 1 18132 Forecast for Month ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
167-B-M-L-M-D-A (390).xlsx
300 KBs Excel File
