DAX Statistical - BETA.INV function
Description
Returns the inverse of the beta cumulative probability density function (BETA.DIST).
If BETA.DIST (x ...) = probability, then BETA.INV (probability ...) = x.
DAX BETA.INV function is new in Excel 2016.
Syntax
BETA.INV (probability, alpha, beta, [A, [B]])
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
probability A probability associated with the beta distribution. |
| 2 |
alpha A parameter of the distribution. |
| 3 |
beta A parameter of the distribution. |
| 4 |
A Optional. A lower bound to the interval of x. |
| 5 |
B Optional. An upper bound to the interval of x. |
Return Value
Returns the inverse of the beta cumulative probability density function (BETA.DIST).
A real number, x, where A <= x <= B.
Remarks
If any argument is nonnumeric, BETA.INV returns the #VALUE! error value.
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.
Example
= BETA.INV (0.59,9,10,0,1) returns 0.5.
