This function calculates the test for independence from the chi-squared distribution.
CHISQ.TEST(obs_array,exp_array)
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.
Accepts arrays of numeric data for both arguments. Returns numeric data.
CHISQ.TEST(B1:C8,B12:C19)
CHISQ.TEST(R1C2:R8C3,R12C2:R19C3)
This function is available in Spread for Windows Forms 11.0 or later.