Optional Syntax Elements for TD_FTest - Analytics Database

Database Analytic Functions
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™
ON clause
Specifies the table name, view name, or query as a InputTable.
FirstSampleColumn
If this is specified, do not specify FirstSampleVariance. First Column to calculate variance.
SecondSampleColumn
If this is specified, do not specify SecondSampleVariance. Second Column to calculate variance.
FirstSampleName
If this is specified, do not specify FirstSampleVariance. First sample name, must exist in SampleNameColumn.
SecondSampleName
If this is specified, do not specify SecondSampleVariance. Second sample name, must exist in SampleNameColumn.
AlternativeHypothesis
Specifies the alternative hypothesis to use:
Option Description
'lower-tailed' Alternate hypothesis (H1): μ < μ0
'upper-tailed' Alternate hypothesis (H1): μ > μ0
'two-tailed' Rejection region is on two sides of sampling distribution of test statistic.

Two-tailed test considers both lower and upper tails of distribution of test statistic.

Alternate hypothesis (H1): μ ≠ μ0
Default: two-tailed
FirstSampleVariance
If this is specified, FirstSampleColumn is not needed. First distribution variance.
SecondSampleVariance
If this is specified, SecondSampleColumn is not needed. Second distribution variance.
df1
Need not be specified if FirstSampleColumn is specified. Numerator degrees of freedom.
df2
Need not be specified if SecondSampleColumn is specified. Denominator degrees of freedom.
Alpha
Alpha (ɑɑ) value specified in input query.
Default: 0.05