T.INV

Calculates the negative inverse of the one-tailed TDIST function.

Sample Usage

T.INV(0.35, 1)

T.INV(A1, A2)

Syntax

T.INV(probability, degrees_freedom)

  • probability - The probability associated with the t-distribution.

    • Must be greater than 0 and less than 1.

  • degrees_freedom - The number of degrees of freedom.

    • Truncated to an integer in the calculation if a non-integer is provided as an argument.

    • Must be greater than or equal to 1.

Notes

  • T.INV is to be used for the negative inverse of the one-tailed TDIST function.

  • Both arguments to T.INV must be numeric or a destination cell whose value is numeric.

See Also

TDIST: Calculates the probability for Student's t-distribution with a given input (x).

TINV: Calculates the inverse of the two-tailed TDIST function.

Examples

In this example, T.INV uses a probability value of 0.05757 and degrees_freedom of 45 to compute the result.

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false
false