T.INV.2T(probability, degrees_freedom)

Returns the t value of the t distribution as a function of the probability and the degrees of freedom.

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

Remarks

* Added in Excel 2010.
* This function replaces the TINV function.
* The t distribution is a continuous distribution.
* The random variable returned by this function if often referred to as a critical value.
* For the Microsoft documentation refer to support.microsoft.com

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

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