TTEST Function Explained
The TTEST Function in Microsoft Excel is used to calculate the probability associated with the Student’s t-Test. It is used to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. It takes two arguments: array1 and array2, which are the two samples to be compared. The function returns the probability that the two samples are from the same population.
TTEST Function Syntax
TTEST(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.