The Excel function: CHISQ.TEST
Syntax
CHISQ.TEST(actual_range,expected_range)
The CHISQ.TEST function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
- 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.