Optional Syntax Elements for TD_FTest - Teradata VantageCloud Lake

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

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