MAPE - Mean Absolute Percentage Error

Calculates the mean absolute percentage error (Deviation) function for the forecast and the eventual outcomes.

 

Syntax

MAPE(X, Y, Ret_type)

X is the original (eventual outcomes) time series sample data (a one dimensional array of cells (e.g. rows or columns)).

Y is the forecast time series data (a one dimensional array of cells (e.g. rows or columns)).

Ret_type is a switch to select the return output (1=MAPE (default), 2=Symmetric MAPE (SMAPI)).

Order Description
1 MAPE (default)
2 SMAPE
 

Remarks

  1. MAPE is also referred to as MAPD.
  2. The time series is homogeneous or equally spaced.
  3. For a plain MAPE calculation, in the event that an observation value (i.e. $x_k$) is equal to zero, the MAPE function skips that data point.
  4. The mean absolute percentage error (MAPE), also known as mean absolute percentage deviation (MAPD), measures the accuracy of a method for constructing fitted time series values in statistics.
  5. The two time series must be identical in size.
  6. The mean absolute percentage error (MAPE) is defined as follows:

    $$\mathrm{MAPE}=\frac{100}{N}\times \sum_{i=1}^N \left | \frac{x_i - \hat x_i}{x_i} \right |$$

    Where:
    • $\{x_i\}$ is the actual observations time series
    • $\{\hat x_i\}$ is the estimated or forecasted time series
    • $N$ is the number of non-missing data points
  7. When calculating the average MAPE for a number of time series, you may encounter a problem: a few of the series that have a very high MAPE might distort a comparison between the average MAPE of a time series fitted with one method compared to the average MAPE when using another method.
  8. In order to avoid this problem, other measures have been defined, for example the SMAPE (symmetrical MAPE), weighted absolute percentage error (WAPE), real aggregated percentage error, and relative measure of accuracy (ROMA).
  9. The symmetrical mean absolute percentage error (SMAPE) is defined as follows:

    $$\mathrm{SMAPE}=\frac{200}{N}\times \sum_{i=1}^N  \frac{\left | x_i - \hat x_i \right |}{\left | x_i\right |+\left | \hat x_i\right |} $$
  10. The SMAPE is easier to work with than MAPE, as it has a lower bound of 0% and an upper bound of 200%.
  11. The SMAPE does not treat over-forecast and under-forecast equally.
  12. For a SMAPE calculation, in the event the sum of the observation and forecast values (i.e. $x_k + \hat x_k$) equals zero, the MAPE function skips that data point.

Examples

Example 1:

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
A B C
Date Series1 Series2
1/1/2008 #N/A -2.61
1/2/2008 -2.83 -0.28
1/3/2008 -0.95 -0.90
1/4/2008 -0.88 -1.72
1/5/2008 1.21 1.92
1/6/2008 -1.67 -0.17
1/7/2008 0.83 -0.04
1/8/2008 -0.27 1.63
1/9/2008 1.36 -0.12
1/10/2008 -0.34 0.14
1/11/2008 0.48 -1.96
1/12/2008 -2.83 1.30
1/13/2008 -0.95 -2.51
1/14/2008 -0.88 -0.93
1/15/2008 1.21 0.39
1/16/2008 -1.67 -0.06
1/17/2008 -2.99 -1.29
1/18/2008 1.24 1.41
1/19/2008 0.64 2.37


  Formula Description (Result)
  =MAPE($B$1:$B$19,$C$1:$C$19,1) MAPE (151.503)
  =SMAPE($B$1:$B$19,$C$1:$C$19,2) SMAPE (500)

Files Examples

References

Have more questions? Submit a request

0 Comments