Excel T.INV Function
The T.INV function returns the inverse of Student's left-tailed t-distribution. The t-distribution is frequently used in testing hypotheses on small sample data sets.
Note: The T.INV function was introduced in Excel 2010. So, it is not available in earlier versions of Excel.
Syntax
=T.INV(probability, deg_freedom)
Arguments
- probability (required): The probability for which you want to evaluate the inverse of the left-tailed Student's T Distribution. Note: probability must be between 0 and 1.
- deg_freedom (required): An integer indicating the number of degrees of freedom. Note: deg_freedom must be ≥ 1.
Return Value
The T.INV function returns a numeric value.
Function Notes
- If deg_freedom is not an integer, it will be truncated.
- T.INV returns the #VALUE! error if probability or deg_freedom is non-numeric.
- T.INV returns the #NUM! error if:
- probability ≤ 0 or probability > 1;
- deg_freedom < 1.
Example
To calculate the left-tailed inverse of the Student's t distribution with a probability of 68% and 2 degrees of freedom, please copy or enter the formula below in the result cell, and press Enter to get the result.
=T.INV(B7,B10)
Also, you can type the actual probability and deg_freedom values in the formula as shown below.
=T.INV(0.68,2)
Related functions
The T.INV.2T function returns the inverse of Student's two-tailed-distribution. The t-distribution is frequently used in testing hypotheses on small sample data sets.
The T.DIST function returns the Student's left-tailed t-distribution. The t-distribution is frequently used in testing hypotheses on small sample data sets.
The T.DIST.RT function returns the Student's right-tailed t-distribution. The t-distribution is frequently used in testing hypotheses on small sample data sets.
The T.DIST.RT function returns the Student's two-tailed t-distribution. The t-distribution is frequently used in testing hypotheses on small sample data sets.
Calculates the probability for Student's t-distribution with a given input (x).
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.