Functions for parametric statistics

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.
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.
IDAX.SPLIT_TEST_S - Split specific returned strings into an output table
The SPLIT_TEST_S function splits the strings that are returned by the CHISQ_TEST_S_AGG, the T_TEST_S_AGG, the T_LS_TEST_S_AGG, or the T_ME_TEST_S_AGG functions and then returns a table with the extracted values.
IDAX.T_LS_TEST - t-Student test for the linear relationship of two columns
The T_LS_TEST stored procedure calculates the t-Student statistics of two numeric input columns to evaluate the significance of the linear relationship between them. It measures whether the column has the given mean.
IDAX.T_LS_TEST_S_AGG - t-Student test between linearly dependent samples as a string
The T_LS_TEST_S_AGG stored procedure calculates the t-Student statistics of two numeric variables to evaluate the significance of the linear relationship between them.
IDAX.T_ME_TEST - t-Student test for the expected mean of a column
The T_ME_TEST stored procedure calculates the t-Student statistics of a numeric input column to evaluate the significance of the difference between the sample mean value and an expected mean value.
IDAX.T_ME_TEST_S_AGG - t-Student test for the expected mean of a variable as a string
The T_ME_TEST_S_AGG stored procedure calculates the t-Student statistics of a numeric variable to evaluate the significance of the difference between the sample mean value and an expected mean value.
IDAX.T_PMD_TEST - t-Student test for the expected mean difference between two paired columns
The T_PMD_TEST stored procedure calculates the t-Student statistics of two paired numeric input columns. The goal is to evaluate the significance of the difference of their mean values that are compared to an expected value.
IDAX.T_TEST_AGG - t-Student test of a variable that is split into two classes
The T_TEST_AGG stored procedure calculates the t-Student statistics of a numeric variable split into two classes.
IDAX.T_TEST_S_AGG - t-Student test for a variable that is split into two classes
The T_TEST_S_AGG stored procedure calculates the t-Student statistics and the degree of freedom for an input variable the values of which are split into two classes.
IDAX.T_UMD_TEST - t-Student test for the expected mean difference between class values of a column
The T_UMD_TEST stored procedure calculates the t-Student statistics of a numeric input column the values of which are split into two classes. The goal is to evaluate the significance of the difference of the mean values of the classes.

Parent topic: Functions for parametric and nonparametric statistics