TD_ChiSq Output - 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™

Output Table Schema

Column Data Type Description
chi_square DOUBLE PRECISION Chi-squared statistic.
cramers_v DOUBLE PRECISION Cramer's V statistic.
df INTEGER Degrees of freedom.
alpha DOUBLE PRECISION alpha (see TD_ChiSq Syntax Elements).
p_value DOUBLE PRECISION Probability associated with chi-squared statistic.
criticalvalue DOUBLE PRECISION Critical value calculated using Alpha for test.
conclusion VARCHAR Chi-squared test result, either 'reject null hypothesis' or 'fail to reject null hypothesis'.

Table of Expected Values

The function outputs this table only if you include the OUT clause in the function call. The OUT clause specifies its name.

This table contains the expected frequencies calculated under the assumption that the null hypothesis is true.

This table has the same schema as the CONTINGENCY table that contains the observed frequencies (see TD_ChiSq Input), except that all columns but the first have the data type DOUBLE PRECISION.