T.DIST.RT Function
Returns the right-tailed Student's t distribution — a one-sided p-value.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
The t distribution is a bell curve with heavier tails, used instead of the normal distribution when the standard deviation is estimated from a small sample. The more degrees of freedom, the closer it gets to the normal curve.
T.DIST.RT returns the probability of a t value greater than x: the one-sided p-value when you're testing for an increase. It is exactly half of T.DIST.2T for positive x.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The t value. |
| deg_freedom | Yes | Degrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1. |
Examples
Example 1 — One-sided p-value
The same t = 2.1 with 15 degrees of freedom, testing only for an increase.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | t statistic | 2.1 |
| 3 | Degrees of freedom | 15 |
| 4 | Right tail p | 0.0265 |
p ≈ 0.027 — significant one-sided, because all 5% sits in one tail. Decide on one or two tails before looking at the data.
Common mistakes
- #NUM! deg_freedom is less than 1.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.