T.INV Function

Basic Description

The Excel T.INV function calculates the two-tailed inverse Student’s T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.

Syntax: T.INV( probability, degrees_freedom )

Where the function arguments are:

probability The probability (between 0 and 1) for which you want to evaluate the inverse of the two-tailed Student’s T Distribution.
degrees_freedom The number of degrees of freedom (must be ≥ 1)

 

T.Inv Function Examples

Plot of Inverse of Left-Tailed Student's T Distribution with 10 Degrees of Freedom

Left-Tailed Inverse Student’s T-Distribution with 10 Degrees of Freedom

The chart on the right shows the left-tailed Inverse Student’s T Distribution with 10 degrees of freedom.

If you want to calculate the value of this function for a probability of 0.25, this can be done using the Excel T.Inv function, as follows:

=T.INV( 0.25, 10 )

This gives the result -0.699812061.

 

T.Inv Function Errors

If you get an error from your Excel T.Inv function this is likely to be one of the following :

#NUM! Occurs if either The supplied probability argument is ≤ 0 or > 1 or the supplied degrees_freedom argument is < 1
#VALUE! Occurs if either of the supplied arguments are non-numeric

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment