The T.INV function in Google Sheets calculates the negative inverse of the one-tailed Student's t-distribution, returning the t-value associated with a given probability and degrees of freedom. It's a core function for constructing confidence intervals and performing hypothesis tests. Dive into our comprehensive guide to master its application.
Parameters
probability: The probability associated with the one-tailed t-distribution.degrees_freedom: The number of degrees of freedom.
Step-by-Step Tutorial
- Calculating a t-value from a probability:
- Example:
=T.INV(0.05, 10) - Result: will return the t-value for a
5%probability with10degrees of freedom.
- Example:
Use Cases and Scenarios
- Confidence Interval Construction: Determine the critical t-value needed to build a confidence interval around a sample mean.
- Hypothesis Testing: Find the critical value for a one-tailed t-test at a given significance level.
- Academic Research: Support statistical analysis in studies that rely on small sample sizes.
Related Functions
T.DIST: Returns the Student's t-distribution.T.INV.2T: Calculates the negative inverse of the two-tailed t-distribution.TDIST: Returns the Student's t-distribution (legacy version).