T.DIST FunctionWayne Becker20151019T02:04:06+00:00
The T.DIST function returns the onetailed Student’s T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.
 This function was introduced in Excel 2010 and so is not available in earlier versions.
Syntax
=T.DIST(x,deg_freedom,cumulative)
Arguments
Argument 
Description 
x 
The value at which you want to evaluate the distribution 
deg_freedom 
An integer indicating the number of degrees of freedom – must be ≥ 1 
cumulative 
A logical value that determines the form of the function

TRUE 
– 
Returns the cumulative distribution function 

FALSE 
– 
Returns the probability density function 

Examples

A 
B 
C 
1 
Formula 
Result 
Notes 
2 
=T.DIST(50,1,TRUE) 
0.993655 
Student’s lefttailed tdistribution for 50, returned as the cumulative distribution function, using 1 degree of freedom 
3 
=T.DIST(50,1,FALSE) 
0.000127 
Student’s lefttailed tdistribution for 50, returned as the probability density function, using 1 degrees of freedom 
Common Function Error(s)
Problem 
What went wrong 
#VALUE! 
Occurs if any of the supplied arguments are nonnumeric 
#NUM! 
Occurs if cumulative is TRUE and the supplied deg_freedom argument is < 1 
#DIV/0! 
Occurs if cumulative is FALSE and the supplied deg_freedom argument is < 1 