Formulas > =TTEST()
How to Use TTEST() in Google Sheets
Description
How To Actually Use TTEST() in Sheets
TTEST(range1, range2, tails, type)
Try TTEST yourself
Use the data in ranges A1:A10 and B1:B10 to perform a T-Test. Your formula should return the T-Test result in cell C1.
Hints (2)
-
Remember to specify the number of tails and the type of test.
-
Check the syntax for the TTEST function carefully.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the TTEST() formula:
Generate a TTEST() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses TTEST(). 2 free AI generations, no signup. Members get unlimited use.
Generate a TTEST() formula