In: Other
Consider the following time series data.
Week | 1 | 2 | 3 | 4 | 5 | 6 |
Value | 20 | 13 | 15 | 11 | 17 | 14 |
Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy:
a. Mean absolute error (MAE)
b. Mean squared error (MSE)
c. Mean absolute percentage error (MAPE)
Round your answers to two decimal places.
MAE =
MSE =
MAPE =
Using the average of all the historical data as a forecast for the next period, compute the same three values. Round your answers to two decimal places.
MAE =
MSE =
MAPE =
Which method appears to provide the more accurate forecasts for the historical data?
Answer:
a. Using Naive method as the forecast for the next week, compute the following measures of forecat accuracy:
Naive Method: The naive forecast method is the simplest forecast method of all. The last period's actual value is taken as the current forecast value.
Overall calculation:
Excel formulas:
b. Using the average of all the historical data as a forecast for the next period, compute the same three values.
Overall calculation:
Excel formulas:
c. Which method appears to provide the more accurate for the historical data?
Average of all the historical data, provides the better and accurate forecast in terms of MAE, MSE and MAPE when compared to the values of Naive method and its MAE, MSE and MAPE. Since, the error values are much lowest and more closest to the actual data.
Formulas for your reference:
Mean Absolute Error (MAE) = |Error| / n
Here: |Error| = |Value - Forecast|
Mean Squared Error (MSE) = Error^2 / n
Here: Error^2 = (Value - Forecast)^2
Mean Absolute Ppercentage Error (MAPE) = Error% / n
Here: Error% = (|Error| / Value) x 100