CHISQ.TEST function

The CHISQ.TEST function is one of the statistical functions. It is used to return the test for independence, the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom.

Syntax

CHISQ.TEST(actual_range, expected_range)

The CHISQ.TEST function has the following arguments:

Argument	Description
actual_range	The range of observed (actual) values.
expected_range	The range of expected values.

Notes

The ranges must contain the same number of values. Each of the expected values should be greater than or equal to 5.

How to apply the CHISQ.TEST function.

Examples

The figure below displays the result returned by the CHISQ.TEST function.