T.TEST function
Returns the probability associated with a Student's t-test
Syntax
T.TEST(array1, array2, tails, type)Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| array1 | Yes | The first array or range of data.A1:A4 |
| array2 | Yes | The second array or range of data.B1:B4 |
| tails | Yes | 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.2 |
| type | Yes | The kind of t-Test to perform.1 |
Try T.TEST
Keep unequal sample sizes separate in a Welch comparison
=T.TEST(A2:A6,B2:B6,2,3)The groups have three and five numeric observations, including a genuine zero in group B. Both means equal two and both sample variances are positive. The two-sided Welch statistic is zero and p is one; unused trailing cells are not observations.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
T.TEST · top-level call
=T.TEST(A2:A6,B2:B6,2,3)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.