Question

MindTap-Cengage Learning C Get Homework Help With Che X + https:JIng.cengage.com/stat html?deploymentid-58371464913324Search CENGAGE I MINDTAP Q Search this course Matthew v CH 8 Homework Problems (d) Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for Quarter 1 in Year 1, t = 2 for Quarter 2 in Year 1-t-12 for Quarter 4 in Year 3. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a sign before the blank. (Example: -300) 3.781tri + 2.188OQtr2+ .594 atr0.406 5.417 (e) Compute the quarterly forecasts for next year based on the model you developed in part (d) Do not round your interim computations and round your final answer to three decimal places. Year Quarter Period Ft 13 14 15 16 (f) Is the model you developed in part (b) or the model you developed in part (d) more effective? If required, round your intermediate calculations and final answer to three decimal places. Model developed in part (b) Model developed in part (d) MSE Model developed in part (d) v Justify your answer O Type here to search 1:04 AM 3/28/2019

Answer 1

e)

8.91666667

6.91666667

7.91666667

9.91666667

f)

(y - y_d)	(y-y_t)
1.6666	0.041666667
1.6666	0.041666667
1.6666	0.041666667
1.6666	0.041666667
0.3334	0.333333333
0.6666	0.666666667
0.3334	0.333333333
0.3334	0.333333333
1.3334	0.291666667
2.3334	0.708333333
1.3334	0.291666667
1.3334	0.291666667
1.222233333	0.284722222

MSE

Model developed in part (b)   1.222233333

Model developed in part (d)   0.284722222

Model in d) is more effective as MSE is less