Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 3. Forecast Errors > mmMAD, Mean Average Deviation

Business Formulas

mmMAD, Mean Average Deviation

Category: Forecast

The Mean Average Deviation (MAD), which is equal to the Mean Average Error (MAE), is based on the assumption that severity of error is linearly related to its size.

Business analysis formulas for Excel. Marketing tool for professionals

Syntax

mmMAD(Actual_Data, Optional Forecast_Data)

Actual_Data Either Sales Values, then the next variable is required, or Error values
Forecast_Data Optional - Forecast Data, required if the previous variable equal to Sales Values

Example

See example file Business Formulas.xls, sheet mmMAD.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmDW
  • mmMAPE
  • 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: