Question

Need help with #2. The data set mentioned is the numbers that are provided.

7.pdf Get Homework Help With Chege + × Homework%20%237.pdf Does the three-month or four-month moving average provide more accurate d) forecasts based on MSE? What is the forecast for the next month using the better forecasting method e) you decided in part d)? Problem 13 on Page 822. The values of Alabama building contracts (in Smillions) for a 12-month period follow. 240 350 230 260 280 320 220 310 240 310 240 230 Please deawnload the dataset "Alabama building contracts.xlsx from Canvas. a) Use Minitab to construct a time series plot. What type of pattern exists in the 2. data? b) Develop exponential smoothing forecast using α 0.2 by hand and c) Use Minitab to develop three-month moving averages for this time series d) What is the forecast for the next month by exponential smoothing forecast calculate the corresponding MSE and find the corresponding MSE using a 0.2? 3. Consider the following time series data t 1 2 3 4 5 Yt 6 11 9 14 15 Use Minitab to construct a time series plot. What type of pattern exists in the data? a) b) Use Minitab to develop the linear trend equation for this time series c) What is the forecast for t 6? 回閒"

Answer 1

Solulion' ContYac 360 320 Зоо 日20 34s6千8910 11 12 Inde

B) o.RxF-+- 9 325, oo 249.60 Q 51.9良 260 980 320 91.5 8302.3 5151.9 3016.3 311-1 239.33 295. 64 31ο 9 o 310 51.1534 6s.8 31 o 2Ho 29.83 3390.9 469 S bre cas 34.83

c) Movin Aseta Misto Moving Asorage 3 Accurag Measure MAD 3A 63 MS, 1993:44 edoo 350 230 60 及80 320 24ろ·333 280 -000212 33313 3333 8.6t 25G 63.5533 316 293.333 | 13.353 3GC66\ #56, c64 916 661956.661 53.3333 233,2-43.3333 316 Met 1479.