Returns the test for independence
The CHISQ.TEST function returns the the test for independence. CHISQ.TEST returns the value from the chi-squared (χ2) distribution for the statistic and
the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment.
Using the CHISQ.TEST function:
The arguments for the CHISQ.TEST function are:
||The range of data that contains observations to test against expected values.
||The range of data that contains the ratio of the product of row totals and column totals to the grand total.
The CHISQ.TEST function returns the the test for independence.