Quarter Year 1 Year 2 Year 3 Year 4 1 49 60 75 90 2 120 140 180 260 3 310 380 430 510 4 620 710 900 1020 1 (25 KiB) Viewed 40 times
2. Develop a moving average model with k = 3. Calculate MAE,
MSE, MAPE
Notes:
Show in excel how you will arrange the data and calculate values
for Forecast, Forecast Error, Absolute value of Forecast error,
Squared forecast error, % Error, Absolute value of percentage
error.
And describe each step in how to get the forecast in excel
(hint: using Data, Data Analysis)
Quarter Year 1 Year 2 Year 3 Year 4 1 49 60 75 90 2 120 140 180 260 3 310 380 430 510 4 620 710 900 1020
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!