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)