T.INV

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

Video field
Statistical

In Google Sheets, the T.INV function is used to calculate the inverse of the Student's t-distribution.

The function takes two arguments: probability and degrees_freedom.

Probability: This is the probability associated with the two-tailed Student's t-distribution. It represents the area under the curve to the left of the t-value.

The probability should be between 0 and 1 (inclusive).

Degrees_freedom: This refers to the degrees of freedom of the t-distribution. In statistical analysis, degrees of freedom are associated with the number of independent observations in a sample.

The degrees of freedom should be a positive integer.

The T.INV function returns the t-value such that the probability of observing a value less than or equal to that t-value is equal to the given probability.

In other words, it gives the t-value that corresponds to a specific cumulative probability.

Here's an example of how to use the T.INV function in Google Sheets:

=T.INV(0.05, 10)

his formula calculates the t-value for a two-tailed t-distribution with 10 degrees of freedom and a probability of 0.05 (which corresponds to a 95% confidence level).

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!