# DAX Statistical - BETA.DIST function

## Description

Returns the beta distribution.

The beta distribution is commonly used to study the variation in the percentage of something across samples.

DAX BETA.DIST function is new in Excel 2016.

## Syntax

```BETA.DIST (x, alpha, beta, cumulative, [A, [B]])
```

## Parameters

Sr.No. Parameter & Description
1

x

The value between A and B at which to evaluate the function.

2

alpha

A parameter of the distribution.

3

beta

A parameter of the distribution.

4

cumulative

Logical value that determines the function’s form −

TRUE: Returns the cumulative distribution function.

FALSE: Returns the probability density function.

5

A

Optional.

A lower bound to the interval of x.

6

B

Optional.

An upper bound to the interval of x.

## Return Value

Returns the beta distribution.

A real number, probability, where 0 < probability <= 1.

## Remarks

• If any parameter is nonnumeric, BETA.DIST returns the #VALUE! error value.

• If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the #NUM! error value.

• If x < A, or x > B, or A = B, BETA.DIST returns the #NUM! error value.

• If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1.

## Example

```= BETA.DIST(0.5,9,10, TRUE (),0,1) returns 0.592735290527344.
= BETA.DIST(0.5,9,10, FALSE (),0,1) returns 3.33847045898437.
```
dax_functions_statistical.htm 