T.DIST.2T(x, degrees_freedom)

Returns the probability distribution function for a two tailed distribution (no cumulative).

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

* This function was added in Excel 2010 to replace 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.
* You can use the T.DIST function to
* You can use the T.DIST.RT functon to
* You can use the T.INV function to
* You can use the T.INV.2T function to
* You can use the T.TEST function to
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

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

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