Functions
T.DIST.2T
Student's t two-tailed CDF
Try it
When to use it
When should I use T.DIST.2T?
Use T.DIST.2T when you need the two-tailed p-value for a Student's t-test — it returns the probability that a t-statistic is at least as extreme as x in absolute value, which is the standard output for symmetric hypothesis tests.
Used in
Syntax
T.DIST.2T(x,df)Examples
=T.DIST.2T(1.96,60) // => 0.05464492973652901
=T.DIST.2T(1,2) // => 0.4226497308103738