Related Function:

The BETA.DIST function returns the cumulative beta distribution function or the beta probability density function, for a supplied set of parameters.

• This function was introduced in Excel 2010 and so is not available in earlier versions.
• BETA.DIST replaces the BETADIST function included in earlier versions of Excel.

### Syntax

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

#### Arguments

Argument Description
x The value between A and B at which to evaluate the function
alpha A parameter of the distribution – must be > 0
beta A parameter of the distribution – must be > 0
cumulative A logical value that determines the form of the function

 TRUE – Cumulative Beta Distribution Function FALSE – Beta Probability Density Function
[A] Optional. A lower bound to the interval of x. If omitted, [A] defaults to a value of 0
[B] Optional. An upper bound to the interval of x. If omitted, [B] defaults to a value of 1

#### Examples

A B C D
1 Data Description
2 2 Value at which to evaluate the function
3 7 Argument of the distribution
4 10 Argument of the distribution
5 1 Lower bound
6 3 Upper bound
7
8 Formula Result Notes
9 =BETA.DIST(A2,A3,A4,TRUE,A5,A6) 0.772751 Cumulative beta probability density function, for the above parameters
10 =BETA.DIST(A2,A3,A4,FALSE,A5,A6) 1.221924 Beta probability density function, for the above parameters

Usage note: The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.

#### Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric
#NUM! Occurs if either:

 • the supplied x value is < [A] or > [B] • the supplied [A] and [B] arguments are equal • the supplied alpha or the supplied beta argument is ≤ 0