MAE - Mean Absolute Error

Calculates the mean absolute error function for the forecast and the eventual outcomes.

Syntax

MAE(X, Y)

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)).

Remarks

  1. The mean absolute error is a common measure of forecast error in time series analysis.
  2. The time series is homogeneous or equally spaced.
  3. The two time series must be identical in size.
  4. The mean absolute error is given by: $$\mathrm{MAE}=\frac{\mathrm{SAE}}{N}=\frac{\sum_{i=1}^N \left | x_i - \hat x_i \right |}{N}$$ Where:
    • $\{x_i\}$ is the actual observations time series.
    • $\{\hat x_i\}$ is the estimated or forecasted time series.
    • $\mathrm{SAE}$ is the sum of the absolute errors (or deviations).
    • $N$ is the number of non-missing data points.

Files Examples

Related Links

References

Comments

Article is closed for comments.

Was this article helpful?
4 out of 13 found this helpful