Expected QI Macros Results & Comparison To Minitab 17 Or Other .

6m ago
3 Views
1 Downloads
1.72 MB
18 Pages
Last View : 1m ago
Last Download : 3m ago
Upload by : Dahlia Ryals
Transcription

Expected QI Macros Results & Comparison to Minitab 17 or other Resources Table of Contents Chart Page # Control Charts Attribute Charts - c, u, p, np Variable Charts - Xmr, XbarR, XandS, XmedianR Histogram with Cp and Cpk Capability Suite Other Charts Cusum Moving Average EWMA Pareto Scatter Box and Whisker Normality Test/Descriptive Statistics 11 12 13 14 15 15 16 ANOVA (ANalysis Of VAriation) and t-Test 17 Appendix (Expected Differences) 18 MMVI KnowW are International Inc. https://ZZZ qimacros.com 2 6 7 7 1

Chart/data P Chart QI Macros for Excel Minitab AIAG SPC 2nd Edition page 88 MMVI KnowW are International Inc. https://www.qimacros.com 2

Pchart AIAG SPC 2nd Edition page 92 np Chart MMVI KnowW are International Inc. https://ZZZ qimacros.com 3

C Chart AIAG SPC 2nd Edition page 96 (This example displays the “show rule numbers” option.) MMVI KnowW are International Inc. https://ZZZ qimacros.com 4

u AIAG SPC 2nd Edition page 94 MMVI KnowW are International Inc. https://ZZZ qimacros.com 5

Chart/data XmR QI Macros Minitab AIAG SPC 2nd Edition page 86 MMVI KnowW are International Inc. https://ZZZ qimacros.com 6

Histogram AIAG SPC 2nd Edition page 86 Capability Suite AIAG SPC 2nd Edition page 86 MMVI KnowW are International Inc. https://www.qimacros.com 7

Chart/data XMedianR QI Macros for Excel Minitab Doesn’t have an XMedianR AIAG SPC 2nd Edition page 84 Histogram MMVI KnowW are International Inc. https://www.qimacros.com 8

Chart/data XbarR QI Macros for Excel Minitab AIAG SPC 2nd Edition page 78 Histogram MMVI KnowW are International Inc. https://www.qimacros.com 9

XbarS AIAG SPC 2nd Edition page 78 Capability Suite AIAG SPC 2nd Edition page 78 MMVI KnowW are International Inc. https://www.qimacros.com 10

Chart/data Cusum QI Macros for Excel Minitab Montgomery Intro to SPC 5th Edition, page 393 MMVI KnowW are International Inc. https://www.qimacros.com 11

QI Macros for Excel Moving Avg Xi - MA Chart Montgomer y Intro to SPC 4th Edition, page 438439 Minitab Moving Avg Xi - MA Chart Moving Average 15.150 14.150 13.150 12.150 11.150 10.150 9.150 8.150 7.150 6.150 UCL 12.313 CL 10.315 8.317 LCL S1 S3 S5 S7 S9 S11S13S15 S17S19S21S23S25 S27S29 Sample Number Minitab seems to calculate Stdev differently for MA Chart which results in different control limits. MMVI KnowW are International Inc. https://www.qimacros.com 12

Chart/data EWMA QI Macros for Excel MMVI KnowW are International Inc. https://www.qimacros.com Minitab 13

Pareto AIAG Spot Weld Flaws Run Chart MMVI KnowW are International Inc. https://www.qimacros.com 14

Box and Whisker Scatter MMVI KnowW are International Inc. https://www.qimacros.com 15

Descriptive Statistics and Normality MMVI KnowW are International Inc. https://www.qimacros.com 16

ANOVA t Test 2-sample Equal Variances MMVI KnowW are International Inc. https://www.qimacros.com 17

Appendix Expected Differences Stability Analysis Both QI Macros and Minitab let you define what stability rules you want to use. QI Macros defaults to Montgomery's rules but lets you select from Juran, AIAG, Westgard, Healthcare (IHI) and Western Electric rules. You can also further customize rules in QI Macros. See nalysis-control-chart-rules/ . Minitab requires you to define the rules you want to use each time you run a chart. QI Macros offer additional tests that Minitab does not. Minitab also treats trends differently than 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, 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 7 th point. Upper and Lower control limits on u, p, and XbarS 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. QI Macros displays 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 calculation 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. See formulas: is/cp-cpk-formula/ Per Juran and Montgomery, QI Macros uses a constant of 1.693 when there are 3 subgroups. It looks like Minitab is using something like 1.093. Cusum and Moving Average Chart Control Limits Control limits are slightly different because QI Macros uses standard deviation while Minitab uses sigma estimator. MMVI KnowW are International Inc. https://www.qimacros.com 18

to Minitab 17 or other Resources. Table of Contents. Chart Page # Control Charts Attribute Charts - c, u, p, np 2 Variable Charts - Xmr, XbarR, XandS, . Minitab displays the UCL and LCL for the last point. QI Macros displays the UCL and LCL for the 3rd to the last point. Note the control limit lines are the same, only the value displayed is .

Related Documents:

PSI AP Physics 1 Name_ Multiple Choice 1. Two&sound&sources&S 1∧&S p;Hz&and250&Hz.&Whenwe& esult&is:& (A) great&&&&&(C)&The&same&&&&&

Argilla Almond&David Arrivederci&ragazzi Malle&L. Artemis&Fowl ColferD. Ascoltail&mio&cuore Pitzorno&B. ASSASSINATION Sgardoli&G. Auschwitzero&il&numero&220545 AveyD. di&mare Salgari&E. Avventurain&Egitto Pederiali&G. Avventure&di&storie AA.&VV. Baby&sitter&blues Murail&Marie]Aude Bambini&di&farina FineAnna

The program, which was designed to push sales of Goodyear Aquatred tires, was targeted at sales associates and managers at 900 company-owned stores and service centers, which were divided into two equal groups of nearly identical performance. For every 12 tires they sold, one group received cash rewards and the other received

GROFF AND MOM: AN OVERVIEW Peter Schaffter Two categories of macros The macros in mom are grouped into two categories: typesetting macros and docu- ment processing macros . The typesetting macros assist with presentational markup and include basic oper- ations such as setting line lengths, establishing family and font, changing point size,

QI Macros will prompt you for titles. Just click OK for this example. Step 3 - Get the Chart QI Macros will perform the calculations and create the chart for you. Since this is an X chart for variable data, QI Macros will create both a Range Chart and an X Chart. QI Macros will also turn any unstable points or trends red.

simples como de tareas complejas. Las macros son muy útiles para repetir la misma tarea una y otra vez. Las macros de LibreOffice se escriben usualmente en un lenguaje llamado LibreOffice Basic, que algunas veces es abreviado como Basic. Aunque puede aprender Basic y escribir macros, escribir macros desde cero es una curva muy empinada.

College"Physics" Student"Solutions"Manual" Chapter"6" " 50" " 728 rev s 728 rpm 1 min 60 s 2 rad 1 rev 76.2 rad s 1 rev 2 rad , π ω π " 6.2 CENTRIPETAL ACCELERATION 18." Verify&that ntrifuge&is&about 0.50&km/s,∧&Earth&in&its& orbit is&about p;linear&speed&of&a .

theJazz&Band”∧&answer& musical&questions.&Click&on&Band .