<< Click to Display Table of Contents >> TTEST (t-test)

Note: TTEST is supplemented by the new identical function T.TEST, which is available in newer versions of Microsoft Excel (2010 or later).

Syntax:

TTEST(Array1, Array2, Tails, Type)

Description:

Returns the result of a Student's t-test.

The t-Test is typically used to test the difference of the means of two samples.

Array1 and Array2 are the two arrays (samples) to be evaluated.

Tails is the number of distribution tails:

1: One-tailed distribution

2: Two-tailed distribution

Type is the type of t-test:

1: dependent samples ("paired")

2: independent samples, equal variances ("homoscedastic")

3: independent samples, different variances ("heteroscedastic")

See also:

T.TEST, T.INV.2T/T.INV/TINV, T.DIST.2T/T.DIST.RT/T.DIST/TDIST