Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 3. Forecast Errors > mmMAPE, Mean Average Percent Error

Business Formulas

mmMAPE, Mean Average Percent Error

Category: Forecast

The Mean Average Percent Error (MAPE) measures the severity of forecast errors as the absolute value of the difference in prediction and realization relative to the realization. This measure is appropriate whenever the error is linear and symmetric.

Business analysis formulas for Excel. Marketing tool for professionals

Syntax

mmMAPE(Actual_Data, Forecast_Data)

Actual_Data Sales Values
Forecast_Data Forecast Values

Example

See example file Business Formulas.xls, sheet mmMAPE.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmDW
  • mmMAD
  • mmME
  • mmMSE
  • mmRMSE
  • mmSEASON
  • mmU
  • mmBASS
  • mmRANGE
  • mmRANK
  • mmVARc
Related MM4XL software tools
  • Forecast Manager
  • Brand Switch Analyst
  • Profile Manager
Source
Jeffrey Jarrett, 1987, Business forecasting methods
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: