Reliability Modeling with Spreadsheets


Dodson, Bryan   (1999, ASQ)   Continental Teves, Auburn Hills, MI

Annual Quality Congress, Anaheim, CA    Vol. 53    No. 0
QICID: 10876    May 1999    pp. 575-585
List $10.00
Member $5.00

This article is available for FREE to ASQ members with the appropriate membership type and/or magazine subscriptions. If you are signed-in you should be able to download articles you are entitled to receive. If you have questions about your membership please contact Customer Care at 800-248-1946 or


Article Abstract

Parameter estimation, accelerated testing, and tolerance design are three areas in which reliability modeling is amenable to spreadsheet analysis. For parameter estimation, two examples demonstrate how to use spreadsheets for constructing lognormal and Weibull hazard plots of test data. Spreadsheets allow relatively easy implementation of the maximum likelihood estimation method, an example of which is given for Weibull distribution parameters. For accelerated testing, an example shows the application of spreadsheets to Arrhenius and Eyring modeling of acceleration factors. For tolerance design, spreadsheets facilitate the study of component tolerances and distribution factors. Spreadsheets can generate random numbers and produce simulation results for tolerance experiments.



Browse QIC Articles Chronologically:     Previous Article     Next Article

New Search

Featured advertisers

ASQ is a global community of people passionate about quality, who use the tools, their ideas and expertise to make our world work better. ASQ: The Global Voice of Quality.