TTEST

Formulas / TTEST
Calculate the probability associated with the Student's T Test.
=T.TEST(array1,array2,tails,type)
  • array1 - required first data set
  • array2 - required second data set
  • tails - required number of distribution tails
  • type - required t-Test type

Examples

  • =TTEST( A1:A12, B1:B12, 1, 1 )

    The TTEST function example returns the probability associated with the Student's paired t-test with a one-tailed distribution for the two arrays of data A1 and B1. This type of test is used to compare the means of two paired sets of data, to determine if the difference between them is statistically significant.

  • =TTEST( A1:A12, B1:B12, 2, 1 )

    The TTEST function example returns the probability associated with the Student's paired t-test with a two-tailed distribution for the two arrays of data A1 and B1. This type of test is used to determine if the difference between two paired sets of data is statistically significant.

  • =TTEST( A1:A12, B1:B12, C1:C12, 2, 1 )

    The TTEST function can also be used to compare the means of three or more paired sets of data, by adding additional arguments to the function. For example, this will return the probability associated with the Student's paired t-test with a two-tailed distribution for the three arrays of data A1, B1, and C1.


Summary

The TTEST function is used to determine whether two sets of data are likely to have come from the same population. It returns the probability of observing the difference between the means of the two data sets by chance.

  • The TTEST function is still available in Excel 2010, but not in future versions. It has been replaced by the T.Test function.

Frequently Asked Questions

What is the TTEST Function?
The TTEST function is used to calculate the probability of a Student's t-Test. A t-test is a statistical test used to determine whether two samples come from the same population.
What is the new T.TEST Function?
The new T.TEST function is a more accurate version of the TTEST function. It is not available yet, but may be available in future versions of Excel.
What are the differences between the TTEST and T.TEST Functions?
  • The new T.TEST function may provide improved accuracy.
How do I use the TTEST Function?
To use the TTEST function, you will need to enter the data for the two samples you want to compare into the function. You will also need to specify the type of t-test you want to perform. The function will then return the probability of the t-test.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV