Question

For the time series below, enter the 3-week moving average predictions (rounded to the nearest 0.01). Then calculate the error and MSE (careful to use unrounded figures for all calculations!).

Week	Time series	3-MA	Error
1	5
2	13
3	7
4	9
5	18
6	16

Answer 1

We have given siz week time series data.

For the time series below, enter the 3-week moving average predictions (rounded to the nearest 0.01). Then calculate the error and MSE.

3 week moving average is defined as,

average = average of three values.

Error = Observed - expected

MSE is the mean squared error.

We can do moving average method in MINITAB.

steps :

ENTER data into MINITAB sheet --> Stat --> Time series --> Moving average --> Variables : select data --> MA length : 3 --> Storage : residual --> ok --> ok

————— 18-11-2018 12:08:42 ————————————————————
  
Moving Average for time series

Data time series
Length 6
NMissing 0

Moving Average

Length 3

Accuracy Measures

MAPE 27.6235
MAD 4.5556
MSD 30.5556

week	time series	ma	residual
1	5
2	13	8.333333
3	7	9.666667
4	9	11.33333	0.6667
5	18	14.33333	8.3333
6	16		4.6667