Excel assignment, due 11/20
Data
| Period | Month | Sales |
| 1 | January | 31 |
| 2 | February | 57 |
| 3 | March | 22 |
| 4 | April | 30 |
| 5 | May | 67 |
| 6 | June | 42 |
| 7 | July | 55 |
| 8 | August | 55 |
| 9 | September | 30 |
| 10 | October | 47 |
| 11 | November | 38 |
| 12 | December | 42 |
| 13 | January | 55 |
| 14 | February | 55 |
| 15 | March |
Moving Average
| Question: What is the forecast for March? |
| Calculate it using 3-months and 4 months average |
Exponantial Smoothing
| Question: What is the forecast for March? |
| Calculate it using alpha=0.3 and 0.5 |
Comparison
| Fill out the following table and display the data series on a line graph | Models | MAD | MSE | |||
| Moving Avg 3 Months | ||||||
| Moving Avg 4 Months | ||||||
| Exp Smooth. Alpha 0.3 | ||||||
| Exp Smooth. Alpha 0.5 | ||||||
| Month | Original Data | Moving Avg 3 Months | Moving Avg 4 Months | Exp Smooth. Alpha 0.3 | Exp Smooth. Alpha 0.5 | |
| January | ||||||
| February | ||||||
| March | ||||||
| April | ||||||
| May | ||||||
| June | ||||||
| July | ||||||
| August | ||||||
| September | ||||||
| October | ||||||
| November | ||||||
| December | ||||||
| January | ||||||
| February |