The Durbin-Watson calculator gives the Durbin-Watson statistic, the estimated autocorrelation and an approximate p-value from the sums that your regression software reports for the residuals.
How the calculation works
- Enter the number of observations.
- Enter the sum of squared residuals and the sum of squared differences of successive residuals.
- The calculator gives d, the autocorrelation, the z statistic and the p-value.
Example
With 60 observations, a sum of squared residuals of 48.2 and a sum of squared successive differences of 90.4, d = 90.4 / 48.2 = 1.876. The autocorrelation is 1 − d / 2 = 0.062, the z statistic is 0.48 and the two-sided p-value is 0.6297, so the residuals are not significantly correlated at the 5 % level.
Why it matters
The calculator helps students, analysts and economists to check the independence of the errors of a regression on time ordered data, such as sales by month or prices by year.
Good to know
The residuals must be in time order, because the statistic compares each residual with the previous one. The p-value given here is the large-sample normal approximation, and for small samples or for borderline cases you should check the Durbin-Watson tables, with the lower bound dL and the upper bound dU: below dL there is evidence of positive autocorrelation, above dU there is none, and between the two the test is inconclusive. The test does not apply when the model includes the lagged dependent variable, where the Durbin h test is used. Plot the residuals over time as well, since a pattern is often clear to the eye.
Related tools
The linear regression calculator fits a line, the regression prediction interval calculator gives the uncertainty of a forecast, the correlation significance calculator tests a correlation and the normal distribution calculator gives probabilities.