<< 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:

This returns the result of a Student's t-test.

A t-test can be used to check the consistency 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