Formualizer Docs
ReferenceFunctionsStatistics Functions

T.DIST.2T

T.DIST.2T: Returns the two-tailed Student's t probability beyond `x`.

Summary

T.DIST.2T computes P(|T| > x) for the specified degrees of freedom.

Remarks

  • Requires x >= 0 and deg_freedom >= 1.
  • Represents a two-sided tail area.
  • Returns #NUM! when arguments are outside valid ranges.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Two-tailed t probability at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Two-tailed t probability at x=2
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.0733880342639167

Runtime metadata

Category

Statistics

Signature

T.DIST.2T(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

T.DIST

T.DIST: Returns the Student's t probability for `x` and a given degrees-of-freedom value.

T.INV

T.INV: Returns the t-value whose left-tail probability equals `probability`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata