T.DIST.2T (X, DegreesOfFreedom) T.DIST.2T (X; DegreesOfFreedom)
X
Number Number
The value at which to evaluate the function, which must not be negative.
DegreesOfFreedom
Number Number
The degrees of freedom parameter for the distribution, which is usually the size of the sample minus 1.
Returns
Number Number
The two-tailed probability of Student's t-distribution.
Returns the two-tailed probability of Student's t-distribution, which is the probability that a value is at least as far from 0, in either direction, as the value of the X parameter. See T.DIST for a description of the distribution.
Example
T.DIST.2T (1.96, 60)
T.DIST.2T (1,96; 60)
Returns roughly 0.055.