Control Chart Wizard in QI Macros for Excel
Confused About Which Control Chart to Use?
With QI Macros You'll Never Struggle with Choosing the Right Control Chart Ever Again.
Based on calls from our tech support line, we can tell you that most folks struggle with which control chart to choose. Even if they have gone to a training class, it doesn't matter, they still spend time they don't have trying to decide on the right chart and then they still aren't sure.
We can help. The QI Macros Control Chart Wizard can analyze your data and choose the right control chart for you. It saves you time and mistake proofs the control chart selection process. Spend your time on more important things like analyzing the control chart after its drawn.
Decision Trees are Cumbersome. Rather than having to think your way through the forest of decision trees like the ones in Minitab®, wouldn't it be great if the decision tree was already coded into the software? In the QI Macros, it is!
To use QI Macros Control Chart Wizard to Select the Right Control Chart
- Just select your data:
- Then select the Control Chart Wizard from the QI Macros menu.
- The Chart Wizard will automatically select the XmR (Individuals) chart.
If it's trying to choose between a p chart and a u chart, it will ask this question:
Answer "yes" for a u chart and "no" for a p chart. If the you want to use the XmR Trend or XMedianR, then you will have to choose that chart.
If it's trying to choose between a c chart and an XmR chart, it will ask this question:
Answer "yes" for an XmR chart and "no" for a c chart.
How the Control Chart Wizard selects the right control chart:
|1||Integers (attribute)||c chart|
|2||Integers (constant sample)||
|2||Integers (varying sample)||
p or u chart
|2-5||Decimals or integers||XbarR chart|
|6+||Decimals or integers||XbarS chart|
We just completed our JCAHO review and received a 98 with NO time 1's so we are very excited and fired up about that. Our ability to use the control charts and talk with staff about them really helped!
- Leana Hilde RN
Methodist Medical Center
QI Macros SPC Software for Excel:
- Draws np, p, c, u, XmR, XbarR, XMedianR and XbarS control charts
- Calculates and draws lines for: average, + 1 sigma, +2 sigma and +3 sigma (UCL and LCL)
- Performs stability analysis and turns any unstable point or condition RED
- Allows you to add data to existing control charts and create control charts with multiple (stair step) control limits