DAX Statistical - BETA.INV function


Advertisements

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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements