Formulas and Functions
TDIST
The TDIST function returns the probability from 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. |