TD_CUMUL_PERIODOGRAM Function Example | Teradata Vantage - TD_CUMUL_PERIODOGRAM Example - Teradata Vantage

TD_CUMUL_PERIODOGRAM Call

EXECUTE FUNCTION INTO VOLATILE ART(SAV_AR2_PERIODOGRAM)
TD_CUMUL_PERIODOGRAM(
   SERIES_SPEC(TABLE_NAME(AR2_VALIDATE_RESIDUALS), SERIES_ID(DatasetID), 
      ROW_AXIS(SEQUENCE(ROW_I)), PAYLOAD(FIELDS(RESIDUAL),CONTENT(REAL))),
   FUNC_PARAMS(SIGNIFICANCE_LEVEL(0.05))
);

TD_CUMUL_PERIODOGRAM Output

SELECT * FROM SAV_AR2_PERIODOGRAM;

DataSetID 552
ROW_I 0
Bartlett_TEST_STATS 5.47306182043035E-001
P_VALUE 9.25496504201059E-001
SIGNIFICANCE_LEVEL 5.00000000000000E-002
TEST_RESULT ACCEPT:No Significant Periodicity Encountered