Functions
T.TEST
Student's t-test
Try it
When to use it
When should I use T.TEST?
Use T.TEST when you want to compare the means of two datasets and get a p-value indicating whether the difference is statistically significant — you specify the number of tails (1 or 2) and the test type (paired, equal-variance, or unequal-variance).
Used in
Syntax
T.TEST(array1,array2,tails,type)Examples
=T.TEST({90,85,78,92},{88,82,80,95},2,1) // => 1
=T.TEST({90,85,78,92},{88,82,80,95},1,2) // => 0.5
=T.TEST({90,85,78,92},{88,82,80,95},2,3) // => 1