Table of contents
TOC
Collapse the table of content
Expand the table of content

BETA.INV Function (DAX)

Owen Duncan|Last Updated: 5/22/2018

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

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.

Return Value

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.

© 2018 Microsoft