T.INV.2T function
Returns the inverse of the probability for the Student t-distribution (two-tailed)
Syntax
T.INV.2T(probability, degFreedom)Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| probability | Yes | The probability associated with the Student's t-distribution.0.75 |
| degFreedom | Yes | An integer indicating the number of degrees of freedom.2 |
Try T.INV.2T
Recognize truncated degrees of freedom in the inverse function
=T.INV.2T(A2,B2)This function truncates 2.9 degrees of freedom to two. For df=2, the two-sided tail is 1-t/SQRT(t^2+2); solving it at 0.05 independently gives this critical value. Do not substitute this truncated inverse for a fractional-df Welch tail calculation.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
T.INV.2T · top-level call
=T.INV.2T(A2,B2)1 / 2 · probability
The probability associated with the Student's t-distribution.
T.INV.2T reference ↗Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.