Use regression analysis to fit a linear trend model to the data set. a. What is the
Question:
Use regression analysis to fit a linear trend model to the data set.
a. What is the estimated regression function?
b. Interpret the R2 value for your model.
c. Prepare a line graph comparing the linear trend predictions against the original data.
d. What are the forecasts for each of the next 6 months using this technique?
e. Calculate seasonal indices for each month using the results of the linear trend model.
f. Use these seasonal indices to compute seasonal forecasts for each of the next 6 months.
Step by Step Answer:
Related Book For
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
ISBN: 9781305947412
8th Edition
Authors: Cliff T. Ragsdale
Question Posted: