TDIST

The TDIST function returns the probability from the student’s t-distribution.

TDIST(non-neg-x-value, degrees-freedom, tails)

non-neg-x-value: A number value representing the x value at which you want to evaluate the function. non-neg-x-value must be greater than or equal to 0.

degrees-freedom: A number value representing the number of degrees of freedom. degrees-freedom must be greater than or equal to 1.

tails: A modal value specifying the number of tails to return.

one tail (1): Return the value for a one-tailed distribution.

two tails (2): Return the value for a two-tailed distribution.

Examples

=TDIST(4, 2, 1) returns 0.0285954792089682 for the one-tailed distribution.

=TDIST(4, 2, 2) returns 0.0571909584179364 for the two-tailed distribution.

See also
TINV
TTEST