Sign up for free
Functions

T.INV.2T

Calculates the t-value for a given two-tailed probability and degrees of freedom. The result is always positive since it represents the absolute t-value for two-tailed tests.

Parameter List

Syntax
T.INV.2T(probability, deg_freedom)
probability

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

deg_freedom

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

More details

T.INV.2T returns the positive t-value where the two-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 two-tailed t-tests and confidence intervals.

Examples

T.INV.2T() returns 1