Menu
EXCEL TINV FUNCTION
Excel TINV Function Introduction
The TINV function in Excel computes the inverse of the two-tailed Student’s T Distribution, which is a continuous probability distribution commonly used for testing hypotheses on small sample data sets.
Description of Excel TINV Function
Syntax :
=TINV( probability, degrees_freedom )
Parameters :
- probability – The probability (between 0 and 1) at which you wish to calculate the invert of the 2 tailed Student’s T Distribution.
degrees_freedom – The amount of degrees of freedom required (must be 1).
Step By Step Guide of TINV Function
Example :
The 2-tailed Inverse Student’s T Distribution with 10 degrees of freedom is seen on the right.
If you need to measure the value of this expression for a probability of 0.25, use the Excel Tinv function, as shown below:
=TINV( 0.25, 10 )
This yields the value 1.221255395.
If you wish to find the value of the 1-tailed inverse Student’s T-Distribution with a probability of 0.25, just double the probability:
=TINV( 0.5, 10 )
This yields the value 0.699812061.
Key Points
Excel calculates the Tinv function result iteratively, looking for a result, x, such that TDIST(x, degrees freedom, 2) = probability.
The Tinv Function in Excel determines the inverse of the two-tailed Student’s T Distribution.
- Simply double the probability to calculate the inverse of the one-tailed t-distribution.
- To put it another way, the one-tailed inverse Student’s T Distribution = TINV(2*probability, degrees freedom).
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
