Output Columns - F-Test Analysis - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 3Analytic Functions

Product
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
yuy1504291362546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2302
Product Category
Software

The particular result table returned depends on whether the test is 1-way, 2-way or 3-way, and is built in the requested Output Database by the F-test analysis. If group-by columns are present, they comprise the Unique Primary Index (UPI). Otherwise, DF is the UPI.

Output Columns - 1-Way F-Test Analysis
Name Type Definition
DF INTEGER Degrees of Freedom for the Variable
DFErr INTEGER Degrees of Freedom for Error
F Float The computed value of the F statistic
FPValue Float The probability associated with the F statistic
FPText Char If not NULL, the probability is less than the smallest or more than the largest table value
FCallP Char The F-Test result: a=accept, p=reject (positive), n=reject (negative)
Output Columns - 2-Way F-Test Analysis
Name Type Definition
DF INTEGER Degrees of Freedom for the model
Fmodel Float The computed value of the F statistic for the model
DFErr INTEGER Degrees of Freedom for Error term
DF_1 INTEGER Degrees of Freedom for first variable
F1 Float The computed value of the F statistic for the first variable
DF_2 INTEGER Degrees of Freedom for second variable
F2 Float The computed value of the F statistic for the second variable
DF_12 INTEGER Degrees of Freedom for interaction
F12 Float The computed value of the F statistic for interaction
Fmodel_PValue Float The probability associated with the F statistic for the model
Fmodel_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
Fmodel_CallP_0.05 Char The F test result: a=accept, p=reject for the model
F1_PValue Float The probability associated with the F statistic for the first variable
F1_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F1_callP_0.05 Char The F test result: a=accept, p=reject for the first variable
F2_PValue Float The probability associated with the F statistic for the second variable
F2_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F2_callP_0.05 Char The F test result: a=accept, p=reject for the second variable
F12_PValue Float The probability associated with the F statistic for the interaction
F12_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F12_callP_0.05 Char The F test result: a=accept, p=reject for the interaction
Output Columns - 3-Way F-Test Analysis
Name Type Definition
DF INTEGER Degrees of Freedom for the model
Fmodel Float The computed value of the F statistic for the model
DFErr INTEGER Degrees of Freedom for Error term
DF_1 INTEGER Degrees of Freedom for first variable
F1 Float The computed value of the F statistic for the first variable
DF_2 INTEGER Degrees of Freedom for second variable
F2 Float The computed value of the F statistic for the second variable
DF_3 INTEGER Degrees of Freedom for third variable
F3 Float The computed value of the F statistic for the third variable
DF_12 INTEGER Degrees of Freedom for interaction of v1 and v2
F12 Float The computed value of the F statistic for interaction of v1 and v2
DF_13 INTEGER Degrees of Freedom for interaction of v1 and v3
F13 Float The computed value of the F statistic for interaction of v1 and v3
DF_23 INTEGER Degrees of Freedom for interaction of v2 and v3
F23 Float The computed value of the F statistic for interaction of v2 and v3
DF_123 INTEGER Degrees of Freedom for three-way interaction of v1, v2, and v3
F123 Float The computed value of the F statistic for three-way interaction of v1, v2 and v3
Fmodel_PValue Float The probability associated with the F statistic for the model
Fmodel_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
Fmodel_callP_0.05 Char The F test result: a=accept, p=reject for the model
F1_PValue Float The probability associated with the F statistic for the first variable
F1_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F1_callP_0.05 Char The F test result: a=accept, p=reject for the first variable
F2_PValue Float The probability associated with the F statistic for the second variable
F2_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F2_callP_0.05 Char The F test result: a=accept, p=reject for the second variable
F3_PValue Float The probability associated with the F statistic for the third variable
F3_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F3_callP_0.05 Char The F test result: a=accept, p=reject for the third variable
F12_PValue Float The probability associated with the F statistic for the interaction of v1 and v2
F12_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F12_callP_0.05 Char The F test result: a=accept, p=reject for the interaction of v1 and v2
F13_PValue Float The probability associated with the F statistic for the interaction of v1 and v3
F13_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F13_callP_0.05 Char The F test result: a=accept, p=reject for the interaction of v1 and v3
F23_PValue Float The probability associated with the F statistic for the interaction of v2 and v3
F23_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F23_callP_0.05 Char The F test result: a=accept, p=reject for the interaction of v2 and v3
F123_PValue Float The probability associated with the F statistic for the three-way interaction of v1, v2 and v3
F123_PText Char If not NULL, the probability is less than the smallest or more than the largest table value
F123_callP_0.05 Char The F test result: a=accept, p=reject for the three-way interaction of v1, v2 and v3