From the course: Excel: Statistical Process Control
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
When to use a C chart - Microsoft Excel Tutorial
From the course: Excel: Statistical Process Control
When to use a C chart
- [Instructor] Manufactured products are usually combinations of different components. A computer monitor, for example, has a base, a power supply or connection, and a screen. In this movie I will focus on the screen and the individual pixels that it uses to generate its image. One way to assess the quality of a monitor screen is by counting the number of defective pixels that result from the manufacturing process. When you are counting individual defects on a specific unit then you use a C chart, which is short for count chart. In the case of LED monitors, first realize that the monitor screen has millions of pixels. Some of the much larger ones might even go into the billions. And you want to know how many pixels are bad. What you're interested in is the average count per unit not the number of defective units. So previously we looked at a P chart, which a proportion, which did look at the number of defective units. And one defect was counted the same as a unit with three defects…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.