ExcelFlux

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

RowAB
6Reading AReading B
712
845
997
Record 1
=TTEST(A7:A9,B7:B9,2,1)

Illustrative output1

See the inputs and instructions for all 3 examples

Syntax

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
Microsoft Excel reference