posted 16 April 2000 04:30 AM               

Preference for using excel is to avoid having to learn a "canned" package, plus most of my colleagues are already familiar with excel.

posted 16 April 2000 04:46 PM               

I can't remember what I paid for this, but it wasn't a bad price.

Statistical Quality Control Using Excel
By Steven M. Zimmerman, et al
ISBN 0-87389-393-X
ASQ Press

With the ISBN you can get it almost anywhere, or order from:

www.asq.org

posted 17 April 2000 09:01 AM               

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