TD_SIGNIF_RESIDMEAN Function | Teradata Vantage - TD_SIGNIF_RESIDMEAN - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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.