T.TEST function
Summary
Returns the probability associated with a Student's t-test
Syntax
T.TEST(array1,array2,tails,type)
The T.TEST 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, T.TEST uses the one-tailed distribution. If tails = 2, T.TEST uses the two-tailed distribution.
• Type Required. The kind of t-Test to perform.
• Array1 Required. The first data set.
• Array2 Required. The second data set.
• Tails Required. Specifies the number of distribution tails. If tails = 1, T.TEST uses the one-tailed distribution. If tails = 2, T.TEST uses the two-tailed distribution.
• Type Required. The kind of t-Test to perform.
Example
=T.TEST(A2:A10,B2:B10,2,1)