Syntax
=TTEST(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 TTEST
TTEST is kept so older workbooks keep working. It calculates the same way as T.TEST, which is the name to use in new formulas.
TTEST takes 4 required arguments. Type =TTEST( 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.
=TTEST({3,4,5,8,9,1,2,4,5}, {6,19,3,2,14,4,5,17,1}, 2, 1)Result Related compatibility functions
- 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).
- TDISTReturns the one or two tailed Student's t distribution (older form of T.DIST.RT and T.DIST.2T).
- TINVReturns the two tailed inverse of the Student's t distribution (older name of T.INV.2T).
- 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).
- ZTESTReturns the one tailed probability of a z test (older name of Z.TEST).