CHITEST

This function calculates the test for independence from the chi-squared distribution.

CHITEST(obs_array,exp_array)

This function has these arguments:

Argument	Description
obs_array	Array of observed values to test against expected values
exp_array	Array of expected values against which to test observed values

The arrays in the arguments must be of the same size.

Accepts arrays of numeric data for both arguments. Returns numeric data.

CHITEST(B1:C8,B12:C19)

CHITEST(R1C2:R8C3,R12C2:R19C3)

This function is available in product version 1.0 or later.