Syntax
T.DIST.RT(x, deg_freedom)
| Parameter | Description |
|---|---|
| x | Parameter of the T.DIST.RT function. |
| deg_freedom | Parameter of the T.DIST.RT function. |
Examples
Right-tail p-value for t=1.5
Formula
=T.DIST.RT(1.5, 20)
Returns ~0.0746. The probability of observing a t-value of 1.5 or greater with 20 degrees of freedom is about 7.5%.
Significance check at t=2.8
Formula
=T.DIST.RT(2.8, 30)
Returns ~0.0044. Highly significant — less than 0.5% probability in the right tail.
Large degrees of freedom
Formula
=T.DIST.RT(1.96, 1000)
Returns ~0.0251. With high df, this approaches the normal distribution's right-tail probability of 0.025 at z=1.96.
Common Errors
#NUM!
Degrees of freedom must be at least 1.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Relationship to T.DIST
T.DIST.RT(x, df) = 1 - T.DIST(x, df, TRUE). It simply gives the complement of the left-tail CDF.
Accepts negative x
Unlike TDIST, T.DIST.RT accepts negative values of x. T.DIST.RT(-2, 10) returns a value greater than 0.5, which is the probability of being above a negative t-value.
One-sided hypothesis tests
Use T.DIST.RT directly for one-sided tests where your alternative hypothesis is that the true value exceeds the null. If your test statistic is negative, the right-tail p-value will be large, correctly indicating non-significance.
Try T.DIST.RT in Viztab
Import your data and use T.DIST.RT with 370+ other formulas. No signup required.
Open Viztab