Formualizer Docs
ReferenceFunctionsStatistics Functions

T.INV.2T

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

Summary

T.INV.2T solves for t such that P(|T| > t) = probability.

Remarks

  • probability must satisfy 0 < probability <= 1.
  • deg_freedom must be at least 1.
  • Returns #NUM! for invalid probability or degree-of-freedom arguments.
  • Alias TINV is supported.

Examples

Maximum two-tailed probability
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0
95% two-sided critical value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2.228138851986273

Runtime metadata

Category

Statistics

Signature

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

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

T.TEST

T.TEST: Returns the p-value from a Student t-test comparing two numeric samples.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata