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. 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.
4. 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 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 example, 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.
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.

Note: Right-Censored Data is also known as Suspended data. This refers to failures that are observed only if they happen before a specific time and that some units have failed, while some units remain operational. Left-Censored Data is also known Interval data. This refers to observed unit(s) that have failed, but you’re not exactly sure WHEN they failed.

Affordable

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

Easy to Use

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

Proven and Trusted

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