- Statistical Process Control
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 PowerPoint 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.
Includes CD-ROM with SQC templates which will only run on Windows 95 or higher running Excel '97 or higher.