# 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.
dax_functions_statistical.htm