To compute the probability associated with a chi-square text, use the CHIDIST function. Given the value of chi-square and degrees of freedom, CHIDIST returns the probability.
Note that you would expect CHITEST to yield the value of chi-square. It does not. It returns the value of the probability associated with the chi-square and is identical to CHIDIST.
Chi-square, cross tabulation, observed frequency, expected frequency, nonparametric tests
Last Modified: 06/04/2021