Statistical Excel 2010 ◉ 3 views

=T.TEST()

Tests whether the means of two groups differ significantly

=T.TEST(array1, array2, tails, type)

Hover argument names in the table for details.

Output typeNumber

Popularity20 / 100

VolatileNo

Dynamic ArrayNo

📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas

⬇ Download Sample Workbook

A dedicated .xlsx for =T.TEST() with Persian sample data & live formulas — open in Excel and practice.

📥 Download T.TEST.xlsx — Coming soon ~ 8–12 KB · No macros

%d questions — syntax, example & errors — test yourself!

Start quiz →

Argument	Type	Required	Description
`array1`	Array	Required	Data of the first group
`array2`	Array	Required	Data of the second group
`tails`	Number	Required	One-tailed or two-tailed test

Example 1 =T.TEST(B2:B21, C2:C21, 2, 1)

Example 2 =T.TEST(B2:B31, D2:D46, 2, 3)

For type 1 the two ranges must be the same size.
The output is the p-value, not the t-statistic.
A two-tailed test only checks whether they are different, not whether one is larger or smaller.

#N/A For a paired test, the two ranges do not have the same number of data points