T.INV(probability, deg_freedom)
=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.
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.