Syntax
=T.DIST(x, deg_freedom, cumulative)Arguments
| Argument | Required | Description |
|---|---|---|
x | Required | The value |
deg_freedom | Required | Degrees of freedom (1 or more) |
cumulative | Required | TRUE for the cumulative distribution, FALSE for the density |
How to use T.DIST
T.DIST takes 3 required arguments. Type =T.DIST( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=T.DIST(60, 1, TRUE)Result =T.DIST(8, 3, FALSE)Result Related statistical functions
- STDEV.SEstimates the standard deviation from a sample.
- STDEVAEstimates the standard deviation from a sample, counting text as 0 and TRUE as 1.
- STDEVPAReturns the population standard deviation, counting text as 0 and TRUE as 1.
- STEYXReturns the standard error of the predicted y values of a straight line fit.
- T.DIST.2TReturns the two tailed Student's t distribution.
- T.DIST.RTReturns the right tailed Student's t distribution.
- T.INVReturns the left tailed inverse of the Student's t distribution.
- T.INV.2TReturns the two tailed inverse of the Student's t distribution.
- T.TESTReturns the probability from a Student's t test that two samples come from populations with the same mean.