It’s also possible to get the p-value using this function.
It’s syntax is simple:
- ‘array1’ – the cell range of the first data set
- ‘array2’ – the cell range of the second data set
- ‘tails’ – represents the number of distribution tails; 1 = one-tailed and 2 = two-tailed
- ‘type’ – the t-test type to perform; 1 = paired; 2 = two-sample equal variance (homoscedastic); 3 = two-sample unequal variance (heteroscedastic)
Now, all you got to do is use the formula and provide it with the appropriate variables:
As you can see, using the ‘T.TEST’ function will give you exactly the same result as the t-Test tool.