Spread.Sheets Documentation
CHISQ.TEST
Spread.Sheets Documentation > Formula Reference > Formula Functions > CHISQ.TEST

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

Syntax

CHISQ.TEST(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

Remarks

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

CHISQ.TEST(B1:C8,B12:C19)

CHISQ.TEST(R1C2:R8C3,R12C2:R19C3)