CHITEST function

Category: Compatibility
Introduced: Excel 365

Summary

Returns the test for independence

Syntax

CHITEST(actual_range,expected_range) The CHITEST 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.

Example

=CHITEST(A2:B4,A6:B8)

Microsoft Support Page

https://support.microsoft.com/en-us/office/chitest-function-981ff871-b694-4134-848e-38ec704577ac

Back to Functions