BETA.INV Function (DAX)

 

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.

BETA.INV(probability,alpha,beta,[A],[B])  

Parameters

TermDefinition
ProbabilityA probability associated with the beta distribution.
AlphaA parameter of the distribution.
BetaA parameter the distribution.
AOptional. A lower bound to the interval of x.
BOptional. An upper bound to the interval of x.

Returns the inverse of the beta cumulative probability density function (BETA.DIST).

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.

Community Additions

ADD
Show: