TD_ZTest Syntax Elements - Teradata® Database

Database Analytic Functions
Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™
FirstSampleColumn
Specify the name of the input column that contains the data for the first sample population.
FirstSampleVariance
[Required if first sample size is less than 30, optional otherwise.] Specify 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.
SecondSampleColumn
[Optional] Specify the name of the input column that contains the data for the second sample population.
SecondSampleVariance
[Required if you specify SecondSampleColumn and second sample size is less than 30, optional otherwise.] Specify 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
[Optional] Specify the alternative hypothesis:
Option Description
'lower-tailed' Alternate hypothesis (H 1): μ < μ0
'upper-tailed' Alternate hypothesis (H 1): μ > μ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 (H 1): μ ≠ μ0

Default: 'two-tailed'
MeanUnderH0
[Optional] Specify the mean under the null hypothesis (H 0). mean_under_H0 is a numeric value in the range (-1.79769e+308, 1.79769e+308).
Default: 0
Alpha
[Optional] Specify the probability of rejecting the null hypothesis when it is true (value below which null hypothesis is rejected). alpha must be a numeric value in the range [0, 1].
The null hypothesis is rejected if p_value < 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