T.INV DAX Function (Statistical)
Returns the left-tailed inverse of the Student’s t-distribution.
Syntax
T.INV ( <Probability>, <Deg_freedom> )
| Parameter | Attributes | Description |
|---|---|---|
| Probability |
The probability associated with the Student’s t-distribution. |
|
| Deg_freedom |
The number of degrees of freedom with which to characterize the distribution. |
Return values
Scalar A single decimal value.
The left-tailed inverse of the Student’s t-distribution.
Remarks
The Probability argument must be between 0 and 1.
The Deg_freedom argument cannot be negative.
Examples
-- T.INV returns the left-tailed inverse of the Student's t-distribution
-- T.INV.2T returns the two-tailed inverse of the Student's t-distribution
--
-- https://en.wikipedia.org/wiki/Student%27s_t-distribution
DEFINE
VAR DegFreedom = 4.6
VAR Percs = GENERATESERIES ( 0.05, 0.99, 0.05 )
EVALUATE
SELECTCOLUMNS (
Percs,
"Probability %", [Value],
"T.INV",
FORMAT (
T.INV ( [Value], DegFreedom ),
"#,0.00000"
),
"T.INV.2T",
FORMAT (
T.INV.2T ( [Value], DegFreedom ),
"#,0.00000"
)
)
| Probability % | T.INV | T.INV.2T |
|---|---|---|
| 5.0000000000% | -2.01505 | 2.57058 |
| 10.0000000000% | -1.47588 | 2.01505 |
| 15.0000000000% | -1.15577 | 1.69936 |
| 20.0000000000% | -0.91954 | 1.47588 |
| 25.0000000000% | -0.72669 | 1.30095 |
| 30.0000000000% | -0.55943 | 1.15577 |
| 35.0000000000% | -0.40823 | 1.03055 |
| 40.0000000000% | -0.26718 | 0.91954 |
| 45.0000000000% | -0.13218 | 0.81909 |
| 50.0000000000% | 0.00000 | 0.72669 |
| 55.0000000000% | 0.13218 | 0.64057 |
| 60.0000000000% | 0.26718 | 0.55943 |
| 65.0000000000% | 0.40823 | 0.48225 |
| 70.0000000000% | 0.55943 | 0.40823 |
| 75.0000000000% | 0.72669 | 0.33672 |
| 80.0000000000% | 0.91954 | 0.26718 |
| 85.0000000000% | 1.15577 | 0.19914 |
| 90.0000000000% | 1.47588 | 0.13218 |
| 95.0000000000% | 2.01505 | 0.06591 |
Related functions
Other related functions are:
Last update: Mar 5, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/t-inv-dax
2018-2021 © SQLBI. All rights are reserved. Information coming from MSDN is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies