TD_CUMUL_PERIODOGRAM Input Table SAV_AR2_PERIODOGRAM
| DataSetID |
ROW_I |
ACUTAL_VALUE |
CALC_VALUE |
RESIDUAL |
|---|
| 552 |
74 |
5.9 |
5.850329 |
0.049671 |
| 552 |
76 |
6.8 |
6.351585 |
0.448415 |
| 552 |
77 |
7.8 |
6.659775 |
1.140225 |
| 552 |
78 |
7.9 |
7.387227 |
0.512773 |
| 552 |
80 |
7.7 |
8.255784 |
-0.555784 |
| ... |
... |
... |
... |
... |
Example: 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