Syntax
=T.INV.2T(probability, deg_freedom)Arguments
| Argument | Required | Description |
|---|---|---|
probability | Required | The probability, between 0 and 1 |
deg_freedom | Required | Degrees of freedom (1 or more) |
How to use T.INV.2T
T.INV.2T takes 2 required arguments. Type =T.INV.2T( 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.INV.2T(0.546449, 60)Result Related statistical functions
- T.DISTReturns the left tailed Student's t distribution.
- 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.TESTReturns the probability from a Student's t test that two samples come from populations with the same mean.
- TRENDReturns values along the least squares straight line that fits the known data.
- TRIMMEANReturns the mean of the values after leaving out a percentage of the smallest and largest ones.
- VAR.PReturns the variance of a whole population.
- VAR.SEstimates the variance from a sample.