TD_DURBIN_WATSON Function | Teradata Vantage - TD_DURBIN_WATSON - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798

TD_DURBIN_WATSON determines if there is evidence of serial correlation between residuals in a residual series. Serial correlation occurs when the residuals of a model are dependent and go against an assumption of linear regression.

This function accepts inputs from tables referenced by a SERIES_SPEC, and ART_SPEC that includes an ARTFITRESIDUALS layer. It takes values between 0 and 4, with a value of 2 indicating no serial correlation. Values between 0 and 2 indicate positive serial correlation. Values between 2 and 4 indicate negative serial correlation.

The test statistic is based on the sum of squared differences between adjacent residuals in a model. The statistic is compared to critical values that depend on the sample size and the number of independent variables in the model.

If the test statistic is significantly different from 2, then it indicates that the residuals are serial correlated, and the regression model may not be reliable. In this case, you need to change the model or employ additional techniques to account for the serial correlation.

TD_DURBIN_WATSON is a useful tool in regression analysis that helps assess the reliability of regression models. Some uses of the TD_DURBIN_WATSON are the following:
  • Model selection: Compare the statistics of different models to identify the model that has the lowest level of autocorrelation and is the most reliable.
  • Time-series analysis: Determine the order of the autoregressive process in the time-series model.
  • Quality control: Detect patterns in time series data that indicate a problem with a production process or other system.
The following procedure is an example of how to use TD_DURBIN_WATSON:
  1. Use TD_LINEAR_REGR with RESIDUALS(1) to generate an ART result containing a ARTFITRESIDUALS layer.
  2. Use TD_EXTRACT_RESULTS to generate an ART table containing the ARTFITRESIDUAL layer produced by TD_LINEAR_REGR.
  3. Use TD_DURBIN_WATSON on the extracted residuals to determine if there is serial correlation. ACCEPT means evidence of serial correlation and REJECT means no apparent evidence of serial correlation.