T.INV.2t Function (DAX)
How does the T.INV.2t function (DAX) work?
The T.INV.2t function (DAX) returns the two-tailed inverse of the Student’s t-distribution.
T.INV.2t Formula Syntax
T.INV.2T(
Probability,Deg_freedom
)
How do you use the T.INV.2t function?
This function will calculate the two-tailed Student’s T-Distribution. The Student’s T-Distribution is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.
Related Blog Posts
Related Support Forum Posts
Dax Calculation question
Dax not working
DAX Buffer Calculation Query
Considerations when using the T.INV.2t function
- If either argument is nonnumeric, T.INV.2T returns the #VALUE! error value.
- If probability <= 0 or if probability > 1, T.INV.2T returns the #NUM! error value.
- If deg_freedom is not an integer, it is truncated.
- If deg_freedom < 1, T.INV.2T returns the #NUM! error value.
- T.INV.2T returns that value t, such that P(|X| > t) = probability where X is a random variable that follows the t-distribution and P(|X| > t) = P(X < -t or X > t).
- A one-tailed t-value can be returned by replacing probability with 2*probability. For a probability of 0.05 and degrees of freedom of 10, the two-tailed value is calculated with T.INV.2T(0.05,10), which returns 2.28139. The one-tailed value for the same probability and degrees of freedom can be calculated with T.INV.2T(2*0.05,10), which returns 1.812462.Given a value for probability, T.INV.2T seeks that value x such that T.DIST.2T(x, deg_freedom, 2) = probability. Thus, precision of T.INV.2T depends on precision of T.DIST.2T.
Related Video Tutorials
Formula examples using the T.INV.2t function
EVALUATE { T.INV.2T(0.546449, 60) }
=T.INV.2T( 0.25, 10 )
=T.INV.2T( 0.5, 10 )