T.TEST
Category: Statistical Function.
Description: Returns the probability associated with a Student's t-Test.
Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.
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.
Parameters
If type equals 1, the Paired test is performed.
If type equals 2, the Two-sample equal variance (homoscedastic) test is performed.
If type equals 3, the Two-sample unequal variance (heteroscedastic) test is performed.