CHISQ.DIST.RT function
CHISQ.DIST.RT returns the chance of a chi-squared value at least as large as x, which is exactly a p-value for a chi-squared test statistic. It equals 1 minus the cumulative CHISQ.DIST.
Example
Read it as a sentence: find the right-tail chi-square probability for the value in D1 (empty, so 0) with 3 degrees of freedom.
Excel shows 1
D
1
Data
Syntax
CHISQ.DIST.RT(x, deg_freedom)
-
x(required) - Value at which to evaluate; not negative.
-
deg_freedom(required) - Degrees of freedom, 1 or more.
Returns: The right-tailed chi-squared probability at x.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=CHISQ.DIST.RT(5,3) | 0.171797144 | Working example |
=CHISQ.DIST.RT("5",3) | 0.171797144 | Text-number in first arg |
=CHISQ.DIST.RT({5,5},3) | 0.171797144 | Array in first arg (lifts, spills) |
=CHISQ.DIST.RT(Data!D1,3) | 1 | Blank cell as first arg |
=CHISQ.DIST.RT("abc",3) | #VALUE! | Non-numeric text in first arg |
=CHISQ.DIST.RT(NA(),3) | #N/A | Error in first arg |
=CHISQ.DIST.RT(-1,3) | #NUM! | Negative x |
=CHISQ.DIST.RT(5,0) | #NUM! | Df 0 |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Equals 1 minus the cumulative CHISQ.DIST.
- x below zero returns #NUM!.
Where it works
- Excel
- CHISQ.DIST.RT arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .