BETADIST Function Explained
The BETADIST function in Microsoft Excel calculates the cumulative beta probability density function or the probability density function for a given set of parameters. It takes three arguments: x (the value at which to evaluate the function), alpha (the parameter associated with the beta distribution), and beta (the second parameter associated with the beta distribution). The function returns the probability that a random variable, which follows a beta distribution, is less than or equal to x.
BETADIST Function Syntax
BETADIST(x,alpha,beta,A,B)
- x: The value at which you want to evaluate the distribution.
- alpha: The alpha parameter of the beta distribution.
- beta: The beta parameter of the beta distribution.
- A: The lower bound of the beta distribution.
- B: The upper bound of the beta distribution.