CHISQ.TEST
Category: Statistical Function.
Description: Returns 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.
Syntax: CHISQ.TEST(actual_range,expected_range)
The CHISQ.TEST function syntax has the following arguments:
Actual_range: Required. The range of data that contains observations to test against expected values.
Expected_range: Required. The range of data that contains the ratio of the product of row totals and column totals to the grand total.