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
| Argument | Type | Required | Default |
|---|---|---|---|
probability | number | Required | — |
deg_freedom | number | Required | — |
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_freedomis truncated to an integer.
Error cases
- Returns
#NUM!whenprobability <= 0,probability > 1, ordeg_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?.