The Excel function: TTEST
Syntax
TTEST(array1,array2,tails,type)
The TTEST function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
- Array1 Required. The first data set.
- Array2 Required. The second data set.
- Tails Required. Specifies the number of distribution tails. If tails = 1, TTEST uses the one-tailed distribution. If tails = 2, TTEST uses the two-tailed distribution.
- Type Required. The kind of t-Test to perform.
| If type equals | This test is performed |
|---|---|
| 1 | Paired |
| 2 | Two-sample equal variance (homoscedastic) |
| 3 | Two-sample unequal variance (heteroscedastic) |