CHITEST function
the test for independence.
Compatibility
Where can you use it?
Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.
Scenario in the workbook
Check a legacy chi-square goodness-of-fit calculation. CHISQ.TEST is the replacement for new workbooks.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | 12 | 10 |
| 8 | 8 | 10 |
| 9 | 10 | 10 |
Record 1
=CHITEST(A7:A9,B7:B9)Expected result0.670320046
See the inputs and instructions for all 3 examplesCopyable formulas
English Excel · en-US
=CHITEST(A7:A9,B7:B9)Turkish Excel · tr-TR
=KİKARETEST(A7:A9;B7:B9)Compatibility function for older workbooks.
Worked examples
Check a legacy chi-square goodness-of-fit calculation. CHISQ.TEST is the replacement for new workbooks.
Use the blue inputs in the table starting at A6. F7:F9 calculate results and G7:G9 retain the original values for comparison.
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | 12 | 10 |
| 8 | 8 | 10 |
| 9 | 10 | 10 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =CHITEST(A7:A9,B7:B9) |
0.670320046 |
| Record 2 | =CHITEST(A7:A9,B7:B9) |
0.670320046 |
| Record 3 | =CHITEST(A7:A9,B7:B9) |
0.670320046 |