T.DIST.2T(x, degrees_freedom)

Returns the percentage points probability for the t distribution.

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" = 2.
* 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.2T(0.5,1) = 0.705
2=2*T.DIST.RT(0.5,1) = 0.705
3=T.DIST.2T(1,1) = 0.500
4=T.DIST.2T(1.5,1) = 0.374
5=T.DIST.2T(2,1) = 0.295
6=T.DIST.2T(2.5,1) = 0.242
7=T.DIST.2T(5,1) = 0.126

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