 # How To Use CHITEST()

Description

Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution.

Common questions about the CHITEST formula
1. What is the CHITEST formula?
2. How is the CHITEST formula used in Google Sheets?
3. How do I calculate the test statistic and the p-value using the CHITEST formula?

How can the CHITEST formula be used appropriately?
The CHITEST formula is used to calculate the test statistic and p-value for a chi-square test, such as a contingency table. When using the CHITEST formula, make sure to enter the correct values for the degrees of freedom, expected values and observed values.

How can the CHITEST formula be commonly mistyped?
The CHITEST formula is commonly mistyped as CHITES or CHITESTT. It should always be typed as CHITEST with no spaces or additional characters. Other common misspellings are CHTEST, CHITSTE, CHITST.

What are some common ways the CHITEST formula is used inappropriately?
The CHITEST formula should not be used for tests other than the chi-square test. It should not be used to calculate other test statistics, such as t-tests, ANOVAs, or F-tests. Additionally, it should not be used with non-numerical values.

What are some common pitfalls when using the CHITEST formula?
1. Make sure to enter the correct degrees of freedom, expected values and observed values into the formula.
2. Make sure to double-check that the formula has been typed correctly and there are no additional spaces or characters.
3. Make sure that the values used in the formula are all numerical and can be used in a chi-square test.

What are common mistakes when using the CHITEST Formula?

1. Incorrectly entering the number of degrees of freedom, expected values, or observed values.
2. Not double-checking the formula for any extra spaces or characters.
3. Not using numerical values that can be used in a chi-square test.

What are common misconceptions people might have with the CHITEST Formula?
1. That the CHITEST formula can be used for tests other than the chi-square test.
2. That the CHITEST formula can be used with non-numerical values.
3. That the CHITEST formula will automatically calculate the p-value, when it actually only calculates the test statistic.

How To Actually Use CHITEST() in Sheets

`CHITEST(observed_range, expected_range)`

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

Google Sheets: Performing a Chi-Squared Test

This video explains how to perform a Chi-Squared test of independence on a two-way table using Google Sheets. The techniques will also work on other spreadsheets. The intended audience is IBDP mathematics students, particularly those taking the Mathematical Studies course or the new "Applications & Interpretation" course from 2019. The video shows how to calculate the test statistic without using the built-in functions.

Better Sheets