TDist() returns the probability for the student's t distribution where a numeric value is a calculated value of t for which the probability is to be computed.
Syntax:
TDist(value, degrees_freedom, tails)
Return data type: number
Arguments:
| Argument | Description |
|---|---|
| value | The value at which you want to evaluate the distribution. The value must not be negative. |
| degrees_freedom | A positive integer stating the number of degrees of freedom. |
| tails | Must be either 1 (one-tailed distribution) or 2 (two-tailed distribution). |
This function is related to the TInv function
in the following way:
If prob = TDIST(value, df ,2),
then TINV(prob, df) = value
Limitations:
All arguments must be numeric, else NULL will be returned.