Home › Functions › Statistical › T.TEST
fx
T.TEST
Statistical  ·  Since: Excel 2003  ·  9 languages

Returns the probability associated with a Student's t-Test. Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.

🌐 Translations

English T.TEST
Deutsch T.TEST
Français T.TEST
Español PRUEBA.T.N
Italiano TESTT
Português TESTE.T
Nederlands T.TEST
Polski T.TEST
Русский СТЬЮДЕНТ.ТЕСТ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

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

Arguments

array1 (required) — The first data set.
array2 (required) — The second data set.
tails (required) — Specifies the number of distribution tails. If tails = 1, T.TEST uses the one-tailed distribution. If tails = 2, T.TEST uses the two-tailed distribution.
type (required) — The kind of t-Test to perform.

▶ Examples

=T.TEST(A2:A10,B2:B10,2,1)

Related functions

Copied to clipboard