TD_DURBIN_WATSON Function | Teradata Vantage - TD_DURBIN_WATSON - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

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.