Documentation/Calc Functions/T.INV.2T
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
T.INV.2T
Category:
Statistical Analysis
Summary:
Calculates the inverse of a two-tailed probability value for the t-distribution. The t-distribution is often known as the Student's t-distribution.
T-distributions are a family of continuous probability distributions and each has a curve with the same general bell shape that is symmetric about 0. Each t-distribution is characterized by a parameter known as the number of degrees of freedom, often denoted by the lowercase Greek letter nu ([math]\displaystyle{ \nu }[/math]). The t-distribution approaches the normal distribution as the number of degrees of freedom increases. T-distributions are often used to model small sample sizes.
Using the nomenclature of the previous paragraph, T.INV.2T calculates the real number x such that [math]\displaystyle{ \text{T.DIST.2T}(x;\:\nu)~=~\text{TDIST}(x;\:\nu; 2)~=~p }[/math], where the given probability p lies in the range (0, 1].
Syntax:
T.INV.2T(Number; Degrees freedom)
Returns:
Returns a positive real number, which is the value of the random variable that would give the specified two-tailed probability for the given t-distribution.
Arguments:
Number is a real number in the range (0, 1], or a reference to a cell containing that number, which is a two-tailed probability of the t-distribution.
Degrees freedom is a positive integer, or a reference to a cell containing that number, which is the number of degrees of freedom of the t-distribution. This is typically assumed to be the number of samples minus 1.
- If either of Number or Degrees freedom is non-numeric, then T.INV.2T reports a #VALUE! error.
- If Number is less than or equal to 0, or greater than 1, then T.INV.2T reports an invalid argument error (Err:502).
- If Degrees freedom is less than 1, then T.INV.2T reports an invalid argument error (Err:502).
- If Degrees freedom is a non-integer value, then T.INV.2T truncates it to an integer value.
Additional details:
- Calc's T.INV.2T and TINV functions perform identical calculations. The requirements for TINV are specified in ODF 1.2; T.INV.2T is provided for interoperability with Microsoft Excel.
- The name space for T.INV.2T is
COM.MICROSOFT.T.INV.2T
. - For more information on the t-distribution, visit Wikipedia's Student's t-distribution page.
Examples:
Formula | Description | Returns |
---|---|---|
=T.INV.2T(A1; A2) where cells A1 and A2 contain the values 0.666666666666667 and 2 respectively. | Here the function calculates the inverse of the given two-tailed probability value for the specified t-distribution. Note that the formulas =T.DIST.2T(0.5; 2) and =TDIST(0.5; 2; 2) both return 0.666666666666667. |
0.5 |
=T.INV.2T(0.001; 8) | Here the function calculates the inverse of a small two-tailed probability value for the specified t-distribution. | 5.04130543337337 |
=T.INV.2T(1; 8) | Here the function calculates the inverse of the largest possible two-tailed probability value for the specified t-distribution. | 0 |
Related LibreOffice functions:
ODF standard:
None
Related (or similar) Excel functions:
T.INV.2T