DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to use the WEIBULL.DIST function in Excel Office 365?

#usetheweibulldistfun #excel #excelfunctions

The Weibull distribution is a two-parameter family of continuous probability distributions. This type of distribution is generally used for the distribution in reliability analysis or the analysis of time to failure. It takes the value and the two parameters named alpha and beta , along with the type of distribution required(cdf or pdf). In this article, we are going to see how to Use The WEIBULL.DIST Function In Excel Office 365. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

WEIBULL.DIST Function syntax 

=WEIBULL.DIST(x, alpha, beta, cumulative)
Enter fullscreen mode Exit fullscreen mode

Syntax Explanation:

  • x : value at which you want to evaluate the distribution.
  • alpha ** : **parameter for the Weibull distribution. If alpha = 1, WEIBULL.DIST acts as the exponential distribution function.
  • beta ** : **parameter for the Weibull distribution.
  • cumulative : logical value that determines the form of the function. If cumulative is TRUE , WEIBULL.DIST returns the cumulative distribution function ; if FALSE , it returns the probability density function.

Example

  • Firstly, you need to create the sample data with x value along with alpha and beta parameters for the Weibull distribution.

Create the sample data

  • Then, by using the parameters , you have to evaluate the cumulative distribution for the Weibull function with the formula given below. 
=WEIBULL.DIST(B2,B3,B4,FALSE)
Enter fullscreen mode Exit fullscreen mode

Use the formula

  • Now, you need to calculate the value for at least 105 we can use the probability mass distribution formula by changing the cumulative argument.
  • Here, you have to use the formula to find the probability for Weibull distribution given the same parameters. 
=WEIBULL.DIST(B2,B3,B4,TRUE)
Enter fullscreen mode Exit fullscreen mode

probability mass distribution formula

Bottom-Line

Here we have described the simple formulas to Use The WEIBULL.DIST Function In Excel Office 365. Let me know if you have any doubts regarding this article or any other Excel/VBA topic.

Thank you so much for visiting Geek Excel!! *If you want to learn more helpful formulas, check out Excel Formulas *!!

Read Ahead:

Top comments (0)