Exercise 1

Use the 6-week moving average method to calculate forecasts for all available periods given the data provided in the Excel template.

Exercise 2

Use the exponential smoothing method with alpha = 0.3 to calculate forecasts for all available periods given the data provided in the Excel template.

Exercise 3

Make a fair comparison between the above two models by bias and MSE. According to your analysis, which forecasting model is more accurate?

Please see the picture below. This needs to be done in excel. Please include your formulas used in excel! Thanks :)

Dhat Photo X AltoSave Off Of A My ex Valerie Soderstroms ca 14 File Home Insert Draw Page Layout Formulas Data Review View Help e Daughte A O 0. % Alignment Number DI Conditional Formatting 2 Format as Table 2 Cell Styles Font Cells Editing Analyze Data Sensitivity ght V Styles Analysis Sensitivity fr ta Clipboard ty nal he D23 sub A the 1 2 1 3 Week 4 B E F D Moving Average N=6 G H Exponential Smoothing a 0.3 -we 5 plat 6 7 2 8 9 10 11 in ti 12 13 23 14 15 fair" 16 Demand 1 1 650 2 678 3 720 4 785 5 859 6 920 7 850 8 758 9 892 10 920 11 789 12 844 132 ng | 17 18 19 20 21 22 Bias MSE Exe1-3 + 10096 2. 3 7 4. 5 6 7 O