T.INV

Formulas / T.INV
Calculate the left-tailed inverse of the Student's t-distribution.
T.INV(probability, deg_freedom)
  • probability - the probability associated with the Student's t-distribution
  • deg_freedom - [REQUIRED] the number of degrees of freedom for describing the distribution

Examples

  • =T.INV(0.05, 10)

    In this example, the T.INV function is used to calculate the t-value (t-score) corresponding to a one-tailed probability of 0.05 and 10 degrees of freedom. This is commonly used in hypothesis testing to find the critical value for a one-tailed t-test with a significance level of 0.05. The formula returns the t-value of approximately -1.8125.

  • =T.INV(0.1, 15)

    In this example, the T.INV function is used to calculate the t-value (t-score) corresponding to a one-tailed probability of 0.1 and 15 degrees of freedom. This is commonly used in hypothesis testing to find the critical value for a one-tailed t-test with a significance level of 0.1. The formula returns the t-value of approximately -1.3406.

Summary

The T.INV function is used to calculate the left-tailed inverse of the Student's t-distribution. It requires two arguments: probability and deg_freedom. It is a useful tool for statistical analysis.

  • The T.INV function returns the left-tailed inverse of the Student's t-distribution, taking two arguments: the required probability and deg_freedom.


Frequently Asked Questions

What is the T.INV Function?
The T.INV Function is a statistical function that calculates the left-tailed inverse of the Student's t-distribution.
What are the Arguments for the T.INV Function?
The arguments for the T.INV Function are probability and deg_freedom. The probability argument is required, while the deg_freedom argument is optional.
How Do I Use the T.INV Function?
To use the T.INV Function, you need to input the probability and the deg_freedom argument into the function. This will calculate the left-tailed inverse of the Student's t-distribution.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.