How to Use the WEIBULL Function in Excel
Today, we will delve into the application of the WEIBULL function in Microsoft Excel and Google Sheets. The WEIBULL function is designed to calculate the value of the Weibull distribution, a widely used distribution in reliability engineering and life data analysis, for a specific value of x, given the shape (α) and scale (β) parameters.
Syntax
The syntax for the WEIBULL function is consistently the same in both Excel and Google Sheets:
=WEIBULL(x, α, β, [cumulative])x: The value at which the Weibull distribution is evaluated.α: The shape parameter of the distribution.β: The scale parameter of the distribution (β must be greater than 0).cumulative(optional): This logical value specifies whether to calculate the cumulative distribution function or the probability density function.TRUE(or 1) for the cumulative distribution function.FALSE(or 0) for the probability density function.
Examples
Here are some examples to illustrate how the WEIBULL function can be utilized:
Example 1 – Probability Density Function
Calculate the probability density function of the Weibull distribution for x=2, α=1.5, and β=2.
| Value of x | α | β | Probability Density Function |
|---|---|---|---|
| 2 | 1.5 | 2 | =WEIBULL(2, 1.5, 2, FALSE) |
This calculation provides the probability density at x=2.
Example 2 – Cumulative Distribution Function
Calculate the cumulative distribution function of the Weibull distribution for x=3, α=2, and β=1.8.
| Value of x | α | β | Cumulative Distribution Function |
|---|---|---|---|
| 3 | 2 | 1.8 | =WEIBULL(3, 2, 1.8, TRUE) |
This result shows the cumulative probability up to x=3.
These examples demonstrate the versatility of the WEIBULL function in computing both the probability density function and the cumulative distribution function based on your data analysis needs.
More information: https://support.microsoft.com/en-us/office/weibull-function-b83dc2c6-260b-4754-bef2-633196f6fdcc