Formualizer Docs

TINV

Returns the two-tailed inverse of the Student's t distribution (legacy name).

TINV(probability, deg_freedom) is the t with P(|T| > t) = probability, the same as T.INV.2T.

The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.

Syntax

=TINV(probability, deg_freedom)

Arguments

ArgumentTypeRequiredDefault
probabilitynumberRequired—
deg_freedomnumberRequired—

How it works

Maps to T.INV.2T with the same argument order. It finds the nonnegative cutoff with the given probability outside the interval from −x to x. Degrees of freedom must be positive.

Remarks

  • deg_freedom is truncated to an integer.

Error cases

  • Returns #NUM! when probability <= 0, probability > 1, or deg_freedom < 1.

Examples

Use the legacy inverse to find the t cutoff for combined tail probability 0.25.

Formula =TINV(0.25,10)

Expected result 1.22125539500392

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Move the cutoff inward until the two-tail probability reaches 0.75.

Formula =TINV(0.75,10)

Expected result 0.327558264952591

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Find the two-sided cutoff at probability one half with one degree of freedom.

Formula =TINV(0.5,1)

Expected result 1

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

A probability above one cannot identify a t statistic.

Formula =TINV(1.1,10)

Expected result #NUM!

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Two-tailed critical value

Formula =TINV(0.05,10)

Expected result 2.22813885198627

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Implementation

Engine source

On this page