BETA.DIST Function Explained
The BETA.DIST Function in Microsoft Excel calculates the cumulative beta probability density function or the probability density function for a given set of parameters. It takes four arguments: x (the value at which to evaluate the function), alpha (the parameter associated with the distribution), beta (the parameter associated with the distribution), and cumulative (a logical value that determines the form of the function). It returns the probability that a random variable, following a beta distribution, is less than or equal to x.
BETA.DIST Function Syntax
BETA.DIST(x, alpha, beta, cumulative, A, B)
- x: The value at which you want to evaluate the distribution.
- alpha: The parameter of the distribution.
- beta: The parameter of the distribution.
- cumulative: A logical value that determines the form of the function. If cumulative is TRUE, BETA.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
- A: The lower bound of the interval for which you want a probability.
- B: The upper bound of the interval for which you want a probability.