ProductSolutionsTemplatesResources

TINV

See T.INV.2T

Video field
Statistical

In Google Sheets, the function TINV is used to calculate the inverse of the cumulative distribution function (CDF) of the Student's t-distribution. It provides the value (x) for which the cumulative distribution function equals a given probability, for a specified number of degrees of freedom.

The syntax for the TINV function is as follows: TINV(probability, degrees_freedom)

probability: This is the desired probability for which you want to find the corresponding value (x) in the t-distribution. The probability must be between 0 and 1. degrees_freedom: This represents the degrees of freedom for the t-distribution. It is a positive number.

The TINV function is commonly used in hypothesis testing and confidence interval calculations. It helps to find the critical value or threshold for a given probability, allowing you to make decisions about the statistical significance of a t-value.

The TINV function returns a value (x) that corresponds to the specified probability in the t-distribution with the given degrees of freedom. This value represents the critical t-value for which the cumulative probability is equal to the specified probability.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!