TD_SIGNIF_RESIDMEAN Function | Teradata Vantage - TD_SIGNIF_RESIDMEAN - 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
lifecycle
latest

TD_SIGNIF_RESIDMEAN is a statistical test to determine if the passed-in residual series can be classified as being white noise. White noise is a series that has zero mean, no evidence of serial correlation, and homoscedastic variance. It is a random sequence of independent values that are identically distributed. The function uses the residuals generated during model validation of the forecasted data points. The expectation is that if the appropriate ARIMA model has been chosen, then any leftover residuals are white noise.

The following procedure is an example of how to use TD_SIGNIF_RESIDMEAN:
  1. Divide the sample data into two sets. One set is used to fit the data to the model, and the other set is used to select between models.
  2. Use TD_ARIMAESTIMATE to determine the coefficients associated with the ARIMA model.
  3. Use TD_ARIMAVALIDATE to validate the coefficients and model created by TD_ARIMAESTIMATE.
  4. Use TD_EXTRACT_RESULTS to get the residuals from TD_ARIMAVALIDATE.
  5. Use TD_SIGNIF_RESIDMEAN to analyze the validate residuals and to determine whether they can be classified as being white noise.
  6. Retrieve the NULL_HYPOTH results from the TD_SIGNIF_RESIDMEAN output to determine the result of the analysis. A value of 1 means that the series is white noise with a mean of zero. A value of 0 means that the series is not White Noise and has non-zero mean.