ReferenceFunctionsStatistics Functions

T.INV

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

Summary

T.INV is the inverse of T.DIST(x, deg_freedom, TRUE).

Remarks

probability must be strictly between 0 and 1.
deg_freedom must be at least 1.
Returns #NUM! for out-of-range probability or invalid degrees of freedom.
Invalid numeric coercions propagate as spreadsheet errors.

Examples

Median t quantile

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

0

Upper-tail critical value

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

2.228138851986273

Runtime metadata

Category

Statistics

Signature

T.INV(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.2T

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

T.INV.2T

T.INV.2T: Returns the positive t critical value for a two-tailed probability.

On this page

Summary Remarks Examples Related functions Runtime metadata