TD_GOLDFELD_QUANDT Function Example | Teradata Vantage - TD_GOLDFELD_QUANDT Example - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Publication Date
June 2022
Content Type
Reference
Publication ID
B700-1150-172K
ft:locale
en-US
ft:lastEdition
2026-03-23
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
ft:sourceId
dita
dita:id
ncd1634149624743

TD_GOLDFELD-QUANDT Input Table GQ_T1

SeriesID ROW_I Y2 Y1 X1
33 1 3.0 3.0 1.0
33 2 7.0 7.0 2.0
33 3 9.0 9.0 3.0
33 4 11.0 11.0 4.0
... ... ... ... ...

Example: TD_GOLDFELD-QUANDT Call

EXECUTE FUNCTION INTO VOLATILE ART(GQT1D)
TD_GOLDFELD_QUANDT(
   SERIES_SPEC(TABLE_NAME(GQ_T1), ROW_AXIS(SEQUENCE(X1)), SERIES_ID(SeriesID),
      PAYLOAD(FIELDS(Y1, X1), CONTENT(MULTIVAR_REAL) )
   ),
 
   FUNC_PARAMS(CONST_TERM(1), OMIT(2), SIGNIFICANCE_LEVEL(0.05) ,
      ALGORITHM('QR')
   ) 
 
);

TD_GOLDFELD-QUANDT Output

SELECT * FROM GQT1D;
SeriesID 33
ROW_I 0
TOTAL_NUM_SAMPLES 20
VARIABLES_COUNT 2
NUM_SAMPLES1 9
NUM_SAMPLES2 9
OMMITTED 2
DEGREES_FREEDOM_1 7
DEGREES_FREEDOM_2 7
SIGNIFICANCE_LEVEL 5.00000000000000E-002
GQ_STATISTIC 1.30952380952381E 000
GQ_PVALUE 3.65514546305097E-001
F_CRITICAL_VALUE_HI 3.78704353992807E 000
F_CRITICAL_VALUE_LOW ?
TEST GREATER
NULL_HYPOTHESIS ACCEPT HYPOTH:MEANING THERE IS HOMOSCEDASTIC VARIANCE