TINV
Formulas / TINVCalculate 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?
What is the purpose of the TINV function?
What are the benefits of using the TINV function?
Are there any new features of the TINV function?
