qimacros test results
TRANSCRIPT
![Page 1: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/1.jpg)
Expected QI Macros Results and Comparison to Minitab 12 or other Resources
Table of Contents
Chart Page # Expected Differences 2 Control Charts Attribute Charts - c, u, p, np 3 Variable Charts - Xmr, XbarR, XandS, XmR Trend, Xmedian
7
Cusum 17 Moving Average 18 EWMA 19 Control Chart Stability Rules 21 Control Chart Stability Tests 23 Histogram with Cp and Cpk 36 Frequency Histogram 40 Capability 5 pack 41 Other Charts Pareto 42 Run 43 Scatter 44 Box and Whisker 45 Mulitvari Chart 46
©MMVI KnowWare International Inc. www.qimacros.com 1
![Page 2: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/2.jpg)
Expected Differences Stability Analysis Both the QI Macros and Minitab let you define what stability rules you want to use. The QI Macros defaults to Montgomery's rules but lets you select from Juran, AIAG and Western Electric rules. You can also further customize rules in the QI Macros. See http://www.qimacros.com/free-excel-tips/control-chart-rules.html Minitab requires you to define the rules you want to use each time you run a chart. The QI Macros offer additional tests that Minitab does not. Minitab also treats trends differently than the QI Macros. For example, one common set of rules is 6 points in a row increasing or decreasing. Once you have 6 points in a row that meet these criteria, the QI Macros will turn all 6 points red. Minitab will not turn any points red until the 7th point and then will only turn the 7th point red. Upper and Lower control limits on u, p, and XandS charts – since the sample size on these charts vary, the upper and lower control limits vary (from point to point). Minitab displays the UCL and LCL for the last point. The QI Macros display the UCL and LCL for the 3rd to the last point. Note the control limit lines are the same, only the value displayed is different. Also, the center lines are both the same since these do not vary. Histogram - Standard Deviation calclation The QI Macros uses the standard deviation calculation of Microsoft Excel. Minitab uses a different calculation which returns slightly different results. The standard deviation difference will cause slight differences in the following calculations: Pp, Ppk, Z score and Expected PPM Histogram Cp, Cpk calculation when subgroup size is 3 The difference in the two calculations is the constant used in the sigma estimator calculation. This effects Cp and Cpk but not Pp and Ppk. Per Juran and Montgomery, the QI Macros use a constant of 1.693 when there are 3 subgroups. It looks like Minitab is using something like 1.093. We do not know where this constant comes from and believe it to be an error in Minitab. Cusum and Moving Average Chart Control Limits Control limits are slightly different because QI Macros uses standard deviation while Minitab uses sigma estimator.
©MMVI KnowWare International Inc. www.qimacros.com 2
![Page 3: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/3.jpg)
C Chart QI Macros c Chart
Minitab c Chart
©MMVI KnowWare International Inc. www.qimacros.com 3
![Page 4: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/4.jpg)
u Chart QI Macros u chart
Minitab u chart
UCL / LCL differences. See notes regarding expected differences on page 2.
©MMVI KnowWare International Inc. www.qimacros.com 4
![Page 5: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/5.jpg)
p Chart QI Macros p chart
Minitab p chart
UCL / LCL differences. See notes regarding expected differences on page 2.
©MMVI KnowWare International Inc. www.qimacros.com 5
![Page 6: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/6.jpg)
np Chart QI Macros np Chart
Minitab np chart
See note regarding difference in stability rules on page 2.
©MMVI KnowWare International Inc. www.qimacros.com 6
![Page 7: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/7.jpg)
XmR Chart QI Macros X chart
Minitab X chart
See note regarding difference in stability rules on page 2.
©MMVI KnowWare International Inc. www.qimacros.com 7
![Page 8: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/8.jpg)
QI Macros Range Chart
Minitab R chart
See note regarding difference in stability rules on page 2.
©MMVI KnowWare International Inc. www.qimacros.com 8
![Page 9: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/9.jpg)
XbarR Chart
QI Macros Xbar chart
Minitab Xbar chart
©MMVI KnowWare International Inc. www.qimacros.com 9
![Page 10: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/10.jpg)
QI Macros R chart
Minitab R chart
©MMVI KnowWare International Inc. www.qimacros.com 10
![Page 11: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/11.jpg)
XandS Chart
QI Macros X chart
Minitab X chart
©MMVI KnowWare International Inc. www.qimacros.com 11
![Page 12: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/12.jpg)
QI Macros S chart
Minitab S chart
©MMVI KnowWare International Inc. www.qimacros.com 12
![Page 13: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/13.jpg)
XmR Trend
QI Macros Trend chart
Minitab Trend chart
©MMVI KnowWare International Inc. www.qimacros.com 13
![Page 14: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/14.jpg)
QI Macros R chart
Minitab R chart N/A
©MMVI KnowWare International Inc. www.qimacros.com 14
![Page 15: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/15.jpg)
Xmedian R – Single Column of Data QI Macros X Chart
QI Macros R Chart
Minitab does not offer median charts
©MMVI KnowWare International Inc. www.qimacros.com 15
![Page 16: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/16.jpg)
Xmedian R – Multiple Columns of Data QI Macros X Chart
QI Macros R Chart
Minitab does not offer median charts
©MMVI KnowWare International Inc. www.qimacros.com 16
![Page 17: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/17.jpg)
Cusum Chart
QI Macros Cusum Chart - Target = 10
Minitab Cusum Chart - Target =10
Control limits are slightly different because QI Macros uses standard deviation while Minitab uses sigma estimator.
©MMVI KnowWare International Inc. www.qimacros.com 17
![Page 18: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/18.jpg)
Moving Average Chart
QI Macros Trend chart
Control limits are slightly different because QI Macros uses standard deviation while Minitab uses sigma estimator.
©MMVI KnowWare International Inc. www.qimacros.com 18
![Page 19: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/19.jpg)
Estimated Moving Weighted Average Chart QI Macros
Minitab
©MMVI KnowWare International Inc. www.qimacros.com 19
![Page 20: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/20.jpg)
QI Macros EWMA R chart
Minitab Moving Range Chart Run separately
©MMVI KnowWare International Inc. www.qimacros.com 20
![Page 21: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/21.jpg)
Control Chart Stability Rules QI Macros 2006 and Previous Versions are based on Montgomery's rules.
QI Macros 2007 - Lets you choose rules from various sources or customize your own. Montgomery's rules are used as the default rules.
©MMVI KnowWare International Inc. www.qimacros.com 21
![Page 22: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/22.jpg)
Minitab Attribute and Range Chart Rules
Minitab X chart Rules
©MMVI KnowWare International Inc. www.qimacros.com 22
![Page 23: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/23.jpg)
Control Chart Stability Tests
1 point above UCL
QI Macros
Minitab
©MMVI KnowWare International Inc. www.qimacros.com 23
![Page 24: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/24.jpg)
1 point below LCL QI Macros
Minitab
©MMVI KnowWare International Inc. www.qimacros.com 24
![Page 25: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/25.jpg)
2 out of 3 points above 2 sigma QI Macros
Minitab - does not perform this test on attribute charts
©MMVI KnowWare International Inc. www.qimacros.com 25
![Page 26: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/26.jpg)
2 out of 3 points below -2 sigma
QI Macros
Minitab - does not perform this test on attribute charts
©MMVI KnowWare International Inc. www.qimacros.com 26
![Page 27: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/27.jpg)
4 out of 5 points above 1 sigma QI Macros
Minitab - does not perform this test on attribute charts
©MMVI KnowWare International Inc. www.qimacros.com 27
![Page 28: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/28.jpg)
4 out of 5 points below - 1 sigma
QI Macros
Minitab - does not perform this test on attribute charts
©MMVI KnowWare International Inc. www.qimacros.com 28
![Page 29: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/29.jpg)
8 points in a row above Center Line -
Minitab - uses 9 points not 8 (QI Macros - set to Juran rules to use 9)
©MMVI KnowWare International Inc. www.qimacros.com 29
![Page 30: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/30.jpg)
8 points in a row below Center Line QI Macros
Minitab - uses 9 points not 8 (QI Macros - set to Juran rules to use 9)
©MMVI KnowWare International Inc. www.qimacros.com 30
![Page 31: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/31.jpg)
6 points in a row increasing QI Macros
Minitab - will not turn this condition red until the 7th point and then will only turn the 7th and additional points red
©MMVI KnowWare International Inc. www.qimacros.com 31
![Page 32: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/32.jpg)
6 points in a row decreasing QI Macros
Minitab - will not turn this condition red until the 7th point and then will only turn the 7th and additional points red
©MMVI KnowWare International Inc. www.qimacros.com 32
![Page 33: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/33.jpg)
15 points in a row inside =- 1 sigma (hugging) QI Macros
Minitab - does not perform this test on attribute charts
©MMVI KnowWare International Inc. www.qimacros.com 33
![Page 34: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/34.jpg)
14 points in a row alternating up and down QI Macros
Minitab - will not turn this condition red until the 15th point and then will only turn the 15th and additional points red
©MMVI KnowWare International Inc. www.qimacros.com 34
![Page 35: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/35.jpg)
8 points in a row outside =- 1 sigma
Minitab - does not perform this test on attribute charts
©MMVI KnowWare International Inc. www.qimacros.com 35
![Page 36: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/36.jpg)
Histograms and Capability Analysis Explanation of Differences Standard Deviation calculation. The QI Macros uses the standard deviation calculation of Microsoft Excel. Minitab uses a different calculation which returns slightly different results. The standard deviation difference will cause slight differences in the following calculations: Pp, Ppk, Z score and Expected PPM Data Source: Montgomery, Intro to SPC, 4th Ed., pgs. 353-358 USL = 346 LSL = 200
©MMVI KnowWare International Inc. www.qimacros.com 36
![Page 37: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/37.jpg)
QI Macros Histogram - increase decimals on data in Hist data sheet from 1 to 2 to more easily compare results.
Minitab Histogram
©MMVI KnowWare International Inc. www.qimacros.com 37
![Page 38: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/38.jpg)
Second Histogram with Different Cp and Pp, Cpk and Ppk Data Source: Montgomery Intro to SPC (5th) pg 200 USL = 2 LSL = 1
©MMVI KnowWare International Inc. www.qimacros.com 38
![Page 39: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/39.jpg)
QI Macros Histogram
Minitab Histogram
©MMVI KnowWare International Inc. www.qimacros.com 39
![Page 40: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/40.jpg)
QI Macros Frequency Histogram
Minitab Capability Analysis
©MMVI KnowWare International Inc. www.qimacros.com 40
![Page 41: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/41.jpg)
QI Macros X chart Templates using Data set 1
Minitab Capability Six Pack
©MMVI KnowWare International Inc. www.qimacros.com 41
![Page 42: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/42.jpg)
Pareto Chart QI Macros Pareto Chart
Minitab Pareto Chart
©MMVI KnowWare International Inc. www.qimacros.com 42
![Page 43: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/43.jpg)
Run Chart QI Macros Run Chart
Minitab Run Chart
©MMVI KnowWare International Inc. www.qimacros.com 43
![Page 44: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/44.jpg)
Scatter Diagram
QI Macros Scatter Diagram and Metrics on Calculation sheet
Minitab Scatter Diagram
©MMVI KnowWare International Inc. www.qimacros.com 44
![Page 45: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/45.jpg)
Box and Whisker
QI Macros Box and Whisker
Minitab Box and Whisker
©MMVI KnowWare International Inc. www.qimacros.com 45
![Page 46: QIMacros Test Results](https://reader034.vdocuments.us/reader034/viewer/2022052317/55cf99b2550346d0339eb4ac/html5/thumbnails/46.jpg)
Multivari Chart QI Macros
Minitab - no Multivari chart
©MMVI KnowWare International Inc. www.qimacros.com 46