ExcelFlux

TINV function

the inverse of the Student's t-distribution.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find a t cutoff from a two-tailed probability, split equally between the tails.

A worked example from the workbook

RowA
6Input
70.1
80.5
90.9
Record 1
=TINV(A7,8)

Illustrative output1.859548038

See the inputs and instructions for all 3 examples

Compatibility function for older workbooks.

Worked examples

Find a t cutoff from a two-tailed probability, split equally between the tails.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 0.1
8 0.5
9 0.9
Trial Expression Sample output
Record 1 =TINV(A7,8) 1.859548038
Record 2 =TINV(A8,8) 0.7063866126
Record 3 =TINV(A9,8) 0.1297072716
Microsoft Excel reference