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
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|