The `BETA.DIST` function in Excel is used to calculate the beta distribution probability density function or the cumulative beta distribution function. This can be particularly useful for statistical analysis of percentages or proportions.
Here’s how to use the `BETA.DIST` function:
Syntax:
BETA.DIST(x, alpha, beta, cumulative, [A], [B])
Parameters:
- x: The value between A and B at which you want to evaluate the function. This is a required parameter.
- alpha: A parameter of the distribution. Must be greater than 0. This is a required parameter.
- beta: A parameter of the distribution. Must be greater than 0. This is a required parameter.
- cumulative: A logical value that determines the form of the function. This is a required parameter:
- If `TRUE`, `BETA.DIST` returns the cumulative distribution function.
- If `FALSE`, `BETA.DIST` returns the probability density function.
- [A]: An optional lower bound of the x interval. If omitted, `A` is assumed to be 0.
- [B]: An optional upper bound of the x interval. If omitted, `B` is assumed to be 1.
Example Usage:
Example 1: Cumulative Distribution Function
If you want to find the cumulative beta distribution for `x = 0.5`, `alpha = 2`, and `beta = 5`, you would enter:
=BETA.DIST(0.5, 2, 5, TRUE)
Example 2: Probability Density Function
If you want to calculate the probability density of `x = 0.5` with parameters `alpha = 2`, and `beta = 5` over the interval [0, 1], you would enter:
=BETA.DIST(0.5, 2, 5, FALSE)
Example 3: Custom Interval
To calculate the cumulative beta distribution for `x = 1.5` with `alpha = 2`, `beta = 5`, and over the interval [1, 2]:
=BETA.DIST(1.5, 2, 5, TRUE, 1, 2)
Notes:
- Ensure that `alpha` and `beta` are both greater than 0 for valid results.
- If `x` is not between `A` and `B`, `BETA.DIST` will return an error.
- The function is available in Excel 2010 and later versions.
This function allows you to manage various scenarios involving random variables that are constrained within a specific minimal and maximal range, making it applicable in fields such as project management, risk analysis, and quality control.
Unlock Your Potential
Excel
Access
Power BI
