<< Click to Display Table of Contents >> T.TEST (t-test)

Syntax:

T.TEST(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")

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.

See also:

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