BETADIST Function in Excel – BETA Distribution in Excel

BETADIST Function in Excel calculates the cumulative beta probability density function for a supplied set of parameters.

Syntax of BETADIST Function in Excel:

BETADIST(x, alpha, beta, [A], [B])

 

  • X -The value at which the function is to be calculated (must be between [A] and [B]).
  • alpha -A parameter of the distribution (must be > 0).
  • beta -A parameter of the distribution (must be > 0).
  • [A] -An optional argument with default value 0, which gives the lower bound of the interval of x.
  • [B] -An optional argument with default value 1, which gives the upper bound of the interval of x.

 

Example of BETADIST Function in Excel

Formula

BETADIST Function in Excel 1

  • Beta Distribution function BETADIST is supplied values from 0 to 1 on interval of 0.1 along with alpha value as 6 and beta value as 8.

So the result will be cumulative beta probability density function ranging from 0 to 1 as shown below.

Result

BETADIST Function in Excel 2

Cumulative Beta Distribution of x ranging from 0 to 1 with alpha =6 and beta=8 is plotted below

BETADIST Function in Excel 3

previous BETADIST Function in Excel                                                                                                                next BETADIST Function in Excel