Hot Off the Quality Press

Statistical Quality Control Using Excel (with software)

by Steven M. Zimmerman, Ph.D., and Marjorie L. Icenogle, Ph.D.

Quality practitioners from every industry have long used statistical quality control (SQC) to ensure that their products and services meet customer expectations. Too often, however, those less experienced with SQC find it difficult to interpret the complicated mathematical formulas and detailed sampling results associated with the application. As a result, many professionals have successfully turned to Excel® software to simplify their SQC endeavors and quickly reap the benefits of actually exceeding customer requirements.

Whether you’re new to SQC or the software product Excel, you’ll find all the information you need to understand and incorporate the two in Statistical Quality Control Using Excel. Nonmathematical descriptions guide you through the basics of both SQC and the methods of creating control charts using Excel. You’ll discover easy-to-read explanations of statistical distribution, outliers, and the analysis required for SQC methods. Statistical process control methods such as p and np control charts and Pareto charts are also demonstrated. This book will quickly become your most used source, as it will help you:

* Master the basics of structuring SQC problems using control charts and graphs

* Train those moving from Lotus 1-2-3® to the Excel spreadsheet software

* Reduce costly calculation errors

Practice problems, definitions of key terms, examples, and end of chapter summaries help make this book an outstanding tutorial for your desktop.

CONTENTS (Summarized): SQC and Spreadsheet Programs • Microsoft Excel Basics • Learning More About Excel • Statistical Fundamentals Using Excel • Distributions • Selected Functions and Data Analysis Tools • X Bar and Range Control Charts • X Bar and Sigma Control Charts • p and NP Control Charts • c and u Control Charts • Process Capability • Pareto and Fishbone Diagrams • Individual, Moving Average, and Moving Range Control Charts • Binomial and Hypergeometric Distributions • Operating Characteristics and Power Curves • Average Outgoing Quality

Additional Information:

System Requirements: Excel template disk will only run on Windows 95 running Excel 7

1998. 375 pages. ISBN 0-87389-393-X. 7 x 10 softcover.

Item: H0982 Member Price: $45.00 List Price: $50.00

This is a recently added title to our Quality Press collection and may or may not be listed in our Quality InfoSearch or our current Quality Press Publication Catalog. To save time, please call ASQ’s Customer Service Center at 800-248-1946 or 414-272-8575 to order this title.