BETA.DIST FunctionWayne Becker20151003T19:58:20+00:00
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 nonnumeric 
#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 
