Overview
Would you like to learn more about using Excel®? Are looking for an easier way to solve statistical quality control problems? Statistical Quality Control (SQC) experts Steven Zimmerman and Marjorie Icenogle have updated their guide that combines the power of each into this one integrated book and CD-Rom. While this introduction to SQC is for beginners to either quality or to the software product Excel, those with a more advanced knowledge of SQC and Excel will also find this book valuable to incorporate the two.New versions of Excel make creating quality control spreadsheets easier than ever. This new edition contains spreadsheets for: exponential weighted moving average charts, moving sum of the sample statistic control charts, cumulative sum charts, reliability problems, and information on using the Pivot Table and Pivot Chart functions in Excel.
This guide begins with introductions to the concepts of SQC and the use of spreadsheets. A review of Excel’s features is followed by explanations of statistical distribution, outliers, and the analysis required for SQC methods. Basic statistical process control methods such as p and np control charts, c and u control charts, and Pareto charts are demonstrated. Descriptions on acceptance sampling methods including binomial and hypergeometric distributions and average outgoing quality curves are also offered. Also new to this package is direction on using Excel in power point presentations. Practice problems, definitions of key terms, detailed graphics, and end-of-chapter summaries help make this book an outstanding tool to combine SQC with Excel software.
Synopsis
Zimmerman and Icenogle present a gradual, gentle introduction to both Excel and statistical quality control. Engineers, technicians, inspectors, and anyone else who is new to either Excel or statistical quality control can use this book to get started, and anyone possessing some familiarity with the subject can skip to the more advanced chapters at the end, which give detailed and varied methods for statistical process control and acceptance sampling - statistical fundamentals, distributions, sigma control charts, p and np control charts, and c and u control charts are some of the topics covered in these sections. Annotation © 2004 Book News, Inc., Portland, OR
Booknews
Explains how to use Excel software to simplify the complicated mathematical tasks necessary to statistical quality control. Explanations of statistical distribution, outliers, and analysis are included and statistical process control methods such as p and np control charts and Pareto charts are demonstrated. The disk contains sample problems and spreadsheets from the text. Annotation c. by Book News, Inc., Portland, Or.