T.DIST.RT function
T.DIST.RT returns the right-tailed Student t probability, the chance of seeing a t value this large or larger. It is used for one-sided tests with n-1 degrees of freedom.
Example
Read it as a sentence: find the right-tail probability for the t value in D1 with 60 degrees of freedom, which gives 0.5.
Excel shows 0.5
D
1
Data
Syntax
T.DIST.RT(x, deg_freedom)
-
x(required) - The t value.
-
deg_freedom(required) - Degrees of freedom, a positive integer.
Returns: The right-tailed Student t probability.
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 |
|---|---|---|
=T.DIST.RT(1.96,60) | 0.027322465 | Working example |
=T.DIST.RT("1.96",60) | 0.027322465 | Text-number in first arg |
=T.DIST.RT({1.96,1.96},60) | 0.027322465 | Array in first arg (lifts, spills) |
=T.DIST.RT(-1,10) | 0.829553434 | Negative x |
=T.DIST.RT(Data!D1,60) | 0.5 | Blank cell as first arg |
=T.DIST.RT("abc",60) | #VALUE! | Non-numeric text in first arg |
=T.DIST.RT(NA(),60) | #N/A | Error in first arg |
=T.DIST.RT(1.96,0) | #NUM! | Df 0 |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- It equals 1 minus the cumulative T.DIST.
- Fix degrees of freedom as n-1 for a one-sample test.
Where it works
- Excel
- T.DIST.RT arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, but behaves differently. Sheets has T.DIST.RT.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .