CHISQ.TEST function

Category: Statistical
Introduced: Excel 2010

Summary

Returns the test for independence

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.

Example

=CHISQ.TEST(A2:B4,A6:B8)

Microsoft Support Page

https://support.microsoft.com/en-us/office/chisq-test-function-2e8a7861-b14a-4985-aa93-fb88de3f260f

Back to Functions