To make 3-month and 2-month moving average for the time series.
The subsequent data represents demand for company ABC's products for the last 10 months.
|
Months
|
Demand
|
|
1
2
3
4
5
6
7
8
9
10
|
450
463
520
500
510
516
534
525
530
534
|
(a) Use the moving average function in MS Excel to develop a three-month moving average for this time series.
(b) Use the moving average function in MS Excel to develop a two-month moving average for this time series.