Reliability Modeling with Spreadsheets

Article

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

FOR A LIMITED TIME, ACCESS TO THIS CONTENT IS FREE!
You will need to be signed in.
New to ASQ? Register here.

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.

Keywords

Estimation,Reliability,Testing,Tolerances,Design


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.