Generally used in the study of qualitative variables. One can compare observed frequencies in a one-way frequency table with expected frequencies, or study the connection between two variables in a contingency table.Chi-squared test functions are used to determine whether there is a statistically significant difference between the expected frequencies and the observed frequencies in one or more groups. Often a histogram is used, and the different bins are compared to an expected distribution.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
If the function is used in the data load script, the values are iterated over a number of records as defined by a group by clause.
If the function is used in a chart expression, the values are iterated over the chart dimensions.
Chi2Test_chi2() returns the aggregated chi2-test value for one or two series of values.
chi2test_chi2(col, row, actual_value[, expected_value])
Chi2Test_df() returns the aggregated chi2-test df value (degrees of freedom) for one or two series of values.
chi2test_df(col, row, actual_value[, expected_value])
Chi2Test_p() returns the aggregated chi2-test p value (significance) for one or two series of values.
chi2test_p(col, row, actual_value[, expected_value])