How To Do A T-Test In Google Sheets
When working with samples in Google Sheets, sometimes you’ll want to compare the means of samples to analyze the differences and similarities between these samples.
A T-Test is a good way to do this, and fortunately Google Sheets has a built-in T-Test function that makes it easy to perform T-Tests on samples stored in your spreadsheet.
Two Sample T-Tests
There are several types of T-Test that can be performed in Google Sheets using the T.TEST() function. However, for the purposes of this tutorial we’ll go through the process of doing a Two Sample T-Test in Google Sheets.
Two Sample T-Tests are used to test if two samples have the same mean.
This type of test has a lot of applications, but one example is that it could be used by biologists to compare the sizes of individuals in two samples of a species collected at different times or locations.
Follow these steps to perform a Two Sample T-Test in Google Sheets:
Before you perform a Two Sample T-Test, be sure you have two samples of data in Google Sheets that you want to compare
Click on the cell you want to perform the T-Test in and type the following formula “=T.TEST(A2:A, B2:B, 2, 2)”.
In this formula, the first two parameters are references to the ranges in which the two samples are stored.
The third parameter is the tail type: In this case we are using a 2-tailed distribution because we do not know how the samples might differ and want our test to measure all possible outcomes.
The last parameter is the type of T-Test performed.
In this case we are using option #2, a Two-Sample Equal Variance (Homoscedastic) T-Test. Typing a 1 or a 3 in this place would result in a Paired T-Test or Two-Sample Unequal Variance (Heteroscedastic) T-Test, respectively.
After typing the formula, hit enter and the T-Test result will calculate in the formula cell. Any updates to the data in the referenced ranges will automatically be reflected in this calculation
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to do a T test in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
Get more Google Sheets stuff
Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.