Microsoft® Excel® 2010 Formulas & Functions Inside Out
by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock
T.INV()
Syntax. T.INV(probability,degrees_freedom)
Definition. This function returns the left quantile of a Student’s t-distribution.
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() function returns the #VALUE! error.
If probability is less than 0 or greater than 1, the T.INV() function returns the #NUM! error.
If degrees_freedom isn’t an integer, the decimal places are truncated. If degrees_freedom is less than 1, the function returns the #NUM! error.
Background. You will find more information about t-values or critical values ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access