81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



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.

How To Use in Sheets

CHITEST(observed_range, expected_range)

External Links

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.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.