Histogram Template - Weibull Analysis in Excel

Use Weibull Analysis to Analyze Failure Rates

Weibull Analysis is especially suited to failure rates (e.g., how long does a TV, PC, ball bearing, etc. operate before failing).

How to Conduct Weibull Analysis Using QI Macros Template

  1. Just select your failure data and sort it.
  2. Open QI Macros Weibull Analysis template by clicking on QI Macros Menu, then Capability Templates, then Histogram with Cp and Cpk. Once the Histogram template is open, click on the Histogram Weibull worksheet.
  3. histogram template options

    Weibull Histogram Template for Excel with QI Macros

  4. Paste your sorted data into column B of the Weibull worksheet - it will create a histogram, and calculate the Weibull and process capability metrics for you.
  5. Next, click on "Solve for Slope" to get best fit using Maximum Likelihood Estimation (MLE). You can also solve for Location if the probability plot tails downward.

In this example of Ball Bearing failure rates, rates peak at 81.86.


How to Conduct Weibull Analysis with Censored Data

Some failure tests either 1.) end before all parts have failed (singly-censored) or 2.) continue with parts being removed from the test before they fail (multiply-censored).

  1. Just select your failure data and sort it. Also sort the censored data.
  2. Open QI Macros Weibull Analysis template by clicking on QI Macros Menu, then Capability Templates, then Histogram with Cp and Cpk. Once the Histogram template is open, click on the Weibull Single-Censored or Multiply-Censored worksheet.
  3. Paste your sorted data into column B of the worksheet - it will create a histogram,m and calculate Weibull and process capability metrics for you.
  4. Singly-Censoring means that there were failures before or after the test was started. In this case, there were eight more test items still working after the test was stopped at 152.70. To calculate correctly, simply input the sample size (20) in Cell N13.
    Weibull Single-Censored Excel Template
  5. Multiply Censored data contains both failures and parts that were removed from the test without failing.
    - Sort the failures and enter those first with an "F" for failure in column C.
    - Sort the censored data and enter them after the failures with a blank cell in Column C.
    - Click on "Solve for Slope" to get best fit using Maximum Likelihood Estimation (MLE).
    - You can also solve for Location if needed.
    Weibull Multiply Censored Excel Template

Why Choose QI Macros to Perform Capability Analysis and Draw Histograms?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Calculates Cp Cpk Pp Ppk
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free