CHITEST Function in Excel: Syntax, Examples and Free Practice
CHITEST is an Excel Compatibility function. Legacy chi-squared test — kept for compatibility with older files.
CHITEST syntax
Arguments
actual_range: The range containing the observed valuesexpected_range: The range containing the expected values
When to use CHITEST
CHITEST is kept mainly for opening older files built in earlier versions of Excel.
Practice CHITEST online, free
Open the live Excel-style spreadsheet and try CHITEST yourself. No Excel install or sign-up needed to start.
Practice CHITEST now →More Compatibility functions
- BETADIST
- BINOMDIST
- CHIDIST
- CHIINV
- CONFIDENCE
- COVAR
- CRITBINOM
- EXPONDIST
- FDIST
- FINV
- FTEST
- GAMMADIST
- GAMMAINV
- HYPGEOMDIST
Frequently asked questions
What does the CHITEST function do in Excel?
Legacy chi-squared test — kept for compatibility with older files.
What is the syntax of CHITEST in Excel?
The syntax is =CHITEST(actual_range, expected_range). actual_range: The range containing the observed values; expected_range: The range containing the expected values.
Where can I practice CHITEST online for free?
Open the free live spreadsheet on Cellgrids and try CHITEST yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Compatibility functions · Excel case studies · Excel tutorials · Excel shortcuts