Optional Syntax Elements for TD_ZTest - Analytics Database

Database Analytic Functions
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-01
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™
SecondSampleColumn
Specifies the input column name that contains the data for the second sample population.
SecondSampleName
Specifies the second sample name, must exist in SampleColumn.
FirstSampleVariance
[Required if first sample size is less than 30, optional otherwise.] Specifies the variance of the first sample population. variance_1 is a numeric value in the range (0, 1.79769e+308).
Default behavior: If sample size is greater than 30, the function approximates the variance.
SecondSampleVariance
[Required if you specify SecondSampleColumn and second sample size is less than 30, optional otherwise.] Specifies the variance of the second sample population. variance_2 is a numeric value in the range (0, 1.79769e+308).
Default behavior: If sample size is greater than 30, the function approximates the variance.
AlternativeHypothesis
Specifies the alternative hypothesis:
Option Description
'upper-tailed' Alternate hypothesis (H1): μ > μ0
'lower-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'
MeanUnderH0
Specifies the mean under the null hypothesis (H0). mean_under_H0 is a numeric value in the range (-1.79769e+308, 1.79769e+308).
Default: 0
Alpha
The null hypothesis is rejected if the P-value is smaller than the specified Alpha value (where Alpha is the probability of rejecting the null hypothesis when it is true). alpha must be a numeric value in the range [0, 1].
The null hypothesis is rejected if p_value is less than alpha. (For a description of p_value, see TD_ZTest Output.) If the null hypothesis is rejected, the rejection confidence level is 1-alpha.
Default: 0.05