Quick Navigation
CHISQ.INV.RT Function
Summary
The CHISQ.INV.RT function returns the inverse of the right-tailed chi-squared distribution probability, finding the critical value x where CHISQ.DIST.RT(x, degrees of freedom) equals the specified probability. Ideal for hypothesis testing and statistical analysis.
Syntax
CHISQ.INV.RT(probability, deg_freedom)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| probability | Number |
Yes | Probability associated with the right-tailed chi-squared distribution (0 < probability < 1) |
| deg_freedom | Number |
Yes | Number of degrees of freedom (≥ 1) |
Using the CHISQ.INV.RT Function
CHISQ.INV.RT is crucial for chi-squared statistical tests, providing critical values for hypothesis testing. Use it to determine if observed data significantly differs from expected values in goodness-of-fit tests, independence tests, and variance analysis.
Common CHISQ.INV.RT Examples
Standard Chi-Squared Test (α=0.05)
=CHISQ.INV.RT(0.05,10)Returns 18.31 - critical value for 10 degrees of freedom at 5% significance (matches example data)
Quality Control Test
=CHISQ.INV.RT(0.01,15)Returns 30.58 - critical value for stricter 1% significance with 15 df
Goodness-of-Fit Test
=CHISQ.INV.RT(0.05,A1)Uses cell A1 containing degrees of freedom for flexible testing
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: Non-numeric input for probability or deg_freedom
Solution: Ensure both arguments are valid numbers
#NUM!
Cause: probability ≤ 0 or ≥ 1, or deg_freedom < 1
Solution: Use probability between 0-1 (exclusive), deg_freedom ≥ 1
#N/A
Cause: Iterative algorithm didn't converge after 64 iterations
Solution: Check input values; try slightly different probability
Notes
- Available in Excel 2010+
- Uses iterative algorithm (64 iterations max)
- Precision depends on CHISQ.DIST.RT accuracy
- Truncates non-integer deg_freedom
- Perfect companion to CHISQ.DIST.RT
Compatibility
Available in: Excel 2010, Excel 2016, Excel 365
Not available in: Excel 2007 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+, Excel 2016+, Excel 365