TTEST function
the probability associated with a Student's t-test.
Compatibility · Guided Excel example
Where can you use it?
Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.
Scenario in the workbook
Recalculate a legacy paired t test. Keep corresponding readings in the same order.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Reading A | Reading B |
| 7 | 1 | 2 |
| 8 | 4 | 5 |
| 9 | 9 | 7 |
Record 1
=TTEST(A7:A9,B7:B9,2,1)Illustrative output1
See the inputs and instructions for all 3 examplesSyntax
TTEST(array1,array2,tails,type)
Compatibility function for older workbooks.
Worked examples
Recalculate a legacy paired t test. Keep corresponding readings in the same order.
Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.
| Row | A | B |
|---|---|---|
| 6 | Reading A | Reading B |
| 7 | 1 | 2 |
| 8 | 4 | 5 |
| 9 | 9 | 7 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =TTEST(A7:A9,B7:B9,2,1) |
1 |
| Record 2 | =TTEST(A7:A9,B7:B9+1,2,1) |
0.4226497308 |
| Record 3 | =TTEST(A7:A9,B7:B9-1,2,1) |
0.4226497308 |