Spread Formula Reference
CHITEST
Formula Functions > Functions A to C > CHITEST

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

Syntax

CHITEST(obs_array,exp_array)

Arguments

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.

Data Types

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

Examples

CHITEST(B1:C8,B12:C19)

CHITEST(R1C2:R8C3,R12C2:R19C3)

Version Available

This function is available in product version 1.0 or later.

See Also

CHIDIST | CHIINV | AVERAGE | Statistical Functions