T.INV.2T

T.INV.2T(probability, degrees_freedom)

Returns the inverse of the probability distribution function for a two tailed distribution.

probabilityThe probability associated with the distribution.
degrees_freedomThe number of degrees of freedom.

REMARKS
* For an illustrated example refer to the page under Distributions
* The t distribution is a continuous distribution
* The random variable returned by this function if often referred to as a critical value.
* You can use the T.DIST function to return the probability distribution function for a t distribution (left tailed).
* You can use the T.DIST.2T function to return the probability distribution function for a two tailed distribution (no cumulative).
* You can use the T.DIST.RT function to return the probability distribution function for a two tailed distribution (no cumulative).
* You can use the T.INV function to return the inverse of the probability distribution function for a t distribution (left tailed)
* You can use the T.TEST function to return the probability value from a t distribution.
* This function was added in Excel 2010 to replace the TINV function.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=T.INV.2T(0.054645, 60) = 1.960


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