TDIST
Syntax:
TDIST ( x , degrees-freedom , distribution-tails )
Description: Computes the Percentage Points (probability) for the Student t-distribution where a numeric value, x, is a calculated value of t for which the Percentage Points are to be computed.
Mathematical Formula:
If distribution-tails = 1, TDIST
= P( X>x ), where X is a random variable that follows the t-distribution.
If distribution-tails = 2, TDIST
= P(|X| > x) = P(X > x or X < -x)
Arguments:
Name |
Type |
Description |
---|---|---|
x |
number |
The value at which to evaluate the distribution. |
degrees-freedom |
number |
The number of degrees of freedom, truncated to an integer. |
distribution-tails |
number |
The number of distribution tails to return, truncated to an integer. If 1, |
Return Type and Value: number – The Percentage Points (probability) for the Student t-distribution.
However, if
degrees-freedom < 1,
#NUM!
is returned.tails has any value other than 1 or 2,
#NUM!
is returned.x < 0,
#NUM!
is returned.