T.INV.2T

The T.INV.2T function in Google Sheets calculates the inverse of the two-tailed TDIST function. It is used to determine the value of t for a given probability and degrees of freedom.

Function Syntax and Parameters

Syntax: T.INV.2T(probability, degrees_freedom)

Parameters:

• probability: The probability associated with the two-tailed t-distribution.
• degrees_freedom: The degrees of freedom, which specifies the number of values in the final calculation that are free to vary.

Step-by-Step Tutorial

1. Using T.INV.2T to calculate the inverse of the two-tailed TDIST:
   • Example: =T.INV.2T(0.05, 10)
   • Result: The result will be the t-value for a two-tailed t-distribution with a probability of 0.05 and degrees of freedom equal to 10.

Use Cases and Scenarios

1. Statistical Analysis: Calculate critical t-values for hypothesis testing.
2. Confidence Intervals: Determine the t-value for constructing confidence intervals.
3. Quality Control: Evaluate process capability using t-values.

Related Functions

• None

Related Articles

• None