CHITEST

Syntax:

CHITEST ( actual-range , expected-range )

Description: Computes the test for independence. CHITEST returns the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.

Mathematical Formula:

The χ2 test first calculates a χ2 statistic using the formula:

where:

Aij = actual frequency in the i-th row, j-th columnEij = expected frequency in the i-th row, j-th columnr = number or rowsc = number of columns

CHITEST uses the χ2 distribution with an appropriate number of degrees of freedom, df. If r > 1 and c > 1, then df = (r - 1)(c - 1). If r = 1 and c > 1, then df = c - 1 or if r > 1 and c = 1, then df = r - 1.

Arguments:

Return Type and Value: number – The value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.

However, if:

• The number of rows and columns is exactly one, the return value is unspecified.

• actual-range and expected-range have a different number of data points, the return value is unspecified.