CHISQ.TEST:
Returns the test for independence
The CHISQ.TEST function returns the the test for independence. CHISQ.TEST returns the value from the chisquared (χ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:
Argument

Required?

Description

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. 
The CHISQ.TEST function returns the the test for independence.