Open the Trend+Season Forecasting template shown in Figure, used for monthly data and do a sensitivity analysis on this template. Change some of the values in the table and see how the forecasts change. Are there large relative changes?

Transcribed Image Text:

Forecasting with Trend and Seasonality Intercept Trend Equation1292.39 Data Year Month Y Deseason t Year Month 2005 4 YMonth Index Seasonal Index 134 2007 Jan 1396.79 2 2005 5 May 1282 1300.9135 2007 2 Feb 1409.06 36 2007 3 Mar 1404 2 1306 1315.37 99.62 Feb 100.26 3 2005 6 Jun 1297 1308.19 Mar 4 2005 Jul 1315 5 2005 8 Aug 131 99.29 10 1307.3638 2007 5 May 1394.52 1062005g Sep 1323 13188 39 2007 6 Jun 1406.18 99.14 99.69 100.20 40 20077 Jul 141 8 2005 11 Nov 1322 9 2005 12 Dec 1317 1315.78 41 2007 8 Aug 142 42 2007 9 43 2007 10 Oct 1464.07 1432.55 410 2006 1 Jan 15 11 2006 2 Feb 1327 1323.55 102.29 Nov 100.86 Dec 100.09 44 2007 11 Nov 1446.77 45 2007 12 Dec 1439.02 1 9 14 2006 5 May 1320 1339.47 Jan Feb Mar Apr May Jun Ju Aug Sep Oct Nov Dec 21 17 2006 8 AUg 1353 1350.27 2218 2006 Sep 1358 1353.68 23 19 2006 10 Oct 1399 1367.62 24 20 2006 11 Nov 1379 1367.27 25 21 2006 12 Dec 1369 1367 73 26 22 2007 Jan 1353 1358.21 Data 28 24 20073 Mar 13631367.29 1365 1374.79 30 26 2007 5 May 1354 1373.97 31 27 2007 6 Jun 1358 1369.72 228 3 29 20078Aug 1376 1373.22 04 2632 2007 11 Nov 1406 1394.04 37 33 2007 12Dec 1401 1399.7 10 25 30 40