IDAX.CHISQ_TEST_S_AGG - Pearson's chi-square with degree of freedom

The CHISQ_TEST_S_AGG stored procedure calculates the Chi-square value and the degree of freedom between two integer input variables. It measures how easy it is to predict one column from the other by calculating the chi-square value and the degree of freedom of two integer input variables. Use this stored procedure only for small data sets. For large data sets, use the CHISQ_TEST stored procedure. The CHISQ_TEST_S_AGG function takes positive values. The lower the chi-square value is, the more independent the input variables are. Input values smaller than 0 are ignored.

Syntax

IDAX.CHISQ_TEST_S_AGG(BIGINT X, BIGINT Y)

Parameter descriptions

X
Mandatory.
The first input variable.
Min: 0
Data type: BIGINT
Y
Mandatory.
The second input variable.
Min: 0
Data type: BIGINT

Returned information

A string that contains the chi-square value and the degree of freedom, or NULL if enough data is not available.

Example

SELECT IDAX.CHISQ_TEST_S_AGG(censor,total_buy) from samples.customer_churn;