CHITEST
Spread WinRT Documentation > Formula Reference > Formula Functions > CHITEST

Summary

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)

See Also