Returns the probability associated with a Student's t-Test. Use TTEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.

T.TEST takes 4 required arguments and no optional arguments:

Syntax: T.TEST(array1, array2, tails, type)

#1)
The arguments for the T.TEST function are:
Argument Required? Description
array1 Required First data set.
array2 Required 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.
comments powered by Disqus