In: Statistics and Probability
Requirements:
Moving Averages. Use the below actual sales to calculate a one-year average which will be used as the forecast for next periods (chapter 14, text). Choose a moving average period that best supports this calculation.
Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text).
Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 15, text).
Month Actual Sales
1 3050
2 2980
3 3670
4 2910
5 3340
6 4060
7 4750
8 5510
9 5280
10 5504
11 5810
12 6100