T.TEST Function in Excel: Syntax, Examples and Free Practice
T.TEST is an Excel Statistical function. Returns the probability from a Student's t-test.
T.TEST syntax
Arguments
array1: The first range or arrayarray2: The second range or arraytails: Whether to use a one-tailed or two-tailed testtype: Whether payments are due at the start or end of a period
When to use T.TEST
T.TEST is used in data analysis work to summarize or test patterns across a data set.
Practice T.TEST online, free
Open the live Excel-style spreadsheet and try T.TEST yourself. No Excel install or sign-up needed to start.
Practice T.TEST now →More Statistical functions
Frequently asked questions
What does the T.TEST function do in Excel?
Returns the probability from a Student's t-test.
What is the syntax of T.TEST in Excel?
The syntax is =T.TEST(array1, array2, tails, type). array1: The first range or array; array2: The second range or array; tails: Whether to use a one-tailed or two-tailed test; type: Whether payments are due at the start or end of a period.
Where can I practice T.TEST online for free?
Open the free live spreadsheet on Cellgrids and try T.TEST yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts