mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 3. Forecast Errors > mmDW, Durbin-Watson Test

Business Formulas

mmDW, Durbin-Watson Test

Category: Forecast

When the forecasting error is not assumed to be fully random, and successive error values are considered not to be statistically independent, the errors are said to be serial or autocorrelated. The Durbin-Watson test is the most universally accepted criterion for measuring the magnitude of autocorrelation.

Business analysis formulas for Excel. Marketing tool for professionals

Syntax

mmDW(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 mmDW.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmMAD
  • 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:
MM4XL All Tools
Price: euro 238.00

Vote this tool
403 votes: vote vote vote vote vote
5 stars:
145
4 stars:
187
3 stars:
61
2 stars:
8
1 star:
2
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: