T.TEST Function

Basic Description

The Excel T.TEST function calculates 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. The T.TEST function is new to Excel 2010. However, this is simply a renamed version of the TTEST function, that is available in earlier versions of Excel.

Syntax: T.TEST( array1, array2, tails, type )

where the function arguments are:

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


T.Test Function Examples

T.Test Function Example Data

Columns A and B of the spreadsheet on the right contain two arrays of data.

The probability associated with the Student’s paired t-test with a one-tailed distribution, for the two arrays of data can be calculated using the Excel T.Test function as follows :

=T.TEST( A1:A12, B1:B12, 1, 1 )

This gives the result 0.449070689.

The probability associated with the Student’s paired t-test with a two-tailed distribution, for the same two arrays of data, is calculated as follows :=T.TEST( A1:A12, B1:B12, 2, 1 )

This gives the result 0.898141379.

Note that the probability associated with the two-tailed T-Test is double that of the one-tailed T-Test.


T.Test Function Errors

If you get an error from the Excel T.Test Function, this is likely to be one of the following :

#N/A Occurs if the two supplied arrays have different lengths
#NUM! Occurs if either the supplied tails argument has any value other than 1 or 2 or the supplied type argument is not equal to 1, 2 or 3
#VALUE! Occurs if either the tails argument or the type argument is non-numeric

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment