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