QI Macros Control Chart Stability Rules

home · products · services · search · view cart · contact  
 
  NAVIGATION        
 

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar

2253 S. Oneida
Ste 3D
Denver, CO 80224


We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011



 

Control Chart Rules for determining unstable points and conditions vary among the experts. QI Macros 2006 used rules from Montgomery's Introduction to Statistical Quality Control, 4th edition. QI Macros 2007 lets you select between these rules and rules from Juran, AIAG and Western Electric. You can also create custom rules.

QI Macros 2006 Stability Rules

control chart stability analysis rules for QI Macros 2006

QI Macros 2007 Default Stability Rules

control chart stability analysis rules for QI Macros 2007 and later

How to Change Stability Rules in QI Macros 2007 and later versions

  1. Click on the QI Macros menu item, Control Charts and then Control Chart Rules.
  2. menu to change control chart stability rules

  3. Select the rules you want to use. Depending on how fast your version of Excel is, you should see the QI Macros updating the rules file.
  4. Now just run a chart and the new rules will be applied.
  5. To check which rules are active, click on QI Macros, Control Charts, Control Chart Rules and then Show Current Rules. The active rules will be shown in the column labeled "n(points)." In the example below, you can tell that Jurans rules are active because the values in the "n (points)" column are equal to Jurans rules.

    control chart stability rules

  6. Any changes made to the rules are "permanently" made. The rules will not reset if you close and reopen Excel or shut down and start up your computer.
  7. To reset the rules to the defaults or to another set of rules simply click on the Control Chart Rules menu and select a new set of rules or Montgomerys rules to go back to the default.

How to Create Your Own Customized Rules in QI Macros 2007 or later versions

You can set your own custom stability rules using the QI Macros as follows:

  1. Open Excel
  2. Open the Control Chart Rules file in each of this location:
    My Documents\QI Macros Test Data\ControlChartRules.xls

    If there isn't one in that location, use:
    c:\QIMacros\TestData\ControlChartRules.xls

    If there isn't one in either of those two locations, use:
    c:\Program Files\Microsoft Office\Office14\xlstart\QITemplates\ControlChartRules.xls

  3. The file will open but it will be hidden in Excel. To unhide the file in Excel 03 and previous versions: select Window, Unhide and then the Control Chart Rules file in the Unhide box. In Excel 2007-2010, select View then Unhide. Here is a picture of the Excel 2007-2010 ribbon:
  4. control chart stability rules file

  5. The control chart rules file will allow you to turn a stability test off by changing the value in the Apply rule column from True to False. Just click on a cell and change the value using the pull down arrow.
  6. change control chart stability analysis rules

  7. You can also change the number of points required for each test by changing values in the n(points) column. Just select the cell and select one of the options using the pull down arrow.
  8. number of points used in stability rules

  9. After you make your changes, save the Control Charts Rules file, rehide it and then close and re-open Excel. Note: the changes will not take effect until you close and re-open Excel.
  10. To change back to the defaults, from the QI Macros menu, simply select Control Charts, Control Chart Rules, Montgomery (Default Rules). Note: There is no need to close and re-open Excel when making changing via the menu.

QI Macros Control Chart Features and Articles

Other QI Macros and Control Chart Articles

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

 
Macintosh
PC
QI Macros - One License Per Computer
- Download Now and Get Backup CD & User Guide (#230) in 1-3 days - $199 + S&H
QI Macros - One License Per Computer
- Download Only - No Shipping or Customs Duties (#W230) $199

If you love the QI Macros...
Please ask a handful of friends to download the trial version. Here's what to say:
Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros!
Find out more at www.qimacros.com/excel-spc-software.html.
Get a 30-day trial at www.qimacros.com/free-spc-software.html.

Going to a meeting of quality professionals?
We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com.

 

Download
QI Macros

30-Day Trial Now!


Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee


 
home | products | services | search | sitemap | view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training