Excel - WEIBULL Function

---

---

WEIBULL Function

The WEIBULL function retrieves the Weibull distribution in less time. You can employ the WEIBULL function in scenarios such as reliability analysis, assessment of the products reliability over time, generalizing the failure distribution among products in a certain period, predicting the lifetime of specific products, etc.

The WEIBULL function replaces the WEIBULL.DIST function in Excel 2010.

Compatibility

This advanced Excel function is compatible with the following versions of MS-Excel −

• Excel for Microsoft 365
• Excel for Microsoft 365 for Mac
• Excel for the web
• Excel 2021
• Excel 2021 for Mac
• Excel 2019
• Excel 2019 for Mac
• Excel 2016

Syntax

The syntax of WEIBULL function is as follows −

WEIBULL(x,alpha,beta,cumulative)

Arguments

You can use the following arguments with the WEIBULL function −

Points to Remember

• The WEIBULL function retrieves the exponential distribution if the Alpha parameter equals 1.
• If any parameters are non-numeric except the Cumulative parameter, the WEIBULL function will retrieve the error #VALUE!
• If the x value is less than 0, this function retrieves the #NUM! Error.
• Either Beta or Alpha is less than equal to 0, then this function returns the #NUM! Error value.

Examples of WEIBULL Function

Practice the following examples to learn the use of the WEIBULL function in Excel.

Example 1

To calculate the Weibull Distribution Value

Solution

Firstly, consider the sample worksheets where the x, Alpha, Beta, and Cumulative parametric values are written in the C column. Then enter the formula =WEIBULL(C2,C3,C4,C5) in the C6 cell and press Enter to get the Weibull distribution resultant value. Here, the cell reference C2 refers to the failure time of the coffee machine is 1345.

Therefore, the resultant value is 1.

Example 2

The WEIBULL function retrieves the exponential distribution if the Alpha parameter equals 1.

Solution

In this example, you may alter the alpha value and set its value to 1. Write the formula =WEIBULL(C3,C4,C5,C6) in the C7 cell and press the Enter tab.

Example 3

If any parameters are non-numeric except the Cumulative parameter, the WEIBULL function will retrieve the error #VALUE!

Solution

You can alter the value of the Beta parameter and write the Harry text. After that, enter the expression =WEIBULL(C3,C4,C5,C6) in the C7 cell and press the Enter tab.

Therefore, the resulting value of the Weibull distribution is #VALUE! error.

Make sure that the x, Alpha, and Beta parameters are numeric while executing the Weibull function.

Example 4

If the x value is less than 0, this function retrieves the #NUM! Error.

Solution

As you can see in the screenshot, the x parameter contains the negative value. When you enter the expression =WEIBULL(C3,C4,C5,C6) in the C7 cell.

Example 5

Either Beta or Alpha is less than equal to 0, then this function returns the #NUM! error value. The same error will occur if both parameters, Alpha and Beta, contain a negative value.

Solution

Enter the formula =WEIBULL(C3,C4,C5,C6) in the C7 cell and press the Enter tab.

You may observe in the screenshot that the Alpha parameter comprises a negative value.

As you can notice in the screenshot, the WEIBULL function retrieves the #NUM value.