WEIBULL.DIST function

The WEIBULL.DIST function in Excel is used to calculate the Weibull distribution for a specified set of parameters. The Weibull distribution is a continuous probability distribution commonly used in reliability analysis, modeling life data, and survival analysis. It is especially useful for analyzing failure times of systems or components.

Syntax

=WEIBULL.DIST(x, alpha, beta, cumulative)

Parameters

• x (required): The value at which to evaluate the function. This value must be greater than or equal to 0.
• alpha (required): The shape parameter of the Weibull distribution. It determines the shape of the distribution and is often denoted as $k$.
• beta (required): The scale parameter of the Weibull distribution. It stretches or compresses the distribution along the x-axis and is often denoted as $\lambda$.
• cumulative (required): A logical value that determines the form of the function:
  • TRUE: Returns the cumulative distribution function (CDF), which gives the probability that a random variable from the Weibull distribution is less than or equal to $x$.
  • FALSE: Returns the probability density function (PDF), which gives the likelihood of a random variable being exactly equal to $x$.

Key Points

• Weibull Distribution: The Weibull distribution is often used in reliability analysis, survival studies, and extreme value analysis. It has two main parameters:
  • Shape parameter ($\alpha$): Determines the shape of the distribution. If $\alpha = 1$, the distribution becomes an exponential distribution. For $\alpha < 1$, the distribution has a “heavy” tail, and for $\alpha > 1$, it has a “light” tail.
  • Scale parameter ($\beta$): Stretches or shrinks the distribution, controlling the scale along the x-axis.
• Probability Density Function (PDF): The PDF provides the likelihood of the random variable taking on a particular value $x$. It is useful when you want to determine the probability of a specific outcome.
• Cumulative Distribution Function (CDF): The CDF gives the probability that a random variable will take a value less than or equal to $x$. It is often used to calculate the probability of the random variable falling within a certain range.

Example Usage

1. Probability Density Function (PDF)

If you want to calculate the probability density of a Weibull distribution at $x = 3$ with $\alpha = 1.5$ and $\beta = 2$, and you want to return the PDF (not the cumulative probability), you can use:

=WEIBULL.DIST(3, 1.5, 2, FALSE)

This will give you the likelihood (density) of the random variable being exactly equal to 3.

2. Cumulative Distribution Function (CDF)

If you want to calculate the cumulative probability up to $x = 3$ with $\alpha = 1.5$ and $\beta = 2$, you can use:

=WEIBULL.DIST(3, 1.5, 2, TRUE)

This will return the probability that the random variable is less than or equal to 3 under the Weibull distribution.

Formula for Weibull Distribution

The probability density function (PDF) for the Weibull distribution is:

$$f(x; \alpha, \beta) = \frac{\alpha}{\beta} \left( \frac{x}{\beta} \right)^{\alpha – 1} \exp \left( -\left( \frac{x}{\beta} \right)^{\alpha} \right)$$

Where:

• $\alpha$ is the shape parameter.
• $\beta$ is the scale parameter.
• $x$ is the value at which the function is evaluated.

The cumulative distribution function (CDF) is the integral of the PDF and is given by:

$$F(x; \alpha, \beta) = 1 – \exp \left( -\left( \frac{x}{\beta} \right)^{\alpha} \right)$$

Notes

• Use Cases: The Weibull distribution is widely used in fields like engineering, finance, and survival analysis. It’s used for modeling:
  • The time until a failure event occurs (e.g., the lifespan of a product).
  • Reliability of mechanical systems.
  • Risk modeling and extreme values (e.g., the largest annual rainfall).
• Shape Parameter ($\alpha$) Impact:
  • If $\alpha = 1$, the Weibull distribution becomes the exponential distribution.
  • If $\alpha > 1$, the distribution becomes more peaked, with a tendency to have a lower failure rate as time progresses.
  • If $\alpha < 1$, the distribution becomes heavier-tailed, indicating a higher failure rate initially.
• Scale Parameter ($\beta$) Impact: The scale parameter stretches or compresses the distribution along the x-axis. A larger $\beta$ results in a wider distribution, while a smaller $\beta$ results in a narrower distribution.

Related Functions

• WEIBULL: In older versions of Excel, WEIBULL was used for calculating the Weibull distribution. WEIBULL.DIST is the updated version.
• EXPON.DIST: Used to calculate the exponential distribution (a special case of the Weibull distribution with $\alpha = 1$).
• NORM.DIST: Used for the normal distribution (Gaussian distribution).
• LOGNORM.DIST: Used for the lognormal distribution, often used in modeling skewed data.

The WEIBULL.DIST function is important for modeling the behavior of systems over time, especially in reliability analysis and survival studies, where understanding the time to failure or the probability of failure at a given point is essential.