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
Posted: Sat Feb 26, 2022 11:18 am
- 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 38 times
0.2.
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