Cover image for Statistical quality control using Excel
Statistical quality control using Excel
Zimmerman, Steven M., 1935-
Personal Author:
Publication Information:
Milwaukee, Wis. : ASQ Quality Press, [1999]

Physical Description:
xx, 346 pages : illustrations ; 26 cm 1 computer disk (3 1/2 in.)
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
TS156 .Z54 1999 Book and Software Set Non-Fiction Area

On Order



This work provides a tutorial for those who want to perform statistical quality control using the spreadsheet of choice, Excel. It provides screen dumps to help the reader, particularly those making the transition from Lotus 1-2-3, and presents real world applications.

Author Notes

Steven M. Zimmerman is the Vice President of Research for Biomedical Quality Control of America. He is the author of over 100 articles and more than 20 books including SPC Using Lotus 1-2-3 (ASQ Quality Press, 1992). Zimmerman has also developed a wide array of software materials and spoken at nearly 150 quality and software events. He received his Ph.D. in Industrial and Management Engineering from the University of Arkansas.
Marjorie L. Icenogle is an Assistant Professor in the Management Department at the University of South Alabama. She has over ten years of experience in consulting in the areas of process design and improvement and has published over fifteen articles in several professional journals. Icenogle holds a Ph.D. from Georgia State University.

Table of Contents

Prefacep. xvii
Part I Startingp. 1
Chapter 1 Introductionp. 3
Introductionp. 3
What Is Statistical Quality Control?p. 4
Why Use Spreadsheets?p. 6
How to Use This Textp. 6
Organization and Featuresp. 8
Summaryp. 9
Chapter 2 SQC and Spreadsheet Programsp. 11
Introductionp. 11
History of Quality Controlp. 12
Structure of SQC Problemsp. 12
Using Spreadsheet (Worksheet) Templates as Softwarep. 16
Editing the Templatesp. 16
Locking Worksheet Cells for Other Usersp. 16
Excel Capabilitiesp. 18
Summaryp. 18
Part II Fundamentals of Excel 7 for Windows 95p. 19
Chapter 3 Microsoft Excel Basicsp. 21
What Are Worksheet Programs?p. 22
Warningp. 23
Operating in the Microsoft Windows 95 Environmentp. 23
Understanding the Excel Operating Environmentp. 24
Opening, Creating, Saving, and Closing Workbooksp. 33
Entering Text, Numbers, and Formulas in Excelp. 38
Manipulating Worksheet Contentsp. 43
Using Helpp. 47
Summaryp. 49
Chapter 4 Learning More About Excelp. 51
Introductionp. 52
Checking Your Spellingp. 52
Sorting Datap. 52
Creating Charts and Graphsp. 56
Formatting a Chartp. 62
Creating Text Boxesp. 66
Printing Worksheets and Graphsp. 67
Customizing with Add-insp. 72
Importing Data from Other Sourcesp. 74
Hypertext Capabilitiesp. 78
Summaryp. 78
Part III Fundamentals of Statistical Quality Controlp. 79
Chapter 5 Statistical Fundamentals Using Excelp. 81
Statistical Fundamentalsp. 82
Central Tendencyp. 82
Variationp. 84
Shape of the Frequency Distributionp. 86
Using Excel to Understand Distributionsp. 89
Standardized Normal Distributionp. 90
Binomial Distribution (BINOMDIST)p. 95
Using Excel Functionsp. 99
Summaryp. 100
Chapter 6 Talking Statistical Quality Controlp. 103
Introductionp. 103
Specificationsp. 104
Inspectionp. 104
Acceptance Samplingp. 104
Statistical Process Controlp. 106
Summaryp. 109
Chapter 7 Distributionsp. 111
Introductionp. 112
Probabilityp. 112
Uniform Distributionp. 113
Central Limit Theoremp. 115
Normal Distributionp. 117
Exponential Distributionp. 121
Poisson Distributionp. 123
Summaryp. 124
Chapter 8 Selected Functions and Data Analysis Toolsp. 127
Introductionp. 127
Excel 7 Functionsp. 128
Data Analysis Toolsp. 135
Summaryp. 141
Part IV Statistical Process Controlp. 143
Chapter 9 X and Range Control Chartsp. 145
What Is Statistical Process Control?p. 146
Why Use X and Range Control Charts?p. 147
Calculating and Creating X and Range Worksheetsp. 147
Graphing the X Control Chartp. 157
Graphing the Range Control Chartp. 161
Formatting Textp. 163
Tools and Spellingp. 164
Templatep. 165
Expanding the X and Range Control Chartsp. 165
Creating a Comparison Graphp. 168
Using X and Range Control Chartsp. 171
Real Lifep. 173
Summaryp. 177
Exercisesp. 177
Chapter 10 X and Sigma Control Chartsp. 179
Why Use X and Sigma Control Charts?p. 180
Calculating and Creating X and Sigma Control Worksheetsp. 181
Creating the X Control Chartp. 187
Creating the Sigma Control Chartp. 190
Support Capabilitiesp. 191
Templatep. 191
Using X and Sigma Control Chartsp. 192
Expanding the Worksheet for Additional Observationsp. 193
Real Lifep. 195
Summaryp. 195
Exercisesp. 196
Chapter 11 p and np Control Chartsp. 199
Why Use p and np Control Charts?p. 200
Calculating and Creating p and np Worksheetsp. 201
Creating the p Control Chartp. 208
Templatep. 208
Worksheet Design Improvementsp. 208
Revising the Worksheet for the np Control Chartp. 212
Creating the np Control Chartp. 214
p Control Charts Based on Variable Lot Sizep. 215
Using p Control Chartsp. 218
Real Lifep. 220
Summaryp. 222
Exercisesp. 222
Chapter 12 c and u Control Chartsp. 225
Why Use c and u Control Charts?p. 226
Poisson Distribution--Random Numberp. 227
c Chart Formulasp. 227
Creating the c Chart Worksheetp. 228
Creating the c Control Chartp. 235
Changes in [lambda] (Lambda)p. 236
u Chart Formulasp. 238
Creating the u Chart Worksheetp. 239
Real Lifep. 243
Summaryp. 243
Exercisesp. 244
Chapter 13 Process Capabilityp. 245
Capability of a Processp. 246
Testing for the Normal Distributionp. 247
Creating a Process Capability Worksheetp. 248
Graphing Data for a Visual Testp. 254
Kolmogorov-Smirnov (KS) Testp. 256
Kolmogorov-Smirnov (KS) Graphp. 260
Issues in KS Testingp. 260
Indexes and Ratiosp. 262
Real Lifep. 264
Summaryp. 266
Exercisesp. 266
Chapter 14 Pareto and Fishbone Diagramsp. 267
Why Use Pareto Analysis?p. 268
Calculating and Creating a Worksheet for a Pareto Diagramp. 268
Creating the Pareto Diagramp. 271
Revising the Pareto Worksheet to Include Costsp. 272
Creating the Pareto Cost Diagramp. 273
Why Use a Fishbone Diagram?p. 274
Creating a Fishbone Worksheetp. 275
Summaryp. 276
Exercisesp. 277
Chapter 15 Individual, Moving Average, and Moving Range Control Chartsp. 279
Introduction to Individual, Moving Average, and Moving Range Control Chartsp. 280
Why Use Individual Control Charts?p. 281
Assumptions of Normalityp. 282
Creating and Calculating Individual Process Control Worksheetsp. 282
Graphing the Individual Control Chartp. 286
Revising the Worksheet for the Moving Range Control Chartp. 287
Graphing the Moving Range Control Chartp. 287
Revising the Worksheet for the Moving Average Control Chartp. 287
Graphing the Moving Average Control Chartp. 287
Using Individual, Moving Range, and Moving Average Control Chartsp. 289
Real Lifep. 290
Summaryp. 292
Exercisesp. 293
Part V Acceptance Samplingp. 295
Chapter 16 Binomial and Hypergeometric Distributionsp. 297
Introductionp. 298
Binomial Distributionp. 299
Hypergeometric Distributionp. 299
Creating and Calculating the Binomial and Hypergeometic Worksheetp. 300
Graphing the Binomial and Hypergeometric Distributionsp. 302
Summaryp. 304
Exercisesp. 305
Chapter 17 Operating Characteristic and Power Curves (Measuring Average Incoming Quality)p. 307
The Operating Characteristic Curve and Power Curvep. 308
Creating an Operating Characteristic Worksheetp. 310
Graphing the Operating Characteristic Curvep. 313
Graphing the Power Curvep. 314
Hypergeometric Operating Characteristic Curvesp. 314
Graphing the Hypergeometric Operating Characteristic and Power Curvep. 316
Deming's All-or-None Inspection Rulep. 316
Real Lifep. 318
Summaryp. 320
Exercisesp. 320
Chapter 18 Average Outgoing Qualityp. 323
Outgoing Qualityp. 323
Creating the Average Outgoing Quality Worksheetp. 324
Creating the Average Outgoing Quality Graphp. 326
Real Lifep. 328
Summaryp. 328
Exercisesp. 329
Appendix A Reference Listp. 331
Appendix B Tables of Factors and Formulasp. 333
Indexp. 336