Formulas > =T.INV()

How to Use T.INV() in Google Sheets

Description

Calculates the negative inverse of the one-tailed TDIST function.

How To Actually Use T.INV() in Sheets

T.INV(probability, degrees_freedom)

Try T.INV yourself

In cells A1:A10, enter different probability values (between 0 and 1). In cell B1, use the T.INV formula to calculate the left-tailed inverse t-value for a degrees of freedom value of 10. Your formula should reference A1 for the probability.

Hints (2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Learn more about the T.INV() formula:

Generate a T.INV() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses T.INV(). 2 free AI generations, no signup. Members get unlimited use.

Generate a T.INV() formula