Excel TTEST Function
The TTEST function returns the probability that is associated with a Student's t-test. TTEST is often used to test the probability of two samples that have underlying populations with the same mean.
Syntax
=TTEST(array1, array2, tails, type)
Arguments
- array1 (required): The first data set.
- array2 (required): The second data set.
- tails (required): The number of distribution tails to use. This must be either:
- 1, to use the one-tailed distribution;
- 2, to use the two-tailed distribution.
- type (required): A number indicates which type of t-test to perform:
- 1, to perform a paired t-test;
- 2, to perform a two-sample equal variance t-test;
- 3, to perform a two-sample unequal variance t-test
Return Value
The TTEST function returns a numeric value.
Function Notes
- If tails and type are not integers, they will be truncated.
- TTEST returns the #N/A error if array1 and array2 have a different number of data points, and you want to perform a paired t-test (type=1).
- TTEST returns the #VALUE! error if either of the supplied tails and type is non-numeric.
- TTEST returns the #NUM! error if:
- tails is any value other than 1 or 2;
- type is any value other than 1, 2 or 3.
Example
To calculate the probability associated with a Student's paired t-test, with one and two-tailed distribution, please copy or enter the formulas below in the corresponding result cells, and press Enter to get the results.
=TTEST(B6:B12,C6:C12,1,1)
=TTEST(B6:B12,C6:C12,2,1)
Related functions
The T.TEST function returns the probability that is associated with a Student's t-test. T.TEST is often used to test the probability of two samples that have underlying populations with the same mean.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
