Formualizer Docs
ReferenceFunctionsStatistics Functions

T.DIST

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

Summary

Use T.DIST in either cumulative mode (left-tail probability) or density mode.

Remarks

  • Set cumulative to non-zero for CDF mode, or 0 for PDF mode.
  • deg_freedom must be at least 1.
  • Returns #NUM! when deg_freedom < 1.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

t CDF at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.5
t PDF at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.389108383966031

Runtime metadata

Category

Statistics

Signature

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

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

STEYX

STEYX: Returns the standard error of y-estimates from a simple linear regression.

T.DIST.2T

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

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata