CHITEST

See Also

Returns the test for independence. CHITEST returns the value from the chi-squared (γ2) distribution for the statistic and the appropriate degrees of freedom. You can use γ2 tests to determine whether hypothesized results are verified by an experiment.

Syntax

CHITEST(actual_range,expected_range)

Actual_range   is the range of data that contains observations to test against expected values.

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

Remarks

• If actual_range and expected_range have a different number of data points, CHITEST returns the #N/A error value.
• The γ2 test first calculates a γ2 statistic and then sums the differences of actual values from the expected values. The equation for this function is CHITEST=p( X>γ2 ), where:

  

  and where:

  Aij = actual frequency in the i-th row, j-th column

  Eij = expected frequency in the i-th row, j-th column

  r = number or rows

  c = number of columns

  CHITEST returns the probability for a γ2 statistic and degrees of freedom, df, where df = (r - 1)(c - 1).

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

How?