BETA.DIST Function in Excel

BETA.DIST Function in Excel calculates the cumulative beta probability distribution function or probability density function of beta distribution for a supplied set of parameters.

Syntax of BETA.DIST Function in Excel:

BETA.DIST(x, alpha, beta, cumulative, [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).
  • cumulative – logical argument if TRUE then Cumulative Beta Distribution Function is calculated, If False then Beta Probability Density Function is calculated
  • [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 BETA.DIST Function in Excel which calculates Cumulative Beta Distribution

Formula

BETA.DIST Function in Excel 1

  • Beta Distribution function – BETA.DIST, is supplied values from 0 to 1 on interval of 0.1 along with alpha value as 6, beta value as 8 and cumulative value as TRUE.

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

Result

BETA.DIST Function in Excel 2

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

BETA.DIST Function in Excel 5

 

Example of BETA.DIST Function in Excel which calculates probability Density function of beta Distribution

Formula

BETA.DIST Function in Excel 3

  • Beta Distribution function – BETA.DIST, is supplied values from 0 to 1 on interval of 0.1 along with alpha value as 6, beta value as 8 and cumulative value as FALSE.

So the result will be probability density function of beta distribution.

Result

BETA.DIST Function in Excel 4

Probability density function of x ranging from 0 to 1 with alpha =6 and beta=8 is plotted below

BETA.DIST Function in Excel 6

previous BETA.DIST Function in Excel                                                                                                                next BETA.DIST Function in Excel