CHISQ.INV Function in Excel: Chi-Square Value for a Left-Tail Probability

CHISQ.INV Function in Excel: Chi-Square Value for a Left-Tail Probability 1
⏱ 1 min readUpdated 5 October 2026

StatisticsLevel: ExpertAvailable in: Excel 2010+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. CHISQ.INV in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

CHISQ.INV is the inverse of CHISQ.DIST (left tail).

Advertisement

Syntax

=CHISQ.INV(probability, deg_freedom)
Argument What it means
probability Left-tail probability
deg_freedom df

Examples

Example 1

=ROUND(CHISQ.INV(A2,B2),3)

Result: 0.711. See the worked example table below for more cases.

CHISQ.INV in practice

Where you will use it

  • Lower critical values
  • Confidence intervals for variance
  • Teaching

Worked example

ProbabilitydfFormulaResult
0.054=ROUND(CHISQ.INV(A2,B2),3)0.711
0.54=ROUND(CHISQ.INV(A3,B3),3)3.357
0.954=ROUND(CHISQ.INV(A4,B4),3)9.488

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Wanting the usual critical valueUse CHISQ.INV.RT(0.05, df)
Probability outside 0..1#NUM!

CHISQ.INV.RT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZIF Function in Excel: Make Decisions in a FormulaExcel Functions A–ZDDB Function in Excel: Double-Declining DepreciationExcel Functions A–ZINDIRECT Function in Excel: Build a Reference From Text
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong