T.INV

Calculates the t-value for a given probability and degrees of freedom using the left-tailed Student's t-distribution. Used in statistical hypothesis testing and confidence intervals.

Parameter List

Syntax
T.INV(probabilitydeg_freedom)
probability

The probability associated with the left-tailed t-distribution. Must be between 0 and 1. For example: 0.05, 0.025, A1.

deg_freedom

The number of degrees of freedom. Must be ≥ 1. For example: 10, 20, B1.

More details

T.INV returns the t-value where the left-tailed probability equals the specified probability. The probability must be between 0 and 1, and degrees_freedom must be ≥ 1. This function is used for one-tailed t-tests and confidence intervals.

Examples

T.INV() returns 1