Business Analysis with Microsoft® Excel, Second Edition

Using Worksheet Functions for Quality Control

You can use Excel to help answer a variety of questions that occasionally arise in quality control situations. It's important to understand the nature of the tools that are available to you when such questions come up. Because statistical quality control is largely an exercise in probability—and in choosing the right tool in a given case—this chapter concludes with a discussion of some of these questions and how you can use Excel to answer them.

Sampling Units from a Finite Population

To this point we have discussed statistical process control and acceptance sampling in terms of theoretically infinite populations. There has been no limit to the size of the population of products that has been sampled ...