Syntax
=T.TEST(array1, array2, tails, type)Arguments
| Argument | Required | Description |
|---|---|---|
array1 | Required | The first sample |
array2 | Required | The second sample |
tails | Required | 1 for a one tailed test, 2 for two tailed |
type | Required | 1 paired, 2 equal variance, 3 unequal variance |
How to use T.TEST
T.TEST takes 4 required arguments. Type =T.TEST( 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.TEST({3,4,5,8,9,1,2,4,5}, {6,19,3,2,14,4,5,17,1}, 2, 1)Result Related statistical functions
- 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.
- 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.
- VARAEstimates the variance from a sample, counting text as 0 and TRUE as 1.