CHITEST function - The function returns the independence test in Excel

The following article details how to use CHITEST, the function returns independence test.

The following article details how to use CHITEST, the function returns independence test.

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:

Picture 1 of CHITEST function - The function returns the independence test in Excel

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:

Picture 2 of CHITEST function - The function returns the independence test in Excel

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

Picture 3 of CHITEST function - The function returns the independence test in Excel

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

Picture 4 of CHITEST function - The function returns the independence test in Excel

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!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile