T.TEST
Returns the probability associated with a Student's t-test
Syntax
T.TEST(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
=T.TEST(A1:A10, B1:B10, 2, 2)