BETA.DIST function

The BETA.DIST function in Excel calculates the cumulative beta distribution, which is commonly used in statistics for modeling variables that are bounded between two values (such as proportions or percentages).

Syntax

=BETA.DIST(x, alpha, beta, cumulative, [A], [B])

Arguments

• x: The value at which to evaluate the beta distribution. It must be between A and B (inclusive).
• alpha: A parameter of the distribution, often referred to as the shape parameter.
• beta: Another parameter of the distribution, also referred to as a shape parameter.
• cumulative: A logical value. If TRUE, the function returns the cumulative distribution function (CDF); if FALSE, it returns the probability density function (PDF).
• A (optional): The lower bound of the interval of x. If omitted, it defaults to 0.
• B (optional): The upper bound of the interval of x. If omitted, it defaults to 1.

Return Value

• BETA.DIST returns a value representing the cumulative distribution or the probability density for the beta distribution, depending on the value of the cumulative argument.

Description

• The beta distribution is useful in situations where you want to model the probability of a proportion or percentage, such as the success rate of an event that happens a certain number of times (e.g., in a success/failure experiment).
• The BETA.DIST function can either return:
  • The cumulative beta distribution (the probability that a random variable falls within a certain range).
  • The probability density (the likelihood of observing a particular outcome at a specific point).

Example Usage

Example 1: Cumulative Beta Distribution

To calculate the cumulative beta distribution of x = 0.6 with alpha = 2, beta = 5, on the interval [0, 1]:

=BETA.DIST(0.6, 2, 5, TRUE)

Result:

This would return the cumulative probability of observing a value of 0.6 or less in the beta distribution.

Example 2: Probability Density

To calculate the probability density of the same beta distribution:

=BETA.DIST(0.6, 2, 5, FALSE)

Result:

This returns the density (PDF) of the beta distribution at x = 0.6.

Example 3: Custom Bounds

If you want to calculate the cumulative beta distribution for x = 0.6, with alpha = 2, beta = 5, but in a custom interval of [1, 10], use:

=BETA.DIST(0.6, 2, 5, TRUE, 1, 10)

Result:

This returns the cumulative probability within the range [1, 10].

Notes

• x must be between A and B. If it is outside the range, the function returns an error.
• alpha and beta must both be greater than 0, or the function returns an error.
• If A and B are omitted, the beta distribution is assumed to be defined over the interval [0, 1].

Applications

• The beta distribution is used in project management (PERT charts), reliability analysis, and to model probabilities of percentages, rates, or proportions that lie between 0 and 1.
• It’s also useful for decision-making under uncertainty and in Bayesian statistics.

Error Handling

• If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the #NUM! error.
• If x, A, or B is invalid (i.e., not in the specified range), it returns the #NUM! error.
• If non-numeric arguments are provided, BETA.DIST returns the #VALUE! error.