CHISQ.TEST Function in Excel: Syntax, Examples and Free Practice
CHISQ.TEST is an Excel Statistical function. Returns the chi-squared test for independence.
CHISQ.TEST syntax
Arguments
actual_range: The range containing the observed valuesexpected_range: The range containing the expected values
When to use CHISQ.TEST
CHISQ.TEST is used in data analysis work to summarize or test patterns across a data set.
Practice CHISQ.TEST online, free
Open the live Excel-style spreadsheet and try CHISQ.TEST yourself. No Excel install or sign-up needed to start.
Practice CHISQ.TEST now →More Statistical functions
Frequently asked questions
What does the CHISQ.TEST function do in Excel?
Returns the chi-squared test for independence.
What is the syntax of CHISQ.TEST in Excel?
The syntax is =CHISQ.TEST(actual_range, expected_range). actual_range: The range containing the observed values; expected_range: The range containing the expected values.
Where can I practice CHISQ.TEST online for free?
Open the free live spreadsheet on Cellgrids and try CHISQ.TEST yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts