Reliability Data Analysis with Excel and Minitab

Kenneth S. Stephens

Description

Many reliability engineers are gainfully employed in considerations of the physical nature of components and systems-bringing to bear theories and methodologies of physics, electronics, mechanics, material science, chemistry, and so on. But when a product has been designed and manufactured, its performance in terms of durability, strength, and life become a matter of test, measurement, and analysis.
Statistical theories and methodologies provide a large number of analytical tools to assist the reliability engineer in studying the performance of products and the fruits of the physical considerations, even revealing further improvements that can be made in the physical properties. Hence, reliability is a multidisciplined field of endeavor. Statistical theories and methodologies allow estimation of important characteristics as well as levels of confidence or assurance (or lack thereof) with respect to the estimations. They also provide direction in actions necessary to improve estimates and confidence levels if results are too variable to render important decisions.
Some derivations are contained in this text, but the approach here is meant to be more practical, in following each topic introduced and expanded with examples. On each topic covered, reasonably practical examples are used to illustrate and demonstrate the procedures introduced and discussed. For all of these examples either Excel files or Minitab files or both have been prepared (available from Quality Press). They can be readily accessed and opened directly in their respective software packages to permit the preparation of new files specifically for use by the reader.
"This book provides a much-needed theoretical text to aid advanced reliability engineering data analysis. Applications using Excel and Minitab support a broad span of probability applications for reliability data analysts. I most strongly recommend this book for seasoned Six Sigma Black Belts or statisticians who must support Design for Six Sigma applications for new product development projects. It's rich in food for thought as well as providing a most nourishing banquet for consumption by engineers --- it is not for light reading as a snack, but it must be consumed as a seven-course meal!" Gregory H. Watson
Chairman, International Academy for Quality
ASQ Past-President and Fellow

Sujets

• Business
• Qualité, hygiène, sécurité, environnement
• Sciences & Techniques
• Statistiques
• Statistiques
• Techniques
• Automatisation et Contrôle
• Contrôle des processus
• Automatisation
• Automate
• Quality Control
• Sciences et techniques
• Technology
• Engineering
• Probabilités et statistiques

Informations

• Publié par: ASQ Quality Press
• Date de parution: 30 août 2011
• Nombre de lectures: 1
• EAN13: 9781636940458
• Langue: English
• Poids de l'ouvrage: 2 Mo

Extrait

Also available from ASQ Quality Press:
HALT, HASS, and HASA Explained: Accelerated Reliability Techniques , Revised Edition
Harry W. McLean
The Certified Reliability Engineer Handbook
Donald W. Benbow and Hugh W. Broome
Concepts for R&R Studies , Second Edition
Larry B. Barrentine
The Certified Quality Engineer Handbook , Third Edition
Connie M. Borror, editor
Failure Mode and Effect Analysis: FMEA from Theory to Execution , Second Edition
D. H. Stamatis
The Weibull Analysis Handbook , Second Edition
Bryan Dodson
The Quality Calibration Handbook: Developing and Managing a Calibration Program
Jay L. Bucher
Reliability Statistics
Robert A. Dovich
Root Cause Analysis: Simplified Tools and Techniques , Second Edition
Bjørn Andersen and Tom Fagerhaug
The Metrology Handbook
Jay L. Bucher, editor
The Quality Toolbox , Second Edition
Nancy R. Tague
To request a complimentary catalog of ASQ Quality Press publications, call 800-248-1946, or visit our website at http://www.asq.org/quality-press .

Reliability Data Analysis with Excel and Minitab
Kenneth S. Stephens
ASQ Quality Press Milwaukee, Wisconsin

American Society for Quality, Quality Press, Milwaukee 53203
© 2012 by ASQ
All rights reserved. Published 2011
Library of Congress Cataloging-in-Publication Data
Owens, Tracy L.
Six Sigma green belt, round 2 : making your next project better than the last one / Tracy L. Owens.
p. cm.
Includes bibliographical references and index.
ISBN 978-0-87389-825-6 (hard cover : alk. paper)
1. Six sigma (Quality control standard) 2. Quality control—Management. 3. Cost. I. Title.
HD62.15.O924 2011
658.4'013—dc23
2011027385
ISBN: 978-0-87389-831-7
No part of this book may be reproduced in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher.
Publisher: William A. Tony
Acquisitions Editor: Matt T. Meinholz
Project Editor: Paul Daniel O'Mara
Production Administrator: Randall Benson
ASQ Mission: The American Society for Quality advances individual, organizational, and community excellence worldwide through learning, quality improvement, and knowledge exchange.
Attention Bookstores, Wholesalers, Schools, and Corporations: ASQ Quality Press books, video, audio, and software are available at quantity discounts with bulk purchases for business, educational, or instructional use. For information, please contact ASQ Quality Press at 800-248-1946, or write to ASQ Quality Press, P.O. Box 3005, Milwaukee, WI 53201-3005.
To place orders or to request ASQ membership information, call 800-248-1946. Visit our website at http://www.asq.org/quality-press .

Among many sustaining strengths, this work is dedicated to a significant four of these strengths in my life and vocation .
First and foremost is the grace, guidance, assurance of redemption, and daily help I receive from my Lord and Savior and those of like mind in His service .
Second is my wife, Gina Stephens, whose daily support, patience, encouragement, and companionship are and have been a sustaining strength on life's journey .
Third is my thankful memory of two influential and guiding mentors, Dr. Ellis R. Ott and Harold Dodge, * who helped shape my life's professional career, together with a myriad of colleagues dedicated to the quality disciplines with whom I have had the pleasure of affiliation with the American Society for Quality for over 56 years and with the International Academy for Quality for some 27 years .
Fourth is the joy and fellowship that family and friends bring to my daily life, for which I am very grateful .
This dedication is further extended to the inspiration and challenges received from an untold number of students whom I have had the privilege of serving over the years at Rutgers University, LeTourneau College, Georgia Tech, Southern Polytechnic State University, USF, and UCF. It is a profound hope that this book will continue to inspire them and others .
* See also the dedication in The Handbook of Applied Acceptance Sampling , ASQ Quality Press, Milwaukee, Wisconsin, 2001.

CD-ROM Contents
These files were included on a CD-ROM accompanying the print version of this book. To acquire them, please email [e-mail] .
Chapter 2
CH 2 Reliability Function Relationships—Summary
CH 2 AFR Approximations
CH 2 Reliability Relationships
Chapter 3
CH 3 Example 3-1 Hypergeometric Probability Template
CH 3 Example 3-2 Hypergeometric Probability of Acceptance
CH 3 Example 3-3 Hypergeometric Probabilities—Minitab
CH 3 Example 3-4 Hypergeometric OC Curve—Minitab.
CH 3 Example 3-5 Comparison of h(d;n,D,N) vs b(d;n,ρ)
CH 3 Example 3-6 Binomial Probability Template
CH 3 Example 3-7 Binomial Probabilities—Minitab
CH 3 Example 3-8 Cumulative Binomial Template
CH 3 Example 3-9 Hypergeometric—Binomial—f Binomial Comparisons
CH 3 Examples 3-10-11 Negative Binomial Templates
CH 3 Gamma Function
CH 3 Example 3-12 Negative Binomial—Minitab
CH 3 Example 3-13 Geometric—Exponential Comparison
CH 3 Example 3-14 Geometric Distribution—Minitab
CH 3 Example 3-15 Hypergeometric—Binomial—Poisson Comparisons
CH 3 Example 3-16 Poisson Individual and Cumulative Probability Template
CH 3 Example 3-17 Poisson Computations—Minitab
CH 3 Example 3-18 Cumulative Gamma—Poisson Template
CH 3 Example 3-19 Cumulative Poisson & Chi-Square Template
Chapter 4
CH 4 Example 4-1 Hypergeometric Confidence Intervals
CH 4 Example 4-2 Hypergeometric Confidence Interval Computations—Minitab
CH 4 Example 4-3 Negative Hypergeometric CI—Minitab
CH 4 Example 4-4 Confidence Limits and Intervals for Binomial Proportion
CH 4 Example 4-5 Binomial CI—Minitab
CH 4 Example 4-6 Negative Binomial Confidence Limits
CH 4 Example 4-7 CI for Negative Binomial—Minitab
CH 4 Example 4-8 Poisson Confidence Limits Template
CH 4 Example 4-9 Poisson CIs—Minitab
Chapter 5
CH 5 F(t) Estimation Methods Comparisons—Template
CH 5 Example 5-1 F(t) Estimation Methods with Several Data Sets
CH 5 Example 5-1 Multi-Censored Data Sets—Minitab
CH 5 Example 5-2 Exponential—Excel
CH 5 Example 5-2 Exponential—Minitab
CH 5 Example 5-3 Normal—Excel
CH 5 Example 5-3 Normal—Minitab
CH 5 Example 5-4 Lognormal—Excel
CH 5 Example 5-4 Lognormal—Minitab
CH 5 Example 5-5 Weibull—Excel
CH 5 Example 5-5 Weibull—Minitab
CH 5 Example 5-6 SEV—Excel
CH 5 Example 5-6 SEV—Minitab
CH 5 Example 5-7 Loglogistic—Excel
CH 5 Example 5-7 Loglogistic—Minitab
Chapter 6
CH 6 Exponential Model Template—Graphs of Functions
CH 6 Gamma Templates with Graphs
CH 6 Chi-Square Template with Graphs
CH 6 P and χ 2 (α) Value Template & Chi-Square Table
CH 6 Example 6-1 GOF on Toss of Die
CH 6 Example 6-2 Chi-Square GOF Test for Exponential Fit—Excel
CH 6 Example 6-2 Exponential Fit—Minitab
CH 6 Adjusted Anderson-Darling Statistic—Minitab—pdf
CH 6 Anderson-Darling by Hand—pdf
CH 6 Example 6-3 AD Minitab Example—Excel
CH 6 Example 6-3 Anderson-Darling—Minitab
CH 6 Example 6-4 Anderson-Darling Exponential Example—Excel
CH 6 Example 6-4 Anderson-Darling Exponential Example—Minitab
CH 6 K-S GOF Test-Example & Tables
CH 6 Exponential Distribution Chi-Square Confidence Intervals—Template
CH 6 Exponential Distribution—Chi-Square Confidence Interval Factors—Tables
CH 6 Example 6-5 Analysis of Zero Failures—Minitab
CH 6 Zero Failure Factors—Minimum & General Test Characteristics
CH 6 Test Plans—Minitab
Chapter 7
CH 7 Weibull pdf, CDF, h(t), and H(t) Graphs
CH 7 Reliability-Survival Capabilities and Examples
CH 7 Minitab Reliable Data Set on Temp 80-100
CH 7 SEV Function Template and Graphs
CH 7 Minitab Tirewear Data SEV Analysis
Chapter 8
CH 8 Standard Normal CDF Table
CH 8 Normal Template and Graphs
CH 8 Example 8-1 Normal—Minitab
CH 8 Lognormal Template and Graphs
CH 8 Example 8-2 Probit Analysis—Minitab
Chapter 9
CH 9 Logistic Distribution Template and Graphs
CH 9 Example 9-1-Logistic—Minitab
CH 9 Example 9-2-Logistic—Minitab
CH 9 Example 9-3 Circuit Data Set—Failure Modes—Minitab
CH 9 Loglogistic Distribution Template and Graphs
CH 9 Loglogistic Statistics Template
Chapter 10
CH 10 Parallel System Redundancy Improvement
CH 10 Active Redundancy k-out-of-n System—General—Exp
CH 10 Standby Redundancy Reliability Improvement
Chapter 11
CH 11 Example 11-1A System Age—Inter-arrival Time—Data Analysis
CH 11 Example 11-1A System Age—Inter-arrival Time—Data Analysis—Minitab
CH 11 HPP Template & Spare Part Table
CH 11 Example 11-2A Multiple Systems Analysis—Excel
CH 11 Example 11-2A Multiple Systems Analysis—Minitab
CH 11 Mann Trend Test Critical Values—Excel
CH 11 Example 11-1B Trend Test Analysis—Excel
CH 11 Chi-Square Template—P-Values and Critical Values
CH 11 Example 11-1B Trend Test Analysis—Minitab
CH 11 Example 11-2B Trend Test Analysis—Excel
CH 11 Example 11-3 Repairable System Analysis—Excel
CH 11 Example 11-3 Repairable System Analysis—Minitab
CH 11 Example 11-4 Repairable System Analysis—Minitab
Chapter 12
CH 12 Example 12-1 Multiple Level Analysis
CH 12 Example 12-1 Multiple Level Analysis—Minitab
CH 12 Arrhenius Template—Ea & Λ
CH 12 Example 12-2 MINITAB-INSULATE—ALT Example
CH 12 Example 12-3 Inverse Power Law—Minitab
CH 12 Example 12-3 Inverse Power Law on eV—Excel
CH 12 Example 12-4 Temp-Current Stress Model—Minitab
CH 12 Example 12-4 Temp-Current Stress Model—Excel

List of Figures and Tables Figure 2.1 Distribution curve of f ( t ) illustrating F ( t ) and F ( t 2 ) − F ( t 1 ) . Figure 2.2 Distribution curve of F ( t ) . Figure 2.3 Distribution curve of f ( t ) illustrating R ( t ) . Figure 2.4 Distribution curve of R ( t ) . Figure 2.5 Graph of R ( t ) = e −0.0003 t . Figure 2.6 The bathtub curve of reliability . Table 2.1 Interval complete data with fifty-hour intervals . Figure 3.1 Minitab's data entry box for negative binomial distribution. Figure 4.1 Contingency table for hypergeometric distribution. Figure 4.2