Statistical Quality Control Using Excel, Second Edition

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.

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 and more.