WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Weibull Distribution in Excel

Weibull Distribution in Excel

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Weibull Distribution in Excel (WEIBULL.DIST)

Excel Weibull distribution is widely used in statistics to obtain a model for several data sets, the original formula to calculate weibull distribution is very complex but we have an inbuilt function in excel known as Weibull.Dist function which calculates Weibull distribution.

Explanation

We have already learned that Weibull distribution is a continuous probability distribution. And Weibull distribution function in excel of two types:

  1. Weibull Cumulative Distribution Function
  2. Weibull Probability Density Function

The only difference between the two types of Weibull distribution function is the cumulative logical argument,

Weibull Cumulative Distribution Function takes True as a cumulative argument, whereas Weibull Probability Density Function takes False as a cumulative argument.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Weibull Distribution in Excel

How to use Weibull Distribution in Excel? (with Examples)

To use Weibull distribution, we need to have three values, which are X, Alpha, And Beta.

weibull distribution formula 1

  • X is a value to the function.
  • Alpha is a parameter to the function.
  • Beta is also a parameter to the function.
  • Cumulative is a logical argument that can be either true or false, depending upon the type of Weibull distribution function we are trying to use. If we are using Weibull Cumulative Distribution Function, then the cumulative value will be true, or we are using Weibull Probability Density Function, then the cumulative value will be false.
You can download this Weibull Distribution Excel Template here – Weibull Distribution Excel Template

Example #1

AS we know, X is valued at which we evaluate the function, Alpha & Beta. Both are the parameters to the function. Let us use this function in excel.

Weibull distribution Example 1

  • Step#1 – Give value to the WEIBULL.DIST function, for example, 100

Weibull distribution Example 1-1

  • Step#2 – Now, let us give the parameter to the function,n, i.e., Alpha and Beta.

Weibull distribution Example 1-2

  • Step#3 – In the Weibull Distribution Box, Type

Weibull distribution Example 1-3

  • Step#4 – Press the Tab button and click on the Fx function button.

Weibull distribution Example 1-4

  • Step#5 – A dialog box pops up.

Weibull distribution Example 1-5

  • Step#6 – In the Box for X, select the value against the value to the function.

Weibull distribution Example 1-6

  • Step#7 – For the parameter to the function, select the value for alpha and beta,

Weibull distribution Example 1-7

  • Step#8 – Cumulative is a logical value that can be either true or false, and both have a different meaning. Let us insert true first.

Weibull distribution Example 1-8

  • Step#9 – Click on, and we get the result for Weibull distribution.

Weibull distribution Example 1-9

The above value calculates Weibull Cumulative Distribution. To get this, the value of cumulative should be true.

Example #2

We have seen that Inserting True in the value of cumulative gives us Weibull Cumulative Distributive Value. If we insert False at the cumulative, it gives us Weibull Probability Density Value. Let us go with the first example.

We have seen that X is valued at which we evaluate the function. Alpha & Beta are both the parameter of the function. Let us again use this function in excel.

Example 2

  • Step#1 – We will again give a value to the function, i.e., 190 for this case.

Example 2-1

  • Step#2 – Now we give a parameter to the function which is alpha and beta,

Example 2-2

  • Step#3 – Now in the Weibull distribution box type,

Example 2-3

  • Step#4 – Press Tab and click on the Fx function bar,

Example 2-4

  • Step#5 – A dialog box appears for the function arguments,

Example 2-5

  • Step#6 – Now, we will give the value of the function and value of the parameters, i.e., Alpha and Beta.

Example 2-6

  • Step#7 – Previously, We inserted True as the value in cumulative now, we will insert False as a value in the cumulative logical value.

Example 2-7

  • Step#8 – Click on OK, and we will get our desired value.

Example 2-8

The value above calculated is Weibull Probability Density.

Things to Remember

  1. X, which is a value to the function, is a non-negative number and cannot be zero, so it should be greater than zero.
  2. Alpha And Beta, which are the parameter to the function the also need to be equals to or greater than zero.
  3. We get two types of errors in Excel Weibull Distribution.
  4. #NUM!: This error comes when the value of x is less than zero.
  5. #Value!: This error comes if any arguments given are non-numeric.

Recommended Articles

This has been a guide to Weibull distribution in Excel. Here we discuss how to use WEIBULL.DIST Function, along with practical examples and downloadable Excel templates. You may learn more about excel from the following articles –

  • Poisson Distribution Formula
  • Binomial Distribution Formula
  • Lognormal Distribution Excel
  • NORM.S.INV Function
  • Add a Secondary Axis in Excel
35 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Weibull Distribution Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More