CHITEST function

The CHITEST 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

CHITEST(actual_range, expected_range)

The CHITEST 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 CHITEST function.

Examples

The figure below displays the result returned by the CHITEST function.