T.TEST Function Explained
The T.TEST Function in Microsoft Excel is used to calculate the probability associated with a Student’s t-Test. It can be used to determine if two samples have different means. It takes two arguments: array1 and array2, which are the two samples to be compared. It returns the probability that the two samples have the same mean.
T.TEST Function Syntax
T.TEST(array1, array2, tails, type)
- array1: The first array or range of data.
- array2: The second array or range of data.
- tails: The number of distribution tails. This argument can be either 1 or 2.
- type: The type of t-test. This argument can be either 1, 2, or 3.