Skip to main content

Kutools for Office — One Suite. Five Tools. Get More Done.

Excel CHISQ.TEST function

Author Siluvia Last modified

The CHISQ.TEST function calculates the chi-squared distribution of two provided data sets (the observed and expected frequencies), which can be used to test the independence of two categorical variables.

Tips: To learn more about the chi-squared distribution, you can visit this page on Wikipedia.

show the usage of CHISQ.TEST function

Note: This CHISQ.TEST function is only available in Excel 2010 and later versions.

Syntax

=CHISQ.TEST(actual_range, expected_range)

Arguments

Actual_range (required): An array of observed frequencies used to test against the expected data.
Expected_range (required): An array of expected frequencies.

Remarks

1. The #N/A error occurs if either:
-- Two supplied arrays have different numbers of cells;
-- Either of the two arrays contains only one cell.
2. The #NUM! error occurs when any of the values in the expected data range is negative;
3. The #DIV/0! error occurs when any of the values in the expected data range is zero;
4. The equation of the CHISQ.TEST function is as follows.
show the usage of CHISQ.TEST function
where,
Aij is the actual or observed frequencies in the i’th row and j’th column;
Eij is the expected frequencies in the i’th row and j’th column;
r is the number of rows;
c is the number of columns.

Return value

It returns a numeric value.

Example

To calculate the chi-squared distribution of two provided data sets (the observed and expected data in the screenshot below), you can do as follows.

show the usage of CHISQ.TEST function

Select a cell to output the result, for example D13, enter the formula below and press the Enter key.

=CHISQ.TEST(C8:D10,G8:H10)

show the usage of CHISQ.TEST function

Related Functions

Excel CHISQ.INV function
The CHISQ.INV function calculates the inverse of the left-tailed probability of the chi-squared distribution.

Excel CHISQ.INV.RT function
The CHISQ.INV.RT function calculates the inverse of the right-tailed probability of the chi-squared distribution.

Excel CONFIDENCE.NORM function
The CONFIDENCE.NORM function uses a normal distribution to calculate the confidence interval for a population mean.

Excel CONFIDENCE.T function
The CONFIDENCE.T function uses a student’s distribution to calculate the confidence interval for a population mean.

The Best Office Productivity Tools

Kutools for Excel - Helps You To Stand Out From Crowd

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions…
Popular Features: Find, Highlight or Identify Duplicates  |  Delete Blank Rows  |  Combine Columns or Cells without Losing Data  |  Round without Formula ...
Super VLookup: Multiple Criteria  |  Multiple Value  |  Across Multi-Sheets  |  Fuzzy Lookup...
Adv. Drop-down List: Easy Drop Down List  |  Dependent Drop Down List  |  Multi-select Drop Down List...
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Columns to Select Same & Different Cells ...
Featured Features: Grid Focus  |  Design View  |  Big Formula Bar  |  Workbook & Sheet Manager | Resource Library (Auto Text)  |  Date Picker  |  Combine Worksheets  |  Encrypt/Decrypt Cells  |  Send Emails by List  |  Super Filter  |  Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters ...)  |  50+ Chart Types (Gantt Chart ...)  |  40+ Practical Formulas (Calculate age based on birthday ...)  |  19 Insertion Tools (Insert QR Code, Insert Picture from Path ...)  |  12 Conversion Tools (Numbers to Words, Currency Conversion ...)  |  7 Merge & Split Tools (Advanced Combine Rows, Split Excel Cells ...)  |  ... and more
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...

Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

  • One second to switch between dozens of open documents!
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.