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

Want to practice T.DIST.RT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=T.DIST.RT(x, deg_freedom) Explain

Arguments

ArgumentRequired?What it does
xYesThe t value.
deg_freedomYesDegrees 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.

B4fx=T.DIST.RT(B2,B3)
AB
1MeasureValue
2t statistic2.1
3Degrees of freedom15
4Right tail p0.0265
=T.DIST.RT(B2,B3) Explain

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

Kyle Stott

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.