Calculate T-Test (T.Test) in Google Sheets

In Google Sheets, there is a pre-defined function that can help you to perform the T-Test. This tutorial will look at a simple and quick example to understand this.

Steps to Calculate T-Test in Google Sheets

1. First, enter that T.TEST function in a cell.
2. In the first argument, specify the range with the first data set.
3. And in the second argument, specify the range with the second data set.
4. After that, specify the tailed distribution in the “tail” argument. It needs to be a numeric value.
   1. 1 for one-tailed distribution
   1. 2 for two-tailed distribution.
5. In the end, in the “type” argument, you need to enter a numeric value to specify the type of the T-Test.
   1. 1 for the paired test.
   1. 2 for the two-sample equal variance test (homoscedastic).
   1. 3 for the two-sample unequal variance (heteroscedastic).

And the moment you hit enter, it returns a result in the cell.

Tips

• tails and type arguments need to be in numeric values.
• range 1 and range 2 needs need to have the same data points.

⮞ Get the Sample Sheet