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 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
Cumulative Beta Distribution of x ranging from 0 to 1 with alpha =6 and beta=8 is plotted below
Example of BETA.DIST Function in Excel which calculates probability Density function of beta Distribution
Formula
- 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
Probability density function of x ranging from 0 to 1 with alpha =6 and beta=8 is plotted below