T.DIST.RT Function

Basic Description

The Excel T.DIST.RT function calculates the right-tailed Student’s T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.

Syntax: T.DIST.RT( x, degrees_freedom )

where the function arguments are:

x The value at which you want to evaluate the right-tailed Student’s T-Distribution
degrees_freedom The number of degrees of freedom (must be ≥ 1)


T.Dist.Rt Function Example

Plot of 1-Tailed Student's T Distribution with 10 Degrees of Freedom

Right-Tailed Student’s T-Distribution with 10 Degrees of Freedom

The chart on the right shows the right-tailed Student’s T Distribution with 10 degrees of freedom.

If you want to calculate the value of this function at x = 1, this can be done using the Excel T.Dist.Rt function, as follows:

=T.DIST.RT( 1, 10 )

This gives the result 0.170446566, or 17.04%.

Similarly, if you want to calculate the value of the function, at x = -1, this can be done as follows:

=T.DIST.RT( -1, 10 )

This gives the result 0.829553434, or 82.96%.


T.Dist.Rt Function Errors

If you get an error from your Excel T.Dist.Rt function this is likely to be one of the following:

#NUM! Occurs if the supplied degrees_freedom argument is < 1
#VALUE! Occurs if either of the supplied arguments are non-numeric

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment