Question

1. Use a four-period moving average to calculate MFE, MAE, MSE, and MAPE. Historical records show: 5346, 7812, 6513, 5783, 5982, 6519, 6283, 5577, 6712, 7345. Please show work.

Answer 1

here as 4 period average =(last 4 month total)/4

value(A)	forecast(F)	A-F	|A-F|	(A-F)^2	|A-F|/A
5346
7812
6513
5783
5982	6363.5	-381.50	381.50	145542.25	0.06
6519	6522.5	-3.50	3.50	12.25	0.00
6283	6199.25	83.75	83.75	7014.06	0.01
5577	6141.75	-564.75	564.75	318942.56	0.10
6712	6090.25	621.75	621.75	386573.06	0.09
7345	6272.75	1072.25	1072.25	1149720.06	0.15
	total	828.00	2727.50	2007804.25	0.42
	average	138.00	454.58	334634.04	6.96%
		MFE	MAE	MSE	MAPE

from above MFE=138.00

MAE=454.58

MSE =334634.04

MAPE =6.96%