Navigation:  Formula Reference > Spreadsheet Formula Functions >

CHISQ.TEST

Previous pageReturn to chapter overviewNext page

 

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)