TINV


Description Computes the x value corresponding to a specified probability value, given a specified number of degrees of freedom. TINV assumes that this is a two-tailed test of a normal distribution curve.

TINV is the inverse of TDIST.

Syntax TINV (prob, df)
Argument Description
prob A number between 0 and 1 indicating the probability for which you want the corresponding x value.
df A positive integer indicating the number of degrees of freedom. Decimal values will be truncated to integers.

Remarks This is the complementary version of TINV.

Examples This function returns 9.925:

TINV (0.01, 2)

This function returns 3.182:

TINV (0.05, 3)

See Also BETADIST, BINOMDIST, CHIDIST, COMBIN, CRITBINOM, FDIST, GAMMADIST, NORMDIST, TDIST