Estimate Standard Deviation Between/Within Subgroup
Six Sigma – iSixSigma › Forums › General Forums › Tools & Templates › Estimate Standard Deviation Between/Within Subgroup
 This topic has 6 replies, 5 voices, and was last updated 3 years, 1 month ago by Paul Keller.

AuthorPosts

August 6, 2019 at 8:32 pm #240860
Carlos GarciaParticipant@Manray Include @Manray in your post and this person will
be notified via email.I’m developing an Excel capability analysis data sheet but I have had some issues when I try to estimate standard deviation between/within subgroup (constant sample size) to calculate Cpk index. I need some help on calculations since the validation of Excel data sheet is not matching with the Minitab results.
Could someone help me on this?
Thanks in advance.
Attachments:
 XRControlChartFormRev01.xlsx
You must be signed in to download files.
 This topic was modified 3 years, 1 month ago by Carlos Garcia.
 This topic was modified 3 years, 1 month ago by Katie Barry.
 This topic was modified 3 years, 1 month ago by Katie Barry.
 This topic was modified 3 years, 1 month ago by Katie Barry.
0August 7, 2019 at 1:23 pm #240867
Chris SeiderParticipant@cseider Include @cseider in your post and this person will
be notified via email.Did you check the help section of Minitab? Pretty good info there but I wonder why not just use their awesome tools?
0August 7, 2019 at 4:43 pm #240879
Mike CarnellParticipant@MikeCarnell Include @MikeCarnell in your post and this person will
be notified via email.@Manray I got over 29,000,000 hits on Google in about .5 seconds. If you are using the same data set then you have a formula issue or so it would seem. I am sure if you contact the Minitab help line they can walk you through what they do.
0August 7, 2019 at 7:18 pm #240880
Chris SeiderParticipant@cseider Include @cseider in your post and this person will
be notified via email.August 12, 2019 at 12:54 pm #240980
Daniel AlfanoParticipant@dalfano Include @dalfano in your post and this person will
be notified via email.@Manray mira este archivo, puedes ver las formulas que usa Minitab para valores individuales y para subgrupos.
Saludos
Attachments:
 capabilityhwresuelto.xls
You must be signed in to download files.
0August 12, 2019 at 8:28 pm #240999
Paul KellerParticipant@[email protected] Include @[email protected] in your post and this person will
be notified via email.Hi Carlos,
You have a few things going on there. First, you shouldn’t use a Range chart to estimate variation for subgroup sizes >10. In fact, the subgroup standard deviation (i.e. Xbar Sigma chart) is always better. The Range chart was developed in the 1920’s before calculators or computers were prevalent, but better estimates are provided with the subgroup sigma nowadays.
Second, specification limits should never be shown on an XBar chart. The Xbar chart plots subgroup averages, and the specifications apply to individual data measurements. Consider for example the subgroup consisting of the numbers 7,8.12, 13. The average is 10. If the specs are 9 and 11, then all observations are outside the specifications but the plotted mean is not. Stated differently, the control limits on the Xbar chart are placed at +3 standard deviation of the subgroup averages. The standard deviation of the subgroup averages is the standard deviation of the process divided by the square root of the subgroup size (i.e. A2 = 1/(d2*SQRT(n)). For a subgroup size of 5, the control limits on the Xbar chart are only 44% as wide as the control limits for the observations (when a normal distribution is used for the individuals control chart), so we’d expect that the specs (or any observation) are well outside the Xbar control limits. It’s apples and ranges, so don’t put specs on the Xbar chart.
I didn’t go through all your calculations, and was going to paste the data into Minitab, but it doesn’t conveniently support the format you have. Instead, I’ve updated your file with a Sheet2 that shows two XBar Sigma charts developed with our SPC IV Excel software. (It’s only $299 so worth the hassle of trying to duplicate the formulas). The first “Standard XbarSigma Chart” shows the XBar chart out of control. In this case, I’m suspecting that the within subgroup variation is not a good predictor of the longer term variation. This can happen in a variety of processes. For example, if you create a subgroup out of 16 cavities in an injection molding process, you will have this issue. The control chart is developed by using the within subgroup variation to estimate the short term variation, which is then used to calculate the control limits, so that the control limits test if the longerterm variation is similar to the shortterm variation. In the injection molding example, the within subgroup variation is purely the differences between the cavities. It does not estimate shortterm variation, so we need to use something different.
The second chart shows a Batch Mean XBar Sigma chart. (Minitab calls this Between/Within). The Sigma chart shows the within subgroup variation, but the control limits on the XBar chart are based instead on the Moving Range between the subgroup averages. This provides a better estimate of shortterm variation than the within group standard deviation.
I hope this helps. Please let me know if you have any questions.
Attachments:
 XRControlChartFormRev011.xlsx
You must be signed in to download files.
0August 12, 2019 at 8:30 pm #241001
Paul KellerParticipant@[email protected] Include @[email protected] in your post and this person will
be notified via email.Better version of the charts attached.
Attachments:
 XRControlChartFormRev02.xlsx
You must be signed in to download files.
0  XRControlChartFormRev01.xlsx

AuthorPosts
You must be logged in to reply to this topic.