T.DIST.RT(x, degrees_freedom)

Returns the probability of getting greater than a particular value in a t distribution (right tailed).

xThe number from the distribution.
degrees_freedomThe number of degrees of freedom.

Remarks

* Added in Excel 2010.
* This function replaces the TDIST function when "tails" = 1.
* The t distribution is a continuous distribution.
* If you want to return 'less than' or 'equal to' then you should use the T.DIST function.
* For the Microsoft documentation refer to support.office.com

 A
1=T.DIST.RT(0.5,1) = 0.352
2=T.DIST.RT(1,1) = 0.250
3=T.DIST.RT(1.5,1) = 0.187
4=T.DIST.RT(2,1) = 0.148
5=T.DIST.RT(2.5,1) = 0.121
6=T.DIST.RT(5,1) = 0.063

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top