T.DIST FunctionWayne Becker
The T.DIST function returns the one-tailed 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.
||The value at which you want to evaluate the distribution
||An integer indicating the number of degrees of freedom – must be ≥ 1
||A logical value that determines the form of the function
||Returns the cumulative distribution function
||Returns the probability density function
||Student’s left-tailed t-distribution for 50, returned as the cumulative distribution function, using 1 degree of freedom
||Student’s left-tailed t-distribution for 50, returned as the probability density function, using 1 degrees of freedom
Common Function Error(s)
||What went wrong
||Occurs if any of the supplied arguments are non-numeric
||Occurs if cumulative is TRUE and the supplied deg_freedom argument is < 1
||Occurs if cumulative is FALSE and the supplied deg_freedom argument is < 1