T.INV.2T Function

Returns the two-tailed inverse of the Student's t distribution — the critical t value.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice T.INV.2T in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

The t distribution is a bell curve with heavier tails, used instead of the normal distribution when the standard deviation is estimated from a small sample. The more degrees of freedom, the closer it gets to the normal curve.

T.INV.2T returns the positive t value that leaves the given probability split across both tails. With 0.05 it gives the multiplier for a 95% confidence interval.

Syntax

=T.INV.2T(probability, deg_freedom) Explain

Arguments

ArgumentRequired?What it does
probabilityYesThe total two-tailed probability, such as 0.05; between 0 and 1.
deg_freedomYesDegrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1.

Examples

Example 1 — Critical values for 95% confidence

Smaller samples need a bigger multiplier than the normal curve's 1.96. Column B is filled down from B2.

B2fx=T.INV.2T(0.05,A2-1)
AB
1Sample sizet multiplier
252.7764
3102.2622
4202.0930
5302.0452
61001.9842
=T.INV.2T(0.05,A2-1) Explain

With 5 values the multiplier is 2.78; by 100 it's close to 1.96.

Common mistakes

  • #NUM! probability is 0 or less or more than 1, or deg_freedom is less than 1.
  • Two tails already. Pass 0.05 for 95% confidence, not 0.025.

Notes

  • T.INV.2T replaces the older TINV function.
  • Related functions: T.INV, CONFIDENCE.T, T.DIST.2T.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.