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
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 the next two years using this technique?
e. Fit a quadratic trend model to these data. What is the estimated regression function?
f. Compare the adjusted-R2 value for this model to that of the linear trend model. What is implied by this comparison?
g. Prepare a line graph comparing the quadratic trend predictions against the original data.
h. What are the forecasts for the next two years using this technique?
i. If you had to choose between the linear and quadratic trend models, which would you use? Why?
Step by Step Solution
3.13 Rating (163 Votes )
There are 3 Steps involved in it
Part c Estimated Year Sales Sales 1 283 32433 2 288 33656 3 336 34879 4 388 36101 5 406 37324 6 412 38547 7 416 39770 8 435 40993 9 428 42216 10 435 4... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
167-B-M-L-M-D-A (371).xlsx
300 KBs Excel File
