CHITEST

CHITEST(arg1, arg2) → { number }

Returns the test for independence: the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.

Parameters:

Name Type Description
arg1 any

The range of data that contains observations to test against expected values.

arg2 any

The range of data that contains the ratio of the product of row totals and column totals to the grand total.

Returns:

Type
number