SPC八大控制图自动生成表

1、通往初始面板X-RX-R、X-SX-S、中中位位数数图图数数据据登登入入表表规范标准值上限值 USL117.500请将数据登入在白色方格内，若显红色则超上差，显蓝色则超下差。生成X-R图中心限 CL115.000下限值 LSL112.500子子组组编编号号12345678910111213样样品品编编号号实实际际测测量量值值1115.45116.45115.78115.36115.23114.56113.89114.56115.22115.85114.95115.28114.282115.27115.89115.26116.89114.62113.96114.26114.58115.34115

2、.86113.98115.26115.263115.89116.24115.24116.26114.28113.52114.31114.59115.36115.82114.06114.26115.074113.26114.95115.28114.28115.26115.98114.62113.75114.98115.84114.85114.86113.005115.04115.24116.85116.89116.27115.88115.26115.06115.04115.64114.26114.58115.34生成控制图数据清零生成X-S图生成中位数图清除输入数据141516171819202

3、122232425114.29115.21115.37115.48115.63115.26115.89115.01115.24115.24113.85115.31114.68115.04116.03115.75116.85116.24116.48116.96115.34116.35113.65116.24114.86115.04115.24115.99116.89116.27116.24116.89114.26115.24114.52114.61114.00115.00116.00116.05116.24115.26115.97115.34116.35115.24114.85116.89113

4、.98112.96115.26116.48115.06115.04116.03114.98114.26115.07114.86116.35X-RX-R、X-SX-S、中中位位数数图图数数据据登登入入表表通往初始面板单单值值和和移移动动全全距距X-MRX-MR图图数数据据登登入入表表规规范范标标准准值值生成控制图上上限限值值 USLUSL200请将数据登入在白色方格内，若显红色则超上差，显蓝色则超下差。生成X-MR图(批次在50以内)中中心心限限 CLCL150下下限限值值 LSLLSL100批批次次号号123456789101112样样本本测测量量值值112.00151.00312.00321

5、.00123.0012.0012.00321.00123.00155.00131.00412.00批批次次号号262728293031323334353637样样本本测测量量值值112.00151.00312.00321.00112.00151.00312.00321.00123.0012.00412.00132.00批批次次号号515253545556575859606162样样本本测测量量值值112.00151.00312.00321.00123.0012.00144.00412.00132.00111.00121.00114.00批批次次号号76777879808182838485868

6、7样样本本测测量量值值112.00151.00312.00321.00123.0012.00112.00151.00312.00321.00123.0012.00数据清零生成X-MR图(批次大于50)清除输入数据13141516171819202122232425121.00144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.0038394041424344454647484950111.00121.00114.00161.00166.00162.00112.00151.00312.00321.00123.

7、0012.0012.0063646566676869707172737475161.00166.00162.00162.00123.00123.00112.00151.00312.00321.00123.0012.0021.00888990919293949596979899100121.00144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.00单单值值和和移移动动全全距距X-MRX-MR图图数数据据登登入入表表生成控制图通往初始面板P P图图、U U图图数数据据登登入入表表生成控制图生成P图(子组数在5

8、0以内)请将数据登入在白色方格内生成P图(子组数大于50)子子组组编编号号1234567891011子子组组容容量量50607080901009010231232不不良良品品数数量量/ /缺缺陷陷数数量量12325111224子子组组编编号号2627282930313233343536子子组组容容量量4354244354522634421211不不良良品品数数量量/ /缺缺陷陷数数量量34124212412子子组组编编号号5152535455565758596061子子组组容容量量3546676589766552623626不不良良品品数数量量/ /缺缺陷陷数数量量32233217131子子组

9、组编编号号7677787980818283848586子子组组容容量量2423123254432352352353不不良良品品数数量量/ /缺缺陷陷数数量量33231722344生成U图(子组数在50以内)数据清零清除输入数据生成U图(子组数大于50)121314151617181920212223242523435423242343234312324312324212123412141237383940414243444546474849503534541211324433544433222839531157215523226263646566676869707172737475623453

10、32245322342423432234532122334211315587888990919293949596979899100456464346434544466456463909013721323212755P P图图、U U图图数数据据登登入入表表生成控制图通往初始面板nPnP图图、C C图图数数据据登登入入表表生成控制图生成nP图(子组数在50以内)固固定定子子组组容容量量150请将数据登入在白色方格内生成nP图(子组数大于50)子子组组编编号号1234567891011不不良良品品数数量量/ /缺缺陷陷数数量量1215201222151417171720子子组组编编号号262728

11、2930313233343536不不良良品品数数量量/ /缺缺陷陷数数量量1112131421182021231511子子组组编编号号5152535455565758596061不不良良品品数数量量/ /缺缺陷陷数数量量13412132121234223子子组组编编号号7677787980818283848586不不良良品品数数量量/ /缺缺陷陷数数量量45686235636生成C图(子组数在50以内)数据清零清除输入数据生成C图(子组数大于50)12131415161718192021222324251222152012221514141313121211373839404142434445

12、46474849501024415161182967121156263646566676869707172737475211112112976867238788899091929394959697989910042346235324634nPnP图图、C C图图数数据据登登入入表表生成控制图返回X-RX-R、X-SX-S、中中位位数数图图数数据据运运算算表表子组内计算批次号12345678910111213X574.910578.770578.410579.680575.660573.900572.340572.540575.940579.010572.100574.240572.950X11

13、4.982115.754115.682115.936115.132114.780114.468114.508115.188115.802114.420114.848114.590X115.270115.890115.280116.260115.230114.560114.310114.580115.220115.840114.260114.860115.070R2.6301.5001.6102.6101.9902.4601.3701.3100.3800.2200.9701.0202.340S1.0120.6420.6911.1180.7601.1130.5130.4730.1720.0920.

14、4510.4400.983X266108.4066996.5966913.5367210.7866279.2065877.2065515.6765561.3066341.5067050.5565460.5065951.0965658.21总样本合计X-RX和R的中位数图子组容量 n5.0000R=1.513R=总组数 Count25.0000R=37.820R=总样本数 N125.0000上限值 UCL (X)116.116上限值 UCL (X)平均值 X115.2433中心限 CL (X)115.243中心限 CL (X)最大值 Max X116.9600下限值 LCL (X)114.370

15、下限值 LCL (X)最小值 Min X112.9600上限值 UCL (R)3.198上限值 UCL (R)平均中位数 Mid X115.2572中心限 CL (R)1.513中心限 CL (R)规范上限 USL117.5000下限值 LCL (R)0.000下限值 LCL (R)中心限 CL115.0000预估不良率(PPM)272.740预估不良率(PPM)规范下限 LSL112.5000 Std.Dev.=0.875 Std.Dev.=偏度 Skewness-0.1448Sigma=0.650Sigma=峰度 Kurtosis-0.1734Pp=0.953Pp=X14405.4100P

16、pk=0.860Ppk=X21660221.5349Ca=9.73%Ca=Cp=1.281Cp=CPU=1.157CPU=运算符号=CPL=1.406CPL=Cpk=1.157Cpk=Grade=CGrade=平方矩阵批次号12345678910111213 样品测量值的平方113328.7013560.6013405.0113307.9313277.9513123.9912970.9313123.9913275.6513421.2213213.5013289.4813059.92213287.1713430.4913284.8713663.2713137.7412986.8813055.35

17、13128.5813303.3213423.5412991.4413284.8713284.87313430.4913511.7413280.2613516.3913059.9212886.7913066.7813130.8713307.9313414.2713009.6813055.3513241.10412827.8313213.5013289.4813059.9213284.8713451.3613137.7412939.0613220.4013418.9113190.5213192.8212769.00513234.2013280.2613653.9213663.2713518.711

18、3428.1713284.8713238.8013234.2013372.6113055.3513128.5813303.32X-RMinMax柱状图坐标组界频率左边计算组界起点110.691119.7961110.3650=110.668891923187LCL/UCL (X)114.370116.1163110.9720=110.972405824018LSL/USL112.500117.5004111.2760=111.275919724857Sigma110.691119.7965111.5790=111.5794336256816111.8830=111.882947526512X-

19、R7112.1860=112.186461427343Delta0.3048112.4900=112.489975328174乘数系数37.9399112.7930=112.793489229005画线长度标记31.90010113.0972=113.09700312983711113.4011=113.40051703066812113.7042=113.70403093149913114.0087=114.0075448323314114.31111=114.31105873316115114.6157=114.61457263399216114.9188=114.918086534824

20、17115.22217=115.22160043565518115.52529=115.52511433648619115.8295=115.82862823731720116.13214=116.13214213814821116.43611=116.4356560389822116.7393=116.73916993981123117.0438=117.04268384064224117.3460=117.34619774147325117.6500=117.64971164230426117.9530=117.95322554313527118.2570=118.256739443967

21、28118.5600=118.56025334479829118.8640=118.86376724562930119.1670=119.1672811464631119.4710=119.470795047291越界0中位数MinMax柱状图坐标组界频率左边计算组界起点110.704119.8101110.3790=110.682811923187LCL/UCL (X)114.212116.3033110.9860=110.986325824018LSL/USL112.500117.5004111.2900=111.2898397248497Sigma110.704119.8105111.5

22、930=111.5933536256816111.8970=111.896867526512中位数7112.2000=112.200381427343Delta0.3048112.5040=112.503895328174乘数系数37.9399112.8070=112.807409229005画线长度标记30.80010113.1112=113.11092312983711113.4141=113.41443703066812113.7182=113.71795093149913114.0217=114.0214648323314114.32511=114.32497873316115114.

23、6289=114.62849263399216114.9326=114.93200653482417115.23618=115.23552043565518115.53928=115.53903433648619115.8436=115.84254823731720116.14613=116.14606213814821116.45011=116.4495760389822116.7533=116.75308993981123117.0578=117.05660384064224117.3600=117.36011774147325117.6640=117.66363164230426117.

24、9670=117.96714554313527118.2710=118.27065944396728118.5740=118.57417334479829118.8780=118.87768724562930119.1810=119.1812011464631119.4850=119.484715047291越界0X-SMinMax柱状图坐标组界频率左边计算组界起点110.456120.0311110.1140=110.432874214183LCL/UCL (X)114.326116.1613110.7520=110.752048057792LSL/USL112.500117.5004111

25、.0710=111.0712219014017Sigma110.456120.0315111.3900=111.3903957450096111.7100=111.709569588618X-S7112.0290=112.028743432227Delta0.3198112.3480=112.347917275835乘数系数39.8979112.6670=112.667091119444画线长度标记31.90010112.9861=112.98626496305311113.3052=113.30543880666112113.6251=113.6246126502713113.9444=11

26、3.94378649387914114.26310=114.26296033748815114.58210=114.58213418109616114.90110=114.90130802470517115.22017=115.22048186831418115.54029=115.53965571192219115.8597=115.85882955553120116.17812=116.1780033991421116.49714=116.49717724274822116.8160=116.81635108635723117.1368=117.13552492996624117.4550

27、=117.45469877357425117.7740=117.77387261718326118.0930=118.09304646079227118.4120=118.41222030440128118.7310=118.73139414800929119.0510=119.05056799161830119.3700=119.36974183522731119.6890=119.688915678835越界0141516171819202122232425571.810573.250577.900579.750580.670578.070580.610579.180575.450577.

28、140571.730579.400114.362114.650115.580115.950116.134115.614116.122115.836115.090115.428114.346115.880114.290115.040115.370115.990116.240115.260116.030115.340115.240115.240114.520116.2400.8802.2500.7901.0001.8301.2300.5901.9802.0901.2801.2102.2800.3970.9480.4000.3720.7910.5920.2381.0040.8730.5210.565

29、0.90965393.9765726.7166794.3267222.5767438.0366834.3967421.8267093.9366231.5966619.2065376.3267144.18X-S1.513S=0.64337.820S=16.073116.303上限值 UCL (X)116.161115.257中心限 CL (X)115.243114.212下限值 LCL (X)114.3263.198上限值 UCL (S)1.3431.513中心限 CL (S)0.6430.000下限值 LCL (S)0.000293.160预估不良率(PPM)514.4020.875 Std.

30、Dev.=0.8750.650Sigma=0.6840.953Pp=0.9530.855Ppk=0.86010.29%Ca=9.73%1.281Cp=1.2181.149CPU=1.1001.413CPL=1.3371.149Cpk=1.100CGrade=C14151617181920212223242513062.2013273.3413310.2413335.6313370.3013284.8713430.4913227.3013280.2613280.2612961.8213296.4013151.5013234.2013462.9613398.0613653.9213511.7413

31、567.5913679.6413303.3213537.3212916.3213511.7413192.8213234.2013280.2613453.6813663.2713518.7113511.7413663.2713055.3513280.2613114.8313135.4512996.0013225.0013456.0013467.6013511.7413284.8713449.0413303.3213537.3213280.2613190.5213663.2712991.4412759.9613284.8713567.5913238.8013234.2013462.9613220.

32、4013055.3513241.1013192.8213537.32右边正态线坐标 XNormal标记线坐标n*SigmaLengthX-RX-R、X-SX-S、中中位位数数图图数数据据运运算算表表左边1110.3650.0001111.3410.000=110.3653780223562110.4260.0002111.34122.330=110.6688919231873110.4870.0003111.3410.000=110.9724058240184110.5470.0004111.9910.000=111.275919724855110.6080.0005111.99122.330

33、=111.5794336256816110.6690.0006111.9910.000=111.8829475265127110.7300.0007112.6420.000=112.1864614273438110.7900.0008112.64222.330=112.4899753281749110.8510.0009112.6420.000=112.79348922900510110.9120.00010113.2920.000=113.09700312983711110.9720.00011113.29222.330=113.40051703066812111.0330.00012113

34、.2920.000=113.70403093149913111.0940.00013113.9430.000=114.0075448323314111.1550.00014113.94322.330=114.31105873316115111.2150.00015113.9430.000=114.61457263399216111.2760.00016114.5930.000=114.91808653482417111.3370.00017114.59322.330=115.22160043565518111.3970.00018114.5930.000=115.525114336486191

35、11.4580.00019115.2430.000=115.82862823731720111.5190.00020115.24335.090X=116.13214213814821111.5790.00021115.2430.000=116.4356560389822111.6400.00022115.8940.000=116.73916993981123111.7010.00023115.89422.330=117.04268384064224111.7620.00024115.8940.000=117.34619774147325111.8220.00025116.5440.000=11

36、7.64971164230426111.8830.00026116.54422.330=117.95322554313527111.9440.00027116.5440.000=118.25673944396728112.0040.00028117.1940.000=118.56025334479829112.0650.00029117.19422.330=118.86376724562930112.1260.00030117.1940.000=119.1672811464631112.1860.00031117.8450.00032112.2470.00132117.84522.330331

37、12.3080.00133117.8450.00034112.3690.00134118.4950.00035112.4290.00235118.49522.33036112.4900.00336118.4950.00037112.5510.00437119.1460.00038112.6110.00638119.14622.33039112.6720.00939119.1460.00040112.7330.01440117.5000.00041112.7930.01941117.50031.900USL42112.8540.02742117.5000.00043112.9150.038431

38、12.5000.00044112.9760.05344112.50031.900LSL45113.0360.07445112.5000.00046113.0970.10047113.1580.13648113.2180.18349113.2790.24350113.3400.32151113.4010.42052113.4610.54553113.5220.70154113.5830.89455113.6431.12956113.7041.41457113.7651.75658113.8252.16259113.8862.63860113.9473.19261114.0083.82862114

39、.0684.55063114.1295.36364114.1906.26565114.2507.25666114.3118.33167114.3729.482=110.668891923187=110.972405824018=111.27591972485=111.579433625681=111.882947526512=112.186461427343=112.489975328174=112.793489229005=113.097003129837=113.400517030668=113.704030931499=114.00754483233=114.311058733161=1

40、14.614572633992=114.918086534824=115.221600435655=115.525114336486=115.828628237317=116.132142138148=116.43565603898=116.739169939811=117.042683840642=117.346197741473=117.649711642304=117.953225543135=118.256739443967=118.560253344798=118.863767245629=119.16728114646=119.47079504729168114.43210.699

41、69114.49311.96770114.55413.26971114.61514.58572114.67515.89373114.73617.16874114.79718.38475114.85719.51676114.91820.53777114.97921.42578115.03922.15779115.10022.71580115.16123.08681115.22223.25982115.28223.23083115.34323.00084115.40422.57485115.46421.96586115.52521.18687115.58620.25888115.64719.202

42、89115.70718.04490115.76816.80891115.82915.52292115.88914.20993115.95012.89594116.01111.60095116.07110.34596116.1329.14697116.1938.01698116.2546.96499116.3145.998100116.3755.121101116.4364.335102116.4963.637103116.5573.025104116.6182.495105116.6782.039106116.7391.652107116.8001.327108116.8611.0571091

43、16.9210.834110116.9820.653111117.0430.507112117.1030.390113117.1640.297114117.2250.225115117.2850.168116117.3460.125117117.4070.092118117.4680.067119117.5280.049120117.5890.035121117.6500.025122117.7100.017123117.7710.012124117.8320.008125117.8930.006126117.9530.004127118.0140.003128118.0750.0021291

44、18.1350.001130118.1960.001131118.2570.001132118.3170.000133118.3780.000134118.4390.000135118.5000.000136118.5600.000137118.6210.000138118.6820.000139118.7420.000140118.8030.000141118.8640.000142118.9240.000143118.9850.000144119.0460.000145119.1070.000146119.1670.000147119.2280.000148119.2890.0001491

45、19.3490.000150119.4100.000151119.4710.000右边正态线坐标 XNormal标记线坐标n*SigmaLength1110.3790.0001111.3550.000=110.3792980223562110.4400.0002111.35521.560=110.6828119231873110.5010.0003111.3550.000=110.9863258240184110.5610.0004112.0050.000=111.2898397248495110.6220.0005112.00521.560=111.5933536256816110.6830

46、.0006112.0050.000=111.8968675265127110.7440.0007112.6560.000=112.2003814273438110.8040.0008112.65621.560=112.5038953281749110.8650.0009112.6560.000=112.80740922900510110.9260.00010113.3060.000=113.11092312983711110.9860.00011113.30621.560=113.41443703066812111.0470.00012113.3060.000=113.717950931499

47、13111.1080.00013113.9560.000=114.0214648323314111.1680.00014113.95621.560=114.32497873316115111.2290.00015113.9560.000=114.62849263399216111.2900.00016114.6070.000=114.93200653482417111.3510.00017114.60721.560=115.23552043565518111.4110.00018114.6070.000=115.53903433648619111.4720.00019115.2570.000=

48、115.84254823731720111.5330.00020115.25733.880X=116.14606213814821111.5930.00021115.2570.000=116.4495760389822111.6540.00022115.9080.000=116.75308993981123111.7150.00023115.90821.560=117.05660384064224111.7750.00024115.9080.000=117.36011774147325111.8360.00025116.5580.000=117.66363164230426111.8970.0

49、0026116.55821.560=117.96714554313527111.9580.00027116.5580.000=118.27065944396728112.0180.00028117.2080.000=118.57417334479829112.0790.00029117.20821.560=118.87768724562930112.1400.00030117.2080.000=119.1812011464631112.2000.00031117.8590.00032112.2610.00132117.85921.56033112.3220.00133117.8590.0003

50、4112.3820.00134118.5090.00035112.4430.00235118.50921.56036112.5040.00336118.5090.00037112.5650.00437119.1600.00038112.6250.00638119.16021.56039112.6860.00939119.1600.00040112.7470.01440117.5000.00041112.8070.01941117.50030.800USL42112.8680.02742117.5000.00043112.9290.03843112.5000.00044112.9900.0534

51、4112.50030.800LSL45113.0500.07445112.5000.00046113.1110.10047113.1720.136左边=110.682811923187=110.986325824018=111.289839724849=111.593353625681=111.896867526512=112.200381427343=112.503895328174=112.807409229005=113.110923129837=113.414437030668=113.717950931499=114.02146483233=114.324978733161=114.

52、628492633992=114.932006534824=115.235520435655=115.539034336486=115.842548237317=116.146062138148=116.44957603898=116.753089939811=117.056603840642=117.360117741473=117.663631642304=117.967145543135=118.270659443967=118.574173344798=118.877687245629=119119.48471504729148113.2320.1834911

53、3.2930.24350113.3540.32151113.4140.42052113.4750.54553113.5360.70154113.5970.89455113.6571.12956113.7181.41457113.7791.75658113.8392.16259113.9002.63860113.9613.19261114.0213.82862114.0824.55063114.1435.36364114.2046.26565114.2647.25666114.3258.33167114.3869.48268114.44610.69969114.50711.96770114.56

54、813.26971114.62814.58572114.68915.89373114.75017.16874114.81118.38475114.87119.51676114.93220.53777114.99321.42578115.05322.15779115.11422.71580115.17523.08681115.23623.25982115.29623.23083115.35723.00084115.41822.57485115.47821.96586115.53921.18687115.60020.25888115.66019.20289115.72118.04490115.78

55、216.80891115.84315.52292115.90314.20993115.96412.89594116.02511.60095116.08510.34596116.1469.14697116.2078.01698116.2676.96499116.3285.998100116.3895.121101116.4504.335102116.5103.637103116.5713.025104116.6322.495105116.6922.039106116.7531.652107116.8141.327108116.8741.057109116.9350.834110116.9960.

56、653111117.0570.507112117.1170.390113117.1780.297114117.2390.225115117.2990.168116117.3600.125117117.4210.092118117.4820.067119117.5420.049120117.6030.035121117.6640.025122117.7240.017123117.7850.012124117.8460.008125117.9060.006126117.9670.004127118.0280.003128118.0890.002129118.1490.001130118.2100.

57、001131118.2710.001132118.3310.000133118.3920.000134118.4530.000135118.5130.000136118.5740.000137118.6350.000138118.6960.000139118.7560.000140118.8170.000141118.8780.000142118.9380.000143118.9990.000144119.0600.000145119.1200.000146119.1810.000147119.2420.000148119.3030.000149119.3630.000150119.4240.

58、000151119.4850.000右边正态线坐标 XNormal标记线坐标n*SigmaLength1110.1140.0001111.1400.000=110.1137003705752110.1780.0002111.14022.330=110.4328742141833110.2410.0003111.1400.000=110.7520480577924110.3050.0004111.8240.000=111.0712219014015110.3690.0005111.82422.330=111.3903957450096110.4330.0006111.8240.000=111.7

59、095695886187110.4970.0007112.5080.000=112.0287434322278110.5610.0008112.50822.330=112.3479172758359110.6240.0009112.5080.000=112.66709111944410110.6880.00010113.1910.000=112.98626496305311110.7520.00011113.19122.330=113.30543880666112110.8160.00012113.1910.000=113.6246126502713110.8800.00013113.8750

60、.000=113.94378649387914110.9440.00014113.87522.330=114.26296033748815111.0070.00015113.8750.000=114.58213418109616111.0710.00016114.5590.000=114.90130802470517111.1350.00017114.55922.330=115.22048186831418111.1990.00018114.5590.000=115.53965571192219111.2630.00019115.2430.000=115.85882955553120111.3