Related Function:

The T.TEST function returns the probability associated with the Student’s T Test, which is commonly used for identifying whether two data sets are likely to have come from the same two underlying populations with the same mean.

• This function was introduced in Excel 2010 and so is not available in earlier versions.
• The T.TEST function replaces the TTEST function included in earlier versions of Excel.

Syntax

=T.TEST(array1,array2,tails,type)

Arguments

Argument Description
array1 The first data set
array2 The second data set – must have the same length as array1
tails The number of tails for the distribution. This can be either:

 1 – Uses the one-tailed distribution 2 – Uses the two-tailed distribution
type An integer that represents the type of t-test. This can be either:

 1 – Paired T-Test 2 – Two-sample equal variance T-Test 3 – Two-sample unequal variance T-Test

Examples

A B C D
1 Data 1 Data 2
2 12 15
3 17 18
4 14 27
5 13 16
6 5 28
7
8 Formula Result Notes
9 =T.TEST(A2:A6,B2,B6,1,1) 0.053977 Probability associated with a Student’s paired t-Test, with a one-tailed distribution
10 =T.TEST(A2:A6,B2,B6,2,1) 0.107954 Probability associated with a Student’s paired t-Test, with a two-tailed distribution

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either the tails argument or the type argument is non-numeric
#NUM! Occurs if either:

 • the supplied tails argument has any value other than 1 or 2 • the supplied type argument is not equal to 1, 2 or 3
#N/A Occurs if the two supplied arrays have different lengths