HOW forecasting Temp Sales and beer sales? (data available in spreadsheet on iLearn) 80 68 78 79 87 74 86 20533 1439 13829 21286 30985 17187 30240 92 37596 77 9610 84 28742 16. In the spreadsheet on iLearn is a data set containing monthly S&P closing prices for the last 5 years. a. Calculate the 3-period moving average forecast, ending with September, 2019. b. Find the weighted moving average forecast using weights 0.4, 0.5, and 0.6. C. Find the exponential smoothing forecast using a = 0.3. d. Do a trend analysis forecast. e. Graph all the forecasts, along with the original data series, in the same graph. Which do you think is the most accurate? f. Using MAD and MSE, determine the most accurate forecasting method. MacBook Air D F G H 1 - K 1 M N o P o E7 x x A B 1 Date Close 2. 10/1/14 2018.05 3 11/1/14 2067.56 12/1/14 2058.9 5 1/1/15 1994.99 5 2/1/15 21045 7 3/1/15 2067.89 8 4/1/15 2085.51 9 S/1/15 2107.39 10 6/1/15 2063.11 11 7/1/15 2103.84 12 8/1/15 1972.18 13 9/1/15 1920.03 14 10/1/15 2079.36 15 11/1/15 2010 61 16 12/1/15 20494 17 1/1/16 1940.24 IR 2/1/16 1932.23 1/1/16 2059.74 20 4/17 20653 21 5/1/16 209695 22 6/1/16 2015.06 23 7/1/16 2171.6 24 3/1/16 2170.95 25 9/1/16 216827 20 10/1/10 2126.15 11/1/16 2198.81 28 12/1/16 2233 29 1/1/7227327 27/17 2363.64 3/1/17 2362.72 12 4/1/17 23841 5/1/17 24118 6/1/17 2423.41 15 7/1/17 24703 10 1/1/12 2471.65 9/1/17 2515.36 10/1/17 2575.26 11/1/17 2584.84 40 12/1/17 2673.61 41 1/1/18 2823 31 42 2/1/12 271333 Cupcake sales TU Hotel acupancy rates 5&P 500 Apartment experten Screen time weight Beer sales HOW forecasting Temp Sales and beer sales? (data available in spreadsheet on iLearn) 80 68 78 79 87 74 86 20533 1439 13829 21286 30985 17187 30240 92 37596 77 9610 84 28742 16. In the spreadsheet on iLearn is a data set containing monthly S&P closing prices for the last 5 years. a. Calculate the 3-period moving average forecast, ending with September, 2019. b. Find the weighted moving average forecast using weights 0.4, 0.5, and 0.6. C. Find the exponential smoothing forecast using a = 0.3. d. Do a trend analysis forecast. e. Graph all the forecasts, along with the original data series, in the same graph. Which do you think is the most accurate? f. Using MAD and MSE, determine the most accurate forecasting method. MacBook Air D F G H 1 - K 1 M N o P o E7 x x A B 1 Date Close 2. 10/1/14 2018.05 3 11/1/14 2067.56 12/1/14 2058.9 5 1/1/15 1994.99 5 2/1/15 21045 7 3/1/15 2067.89 8 4/1/15 2085.51 9 S/1/15 2107.39 10 6/1/15 2063.11 11 7/1/15 2103.84 12 8/1/15 1972.18 13 9/1/15 1920.03 14 10/1/15 2079.36 15 11/1/15 2010 61 16 12/1/15 20494 17 1/1/16 1940.24 IR 2/1/16 1932.23 1/1/16 2059.74 20 4/17 20653 21 5/1/16 209695 22 6/1/16 2015.06 23 7/1/16 2171.6 24 3/1/16 2170.95 25 9/1/16 216827 20 10/1/10 2126.15 11/1/16 2198.81 28 12/1/16 2233 29 1/1/7227327 27/17 2363.64 3/1/17 2362.72 12 4/1/17 23841 5/1/17 24118 6/1/17 2423.41 15 7/1/17 24703 10 1/1/12 2471.65 9/1/17 2515.36 10/1/17 2575.26 11/1/17 2584.84 40 12/1/17 2673.61 41 1/1/18 2823 31 42 2/1/12 271333 Cupcake sales TU Hotel acupancy rates 5&P 500 Apartment experten Screen time weight Beer sales