ReferenceFunctionsStatistics Functions
T.TEST
T.TEST: Returns the p-value from a Student t-test comparing two numeric samples.
Summary
T.TEST supports paired, equal-variance two-sample, and unequal-variance (Welch) modes.
Remarks
tailsmust be1(one-tailed) or2(two-tailed).typemust be1(paired),2(two-sample equal variance), or3(Welch).- Returns
#N/Awhen paired mode arrays have different lengths. - Returns
#NUM!or#DIV/0!for invalid setup or degenerate variance conditions.
Examples
Two-tailed equal-variance test with identical samples
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
1
One-tailed Welch test with identical samples
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.5
Related functions
Runtime metadata
Category
Statistics
Signature
T.TEST(arg1: Number (Range), arg2: Number (Range), arg3: Number, arg4: Number)Arity
min 4, max 4
Arguments
arg1Number · Range · coercion NumberLenientText
arg2Number · Range · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
arg4Number · Scalar · coercion NumberLenientText
Caps
PURE
Source