Failure data analysis: the application of Excel spreadsheet add-ins as an aid to curve fitting
✍ Scribed by E. G. John; R. I. Grosvenor
- Publisher
- John Wiley and Sons
- Year
- 2000
- Tongue
- English
- Weight
- 251 KB
- Volume
- 16
- Category
- Article
- ISSN
- 0748-8017
No coin nor oath required. For personal study only.
✦ Synopsis
This paper describes the application of the Solver function contained within Microsoft Excel r to generate solutions to a range of common failure data analysis problems. The capability of the Solver function is demonstrated and employed to determine the appropriate Weibull distribution parameters for single, minimum life, censored and mixed distribution data. The examples selected have been taken from existing published data sets. The paper is also supplemented with a further example, drawn from an industrial situation, in which the approach is applied to the determination of the extent of an early life failure problem in low-voltage electrical contactor coils.