SheetFX
≡
<< Go back to all functions

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