TINV

Formulas / TINV
Calculate the two-tailed inverse of the Student's t-distribution.
=TINV(probability,deg_freedom)
  • probability - the probability associated with the two-tailed Student's t-distribution
  • degrees_freedom - [OPTIONAL] the number of degrees of freedom for a distribution

Examples

  • =TINV(0.054645,60)

    The TINV function can be used to calculate the t-value of the Student's t-distribution for a given probability and degrees of freedom. For example, let's say you wanted to calculate the t-value for a probability of 0.054645 and 60 degrees of freedom. To do this you would use the preceding formula.

  • =TINV(2.6,30)

    The TINV function can also be used to calculate the probability of a given t-value for a given degrees of freedom. For example, let's say you wanted to calculate the probability for a t-value of 2.6 and 30 degrees of freedom. To do this you would use the preceding formula.

  • =TINV(0.95,30)

    The TINV function can be used to calculate the t-value for a given confidence interval. For example, let's say you wanted to find the t-value for a 95% confidence interval and 30 degrees of freedom. To do this you would use the formula above.

  • =TINV(0.25,15)

    The TINV function can also be used to calculate the t-value for a given probability and degrees of freedom. For example, let's say you wanted to find the t-value for a probability of 0.25 and 15 degrees of freedom. To do this you would use the preceding formula.


Summary

The TINV function calculates the two-tailed inverse of the Student's t-distribution with improved accuracy and better named functions.

  • The TINV function has been updated, providing improved accuracy and better names.

Frequently Asked Questions

What is the TINV function?
The TINV function is a statistical function used to calculate the two-tailed inverse of the Student's t-distribution.
What is the purpose of the TINV function?
The TINV function is used to determine the confidence level of a given statistic by calculating the probability of a given statistic falling within a certain range.
What are the benefits of using the TINV function?
The TINV function can be used to improve accuracy when analyzing data and calculating confidence levels. It is also a useful tool for determining the probability of a given statistic falling within a certain range.
Are there any new features of the TINV function?
Yes, the new TINV functions may provide improved accuracy.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV