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 quarter in 2017 using this technique?
e. Calculate seasonal indices for each quarter using the results of the linear trend model.
f. Use these seasonal indices to compute seasonal forecasts for each quarter in 2017.
Step by Step Answer:
Related Book For
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
ISBN: 1233
8th Edition
Authors: Cliff T. Ragsdale
Question Posted: