Locked lesson.
About this lesson
The C chart (plots Counts) is the simplest of the attribute data control charts. This lesson explains how the data is recorded and interpreted on the chart. The lesson describes how to create this control chart in both Microsoft Excel and using Minitab. The lesson will include practice creating the chart.
Exercise files
Download this lesson’s related exercise files.
C Chart.xlsx10.3 KB C Chart - Solution.docx
63.1 KB
Quick reference
C Chart
The C chart (plots Counts) is the simplest of the attribute data control chart. It can be easily created in either Microsoft Excel or Minitab.
When to use
Use the C Chart when counts the number of an attribute occurrence (defect) within all the units of a fixed subgroup size. It is frequently used to count the occurrences of an attribute during a fixed time period such as a day or week.
Instructions
The C Control Chart tracks the count of occurrences of an attribute (such as a defect). The value is always a whole number. The count is for every occurrence of that attribute within a sample or subgroup of a fixed size. C Charts are often used to count the number of occurrences during a fixed time period such as a day or week.
C Charts can be created in Microsoft Excel or in Minitab. Within Minitab, control charts are created by using the “Stat” pull down menu, then selecting “Control Charts.” Within the Control Charts window, select “Attribute Charts” and then finally select “C.” In the Minitab C Chart panel, all that needs to be done is to select the data column with your data.
If creating the C Chart in Excel:
- Determine your subgroup size. The subgroup size must be constant for the C chart. The subgroup size should be such that the average or mean value of the counts is greater than two.
- Count the occurrences of the attribute or defect (not the number of defective units) within each subgroup.
- Calculate the Mean and the Upper Control Limit and Lower Control Limit
- Plot the data points, the Mean and the control limits.
- Take appropriate actions to remove special causes or to center your data within the customer spec limits. In the example shown there is a special cause condition of a mean shift indicated at point 18 that needs to be investigate.
Hints & tips
- This is the easiest of the attribute data control charts to understand and create.
- Set your control limits once you have 30 data points. They do not need to be recalculated unless you change the process or remove a special cause condition.
- The LCL can never be less than zero. If the calculation is a negative number, just use zero for your value.
- When plotting the chart in Excel, use the “Line Graph” charting option with lines that overlay, not ones that stack.
Lesson notes are only available for subscribers.
PMI, PMP, CAPM and PMBOK are registered marks of the Project Management Institute, Inc.