Author: Oscar Cronquist Article last updated on May 11, 2022

The CHISQ.TEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees of freedom. Use this function to check if hypothesized results are valid.

The CHISQ.TEST function is outdated and you will find it in the compatibility category, the function has been replaced with the CHISQ.TEST function.

Formula in cell C12:


Excel Function Syntax



actual_range Required. A range of data.
expected_range Required. A range of data.


Independence is indicated by a low number of χ2.

The CHISQ.TEST function returns

  • #N/A error value if the number of data points in the arguments doesn't match.

CHISQ.TEST function equation:

Aij = actual frequency in the i-th row, j-th column

Eij = expected frequency in the i-th row, j-th column

r = number of rows

c = number of columns