TTEST
Returns the probability associated with a Student's t-Test. Replaced by T.TEST.
Syntax
TTEST(array1, array2, tails, type)
Parameters
- array1: Required. The first data set
- array2: Required. The second data set
- tails: Required. The number of distribution tails (1 or 2)
- type: Required. The type of t-Test (1=paired, 2=two-sample equal variance, 3=two-sample unequal variance)
Example
=TTEST(A1:A10, B1:B10, 2, 2)