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.
The format of the function is:
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).|
The above 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:
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:
This gives the result 0.829553434, or 82.96%.
Further information and examples of the Excel T.Dist.Rt function can be found on the Microsoft Office website.
If you get an error from the 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 one or both of the supplied arguments are non-numeric.|