Calculates the negative inverse of the one-tailed TDIST function. Learn more
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).