How to Use the CHITEST Function in Excel

This guide explains how to use CHITEST Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the probability value from the χ2 distribution when squared for statistics. The function is applied to determine whether the hypothesis is executed or not.

Syntax: CHITEST (actual_range, expected_range) .

Inside:

- actual_range: The data range contains the values to be compared with the expected values, the required parameters.

- expected_range: The data range contains the ratio of the sum of the row and column totals to the total.

Attention:

- The χ2 test calculates the χ2 statistic calculated by the formula:

Inside:

+ Aij is the actual frequency in the i th row, j th column.

+ Eij is the expected frequency in the i th row, j th column.

+ r is the number of rows.

+ c is the number of columns.

- If actual_range and expected_range have different data points => the function returns the # N / A error value.

- The lower value of the independence, from the formula we see χ2 is always positive and only equals 0 if and only if Aij = Eij.

- CHITEST uses the distribution with degrees of degrees of freedom df. The method of calculating df values is as follows:

+ if r> 1 and c> 1 => df = (r-1) (c-1).

+ if r = 1 and c> 1 => df = (c-1).

+ if r> 1 and c = 1 => df = (r-1)

The value of r and c are not equal to 1, so there is no case for r = 1 and c = 1.

- The best CHITEST function should be applied in case the Eij values are not too small, the Eij should be greater than or equal to 5 to achieve the most accurate results.

For example:

In the cell to calculate enter the formula: = CHITEST (D14: D16, D17: D19) .

After entering the formula, press Enter to get the results:

Thus, the value CHIPTEST = 0.05300872 => The initial expectation is quite close to reality.

Above is a guide to using the CHIPTEST function, hoping to help you apply it a lot in your work.

Good luck!