Control Chart Process Limit Calculation
Six Sigma – iSixSigma › Forums › General Forums › Tools & Templates › Control Chart Process Limit Calculation
 This topic has 4 replies, 4 voices, and was last updated 4 months, 1 week ago by gunabalan.

AuthorPosts

May 6, 2021 at 9:40 am #253708
gunabalanParticipant@gunabalan Include @gunabalan in your post and this person will
be notified via email.The UCL (Upper Control Limit) and LCL (Lower Control Limit) for a numerical column calculated in excel is differ from the UCL and LCL calculated by minitab for the same numerical column.
The formula that is used in excel is
UCL = Mean + 2 * (S.D)
LCL = Mean – 2 * (S.D)This is the column:
col =
742
744
720
835
824
801
767
796
827
811
878
826
785
859
879
798
743
785
859
846
890
870
859
901
887
929
896
913
893
880
867
943
956
971
894
849
927
926
1037
902
997
897
888
768
757
831
835
837
831
849
788
748
839
791
839
806
889
866
865
937
967
900
919
934
842
810
877
886
1005
1036
1191
1090
1046
1147
1180
1042
1007
1002
951
950
950
928
953
858
767
789
713
760
713
709
655
664
674
665
706
734
760
759
679
643
661
697
771
776
799
780
712
777
814
792
751
770
776
724
777
803
792Excel UCL 1063.451853 Minitab UCL 922.7
Excel LCL 628.9584035 Minitab LCL 769.7
can anyone please clarify me why there is difference?
1May 6, 2021 at 1:58 pm #253718
Robert ButlerParticipant@rbutler Include @rbutler in your post and this person will
be notified via email.It looks like excel is just computing the standard deviation of the sample and then giving you the plus/minus 2 standard deviations of the sample whereas Minitab looks like it is computing USL and LSL spec limits
0May 7, 2021 at 8:59 pm #253750
StrayerParticipant@Straydog Include @Straydog in your post and this person will
be notified via email.The control limits per Shewhart are +/ 3 standard deviations from the mean and there is sound reasoning for this. You might inquire why whoever wrote the Excel formulas used a narrower range.
0May 10, 2021 at 6:22 am #253771
Benjamin SagalovskyParticipant@ben.i6 Include @ben.i6 in your post and this person will
be notified via email.Minitab does not use the formula for “s” that Excel uses for calculating those limits, it uses a different formula which is based on the values of the differences between adjacent points. You can see more at:
https://blog.minitab.com/en/marilynwheatleysblog/methodsandformulas3ahowareimrchartcontrollimitscalculatedThis is what Shewhart prescribed, and for good reason: you don’t want to take into acount the trends and longtime swings in the data, but the shorttime variation (common cause variation) so that anything that goes beyond shorttime variation is highlighted on the chart. For the same reason, you do not want to square values (which would give a strong influence to outliers) because you want an estimate of the standard deviation that makes outliers stand out.
Still, the esimate of SD that Minitab (Shewhart) uses is a ‘good’ (unbiased) estimator of the SD and would be very close to the one that Excel uses for large data sets, if there are no longterm trends or deterministic “swings” in the values.
1May 10, 2021 at 2:59 pm #253782
SavariaParticipant@Savaria Include @Savaria in your post and this person will
be notified via email.At an individual chart Minitab estimates sigma (std dev) by moving range. Calculate the mean of moving ranges by excel divide by d2 constant and you can receive the same std. dev value as was shown Minitab
1May 18, 2021 at 12:03 am #253931
gunabalanParticipant@gunabalan Include @gunabalan in your post and this person will
be notified via email.The link gives me detailed knowledge about this, thanks
0 
AuthorPosts
You must be logged in to reply to this topic.