Syntax
=TDIST(x, deg_freedom, tails)Arguments
| Argument | Required | Description |
|---|---|---|
x | Required | The value (0 or more) |
deg_freedom | Required | Degrees of freedom (1 or more) |
tails | Required | 1 for one tail, 2 for two tails |
How to use TDIST
TDIST takes 3 required arguments. Type =TDIST( 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.
=TDIST(1.959999998, 60, 2)Result =TDIST(1.959999998, 60, 1)Result Related compatibility functions
- QUARTILEReturns a quartile of the values (older name of QUARTILE.INC).
- RANKReturns the rank of a number in a list (older name of RANK.EQ).
- STDEVEstimates the standard deviation from a sample (older name of STDEV.S).
- STDEVPReturns the population standard deviation (older name of STDEV.P).
- TINVReturns the two tailed inverse of the Student's t distribution (older name of T.INV.2T).
- TTESTReturns the probability of a Student's t test (older name of T.TEST).
- VAREstimates the variance from a sample (older name of VAR.S).
- VARPReturns the population variance (older name of VAR.P).
- WEIBULLReturns the Weibull distribution (older name of WEIBULL.DIST).