Choosing the Right Control Chart | ||||||||||||||||||||||||||||||||||||||||||||||
We help people think! |
Calls received by our tech support line follow
the 80/20 rule. 80% of the calls have to do with one question: Which control
chart do I use?
Finally, I had a BFO (brilliant flash of the obvious). The QI Macros already analyze your data to figure out how best to graph your data, why not let them automatically figure out which control to use too? Guess what, it works. The Control Chart Wizard is now available in the most recent version of the QI Macros.To purchase the QI Macros go to https://www.qimacros.com/orderform.html. If you already own the QI Macros, you can purchase an upgrade at https://www.qimacros.com/orderup.html If you are still choosing your control chart the old fashioned way, here are some tips. Choosing a Control ChartWith the recently added XMedianR chart, there are now nine control charts in the QI Macros. How do you know which one to use? When I'm working with data in Excel, I follow a simple strategy for selecting the right chart based on the format of the data itself. There are three formats I look for:
They look like this:
Single Row/Column If you only have a single row/column of data, there's only three charts you can use:
So which one should you choose? If you're counting indivisible things like defects, people, cars, or injuries, then choose the c chart. If you're measuring things like time, length, weight, or volume, choose the XmR chart. The data looks like this:
Look for these patterns in the data and then select the chart. Two Rows/Columns If the data has a numerator and a denominator that varies (e.g., defects/batch, errors/transactions), then you will want to use the:
How can you tell which one to use? I ask myself: "Can this widget have more than one defect?" If yes, use the u chart, otherwise use the p chart.
Sometimes, as in this example, you can have more defects than samples. This is another clue. Again, look for these patterns in the data and then select the chart. Two or More Rows/Columns of Variable Data Service industries don't use these charts very often. They are mainly used in manufacturing. If you have two or more rows or columns of variable data (time, weight, length, width, diameter, or volume) then you can choose one of three charts:
Your data should look like this: 
You can run the XbarR, XMedianR or XbarS on this data. Xbar uses the average as the measure of central tendency. The XMedianR uses the median. If you have more than five samples per period, then the XbarS will probably be the most robust chart for your needs. You can also use the XbarS if your data has a varying number of samples per period:
Again, look for these patterns in your data and then select the chart. The np Chart There's one chart I've left to last because I rarely find situations where it applies. The np chart is like the p chart except that the sample sizes are constant. The data looks like this:
Again, look for these patterns in your data and then select the chart. Summary So, just recognizing patterns in your data can make it easier to pick the right control chart.
If you learn to look for these patterns in your data, it will make it easier to choose the right control chart. And it's so easy to draw these charts with the QI Macros, that you can draw them and throw them away if they aren't quite right. For further help, download our SPC Quick Reference Card at http://www.qimacros.com/sustainaid.pdf or consider our 1 hour SPC Simplified Training video on DVD. See http://www.qimacros.com/sixsig267.html You can find all of this data in c:\qimacros\testdata. To purchase the QI Macros go to https://www.qimacros.com/orderform.html.
© 2007 KnowWare International Inc. (888) 468-1537 |
Hospital Bed Management System
It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.
|
||||||||||||||||||||||||||||||||||||||||||||
