Question

In Excel, create a forecast for periods 6-13 using the following method:

5 period simple moving average.

Using a 5 period simple moving average, the forecast for period 13 will be:

Period	Data
1	45
2	52
3	48
4	59
5	55
6	55
7	64
8	58
9	73
10	66
11	69
12	74

Answer 1

Using a 5 period simple moving average, the forecast for period 13 will be =sum of last 5 periods/5=(58+73+66+69+74)/5=68