# Trying to Do Weibull Analysis in Excel?

## QI Macros can do it for you!

### Create a Weibull Histogram using QI Macros:

2. Click on QI Macros menu > Histogram & Capability > Weibull Histogram.
3. QI Macros will do the math and draw the chart for you.

### Go Deeper: Use Weibull Analysis with Failure Rate Data

Not all data is normally distributed (i.e., bell-shaped). Weibull analysis is especially suited to failure rates (e.g., how long does a TV, PC, ball bearing or whatever operate before failing). Weibull analysis works well, even with small samples (less than 20).

Just select your failure data and choose Histogram Weibull from QI Macros menu. The macro will prompt for spec limits, create a histogram and calculate Weibull and process capability metrics for you. Here's an example of Ball Bearing failure rates. Failure rates peak at 81.86:

### Weibull Distribution

The Weibull distribution can approximate many other distributions: normal, exponential and so on. The Weibull curve is called a "bathtub curve," because it descends in the beginning (infant mortality); flattens out in the middle and ascends toward the end of life.

Shape
The Shape parameter (slope = 2.10) describes the failure rate:
• Shape < 1 is a decreasing failure rate (infant mortality)
• Shape > 1 is an increasing failure rate (wear-out failures)
• Shape = 1 means random failure rate (independent of age)
- equivalent to the exponential distribution
- When Shape = 1, MTBF(Mean Time Between Failures) = Scale parameter
• Shape = 2 is equivalent to the Rayleigh distribution
• Shape between 1 and 3.6 approximates the log-normal distribution
• Shape = between 3 an 4 approximates the normal distribution (3.6 provides best estimation)
• Shape = 5 approximates the peaked normal distribution
Scale
The Scale parameter (characteristic life) is the age at which 63.2% of units will have failed.

### There are several methods for estimating the scale and shape parameters:

• Maximum likelihood estimation (MLE) - QI Macros uses this method (July 2013).
• Least squares (rank regression).
• Probability Plotting - QI Macros creates a Probability Plot on the data worksheet to assist in determining when a certain percent of parts will have failed. In the example below, 10% of the parts will have failed by time 27:

### Fast and Easy to Use

• Works Right in Excel
• Calculates Cp Cpk Pp Ppk
• Accurate No-Worry Results
• Free Training Anytime

### Proven and Trusted

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

### Affordable

• Only \$349 USD
Quantity Discounts Available
• No annual fees
• Free Technical Support