TTEST function
Summary
Returns the probability associated with a Student's t-test
Syntax
TTEST(array1,array2,tails,type)
The TTEST function syntax has the following arguments:
• 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)
• 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)
Example
=T.TEST(A2:A10,B2:B10,2,1)