T.INV.2T()/TINV()
Note
In Excel 2010 the TINV() function was replaced with the T.INV.2T() function, and the T.INV() function was added to increase the accuracy of the results. To ensure the backward compatibility of T.INV.2T(), the TINV() function is still available.
Syntax. T.INV.2T(probability,degrees_freedom)
Definition. This function returns the t-value of the t-distribution as a probability and degrees of freedom.
Arguments
probability (required). The probability associated with the two-tailed Student’s t-distribution
degrees_freedom (required). The number of degrees of freedom with which to characterize the distribution
Note
If one of the arguments isn’t a numeric expression, the T.INV.2T() function returns the #VALUE!
error.
If probability is less ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.