BETA.INV DAX Function (Statistical)
Returns the inverse of the beta cumulative probability density function (BETA.DIST). If probability = BETA.DIST(x,…TRUE), then BETA.INV(probability,…) = x. The beta distribution can be used in project planning to model probable completion times given an expected completion time and variability.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Probability |
A probability associated with the beta distribution. |
|
| Alpha |
A parameter of the distribution. |
|
| Beta |
A parameter the distribution. |
|
| A | Optional |
A lower bound to the interval of x. |
| B | Optional |
An upper bound to the interval of x. |
Return values
Returns the inverse of the beta cumulative probability density function (BETA.DIST).
Remarks
If any argument is nonnumeric, BETA.INV returns the #VALUE! error value.
If any argument is not an integer, it is rounded.
If alpha ≤ 0 or beta ≤ 0, BETA.INV returns the #NUM! error value.
If probability ≤ 0 or probability > 1, BETA.INV returns the #NUM! error value.
If you omit values for A and B, BETA.INV uses the standard cumulative beta distribution, so that A = 0 and B = 1.
Related functions
Other related functions are:
Last update: Oct 13, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/beta-inv-function-dax