CHITEST
Returns the test for independence. Replaced by CHISQ.TEST.
Syntax
CHITEST(actual_range, expected_range)
Parameters
- 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
Example
=CHITEST(A1:B3, C1:D3)