In Excel 2010, the Ttest function has been renamed as the T.Test function.
Although it has been replaced, the Ttest function is still available in Excel 2010 (stored within the list of compatibility functions), for compatibility with earlier versions of Excel.
However, the Ttest function may not be available in future versions of Excel, so it is advised that you use the T.Test function if possible.
The Excel Ttest 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 syntax of the function is:
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 must be either:
|
|||||||||
| type | - |
An integer that represents the type of t-test. This can be either:
|
| A | B | |
|---|---|---|
| 1 | 4 | 8 |
| 2 | 5 | 3 |
| 3 | 2 | 7 |
| 4 | 5 | 3 |
| 5 | 8 | 5 |
| 6 | 9 | 2 |
| 7 | 3 | 2 |
| 8 | 2 | 7 |
| 9 | 3 | 9 |
| 10 | 8 | 4 |
| 11 | 9 | 4 |
| 12 | 5 | 7 |
Columns A and B of the above 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 Ttest function as follows:
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 by the formula:
This gives the result 0.898141379, (which is double the probability associated with the one-tailed test).
For further information and examples of the Excel Ttest function, see the Microsoft Office website.
If you get an error from the Excel Ttest 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:
|
| #VALUE! | - | Occurs if either the supplied tails argument or the supplied type argument is non-numeric. |