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

`=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.

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.

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.

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.

- The new T.TEST function may provide improved accuracy.

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.