BETADIST

Definition: BETADIST is a function that returns the cumulative beta probability density function.

Syntax: =BETADIST(x, alpha, beta, [lower], [upper])

Situation: This formula is suitable when you need to find the probability of a random variable falling between two values in a beta distribution.

Example: If you have a beta distribution with alpha=2 and beta=5, the probability of the random variable being between 0.2 and 0.6 can be found using the formula =BETADIST(0.6, 2, 5, TRUE, TRUE)-BETADIST(0.2, 2, 5, TRUE, TRUE), which returns a value of 0.132.