William Dorner’s default image

By William Dorner

Click here to download the Excel worksheet used in this article.

Many people use Microsoft Excel on a daily basis. Yet few people realize the extent of Excel's analytical capabilities. Fewer still put these capabilities to work for process improvement, product improvement and profit.Most Excel users are aware of the common formulas and charts. But with some creativity, users can produce tools like control charts, Pareto charts and box-and-whisker plots (see "Using Excel for Data Analysis," Quality Digest, October 1997). And with a little guidance, users can employ more advanced statistical methods with Excel. This article presents a how-to approach for one such advanced technique-Weibull analysis.

You haven't turned the page yet? Those of you who remain probably fall under one of two categories: those familiar with reliability data analysis, and Excel enthusiasts who are curious to learn one more way to exploit this versatile software. I predict readers in both groups will be glad they stuck around.