T.DIST.RT Function

Excel Functions › Statistical

Excel 2010+ Statistical

The Excel T.DIST.RT function returns the right-tailed Student's t-distribution — the probability in the upper tail beyond a given t-value for the specified degrees of freedom.


Quick answer:
=T.DIST.RT(2,10) right-tail probability ≈ 0.0367

Syntax

=T.DIST.RT(x, deg_freedom)
ArgumentDescription
xRequiredThe t-value at which to evaluate the distribution.
deg_freedomRequiredThe degrees of freedom (a positive integer).

How to use it

T.DIST.RT gives the area under the curve to the right of x — the one-sided p-value for a directional hypothesis like “the mean is greater than expected.”

=T.DIST.RT(2, 10) // right tail ≈ 0.0367

It is the complement of the left-tailed cumulative value, so T.DIST.RT(x, df) equals 1 − T.DIST(x, df, TRUE). Doubling it gives the two-tailed result from T.DIST.2T.

=1-T.DIST(2, 10, TRUE) // same ≈ 0.0367

One-tailed p-values: T.DIST.RT is the function you reach for when reporting a one-sided test. For the corresponding critical t-value, invert it with T.INV.

Try it: interactive demo

Live demo

Pick a T.DIST.RT example to see the formula and its result.

Result:

Practice workbook

📊
Download the free T.DIST.RT practice workbook
Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.

Frequently asked questions

What does T.DIST.RT return?
The right-tail probability: the area under the t-distribution to the right of x. This is the one-sided p-value for a “greater than” hypothesis.
How does it relate to T.DIST?
It is the complement of the cumulative left tail: T.DIST.RT(x, df) = 1 − T.DIST(x, df, TRUE). Together the left and right tails sum to 1.
Can x be negative in T.DIST.RT?
Yes. Unlike T.DIST.2T, the right-tailed function accepts negative x — the area to the right of a negative t simply exceeds 0.5.
How do I get a two-tailed p-value from this?
Double it: 2 × T.DIST.RT(x, df) equals T.DIST.2T(x, df) for a non-negative x.

Master functions like this in one day

This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related functions: T.DIST · T.DIST.2T · T.INV · T.INV.2T · T.TEST · NORM.DIST