TD_ACF Function | Teradata Vantage - TD_ACF - 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_ACF calculates the autocorrelation or autocovariance of a time series. Autocorrelation and autocovariance show how the time series correlates or covaries with itself when delayed by a lag in time or space. When TD_ACF is computed, a coefficient corresponding to a particular lag is affected by all the previous lags. For example, the coefficient for lag 4 includes effects of activity at lags 3, 2, and 1.

The function is useful for identifying patterns and dependencies in time series data. For example, a positive autocorrelation at lag 1, indicates that the value of a time series at time t is positively correlated with the value at time t-1, suggesting a trend or momentum in the data. On the other hand, negative autocorrelation at lag 1 indicates a reversal or mean reversion in the data.

TD_ACF can determine the appropriate lag order for an autoregressive (AR) or moving average (MA) model. If TD_ACF shows a significant positive or negative correlation at a given lag, include that lag in the model as a predictor variable.

In addition to the TD_ACF, there is TD_PACF (partial autocorrelation function) that measures the correlation between a time series and its lagged values while controlling for the effects of intermediate lags.