Quick Navigation
CHISQ.DIST.RT Function
Summary
The CHISQ.DIST.RT function calculates the right-tailed probability of the chi-squared distribution, essential for chi-squared statistical tests comparing observed vs expected values in hypothesis testing scenarios.
Syntax
CHISQ.DIST.RT(x,deg_freedom)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| x | Number |
Yes | The numeric value where you want to assess the right-tailed probability |
| deg_freedom | Integer |
Yes | Degrees of freedom parameter defining the χ² distribution shape |
Using the CHISQ.DIST.RT Function
Use CHISQ.DIST.RT for one-tailed p-values in chi-squared tests. Common applications include testing categorical data independence in contingency tables and validating expected vs observed frequencies in goodness-of-fit analysis.
Common CHISQ.DIST.RT Examples
Standard χ² Test Example
=CHISQ.DIST.RT(18.307,10)Returns 0.0500006 - right-tailed probability for x=18.307 with 10 degrees of freedom, typical threshold for significance testing.
Contingency Table Test
=CHISQ.DIST.RT(B10, (rows-1)*(cols-1))Calculates p-value for independence test where B10 contains χ² statistic and degrees of freedom from table dimensions.
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: Non-numeric input for x or deg_freedom
Solution: Ensure both arguments contain valid numbers
#NUM!
Cause: deg_freedom < 1 or > 10^10
Solution: Use integer degrees of freedom within valid range
Notes
- x values below 0 return #NUM! error
- Ideal companion to CHISQ.TEST function
- Use CHISQ.DIST for left-tail or cumulative probabilities
Compatibility
Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2007 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+