IDAX.CHISQ_TEST_AGG - Pearson's chi-square

The CHISQ_TEST_AGG stored procedure calculates the Chi-square value of two integer input variables. It measures how easy it is to predict one column from the other by calculating the chi-square value between 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_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_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

DOUBLE the chi-square value, or NULL if enough data is not available.

Example

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