<< Click to Display Table of Contents >> T.DIST (t-distribution) |
Syntax:
T.DIST(X, DegreesFreedom, Cumulative)
Description:
Returns the probability of the Student's t-distribution.
X is the value to be evaluated. Must be ≥ 0.
DegreesFreedom is the number of degrees of freedom. Must be ≥ 1. Integer numbers are expected. Digits to the right of the decimal point are ignored.
Cumulative determines the type of function as a switch: If you enter the value TRUE, the cumulative distribution function of the left-tailed Student's t-distribution is calculated. By entering the value FALSE, the probability density function of the Student's t-distribution is calculated.
Note:
The T.DIST function supplements together with T.DIST.2T and T.DIST.RT the previous TDIST function, whereby T.DIST has the additional argument Cumulative.
Compatibility notes:
Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.
See also:
T.DIST.2T/T.DIST.RT/TDIST, T.INV/T.INV.2T/TINV, T.TEST/TTEST