T.INV

The T.INV function in Google Sheets calculates the negative inverse of the one-tailed TDIST function. It is a statistical function that is commonly used in hypothesis testing and confidence interval calculations.

Function Syntax and Parameters

Syntax: T.INV(probability, degrees_freedom)

Parameters:

• probability: The probability associated with the one-tailed TDIST function.
• degrees_freedom: The degrees of freedom for the distribution.

Step-by-Step Tutorial

1. Using T.INV with a probability and degrees of freedom:
   • Example: =T.INV(0.05, 10)
   • Result: -1.812462

Use Cases and Scenarios

1. Hypothesis Testing: Determine the critical value for a given significance level and degrees of freedom.
2. Confidence Intervals: Calculate the confidence interval for a sample mean.

Related Functions

• T.TEST: Perform a t-test to determine whether two samples are likely to have come from the same population.

Related Articles

• Understanding Statistical Functions in Google Sheets