SPC八大控制图自动生成器v1.01

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

2、.00141.00142.00143.003161.00162.00163.00164.00165.00166.00167.00168.00169.00170.00171.0050.00173.004101.00102.00103.00104.00105.00106.00107.00108.00250.00110.00111.00112.00113.005131.00132.00133.00134.00135.00136.00137.00138.00139.00140.00141.00142.00143.006161.00162.00163.00164.00165.00166.00167.00

3、168.00169.00170.00171.00172.00173.007161.00162.00163.00164.00165.00166.00167.00168.00169.00170.0050.00172.00173.008101.00102.00103.00104.00105.00106.00107.00108.00109.00110.00111.00112.00113.009101.00102.00103.00104.00105.00106.00107.00108.00109.00110.00111.00112.00113.00生成控制图数据清零生成X-S图生成中位数图清除输入数据1

4、4151617181920212223242526272829114.00115.00116.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00144.00145.00146.00147.0040.00149.00150.00151.00152.00153.00154.00155.00156.00157.00158.00159.00174.00175.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00

5、187.00188.00189.00114.00115.00116.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00144.00145.00146.00147.00148.00149.00150.00151.00152.00153.00154.00155.00156.00157.00158.00159.00174.00300.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00187.00188.00

6、189.00174.00175.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00187.00188.00189.00114.00115.0050.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00114.00115.00116.00117.00300.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00X-RX-R、

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

8、21.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批批次次号号767778798081828384858687样样本本测测量量值值112.00151

9、.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.0012.0012.0063646566

10、676869707172737475161.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图(子组数在50以内)请将数据登入在白色方格内生成P图

11、(子组数大于50)子子组组编编号号1234567891011子子组组容容量量50607080901009010231232不不良良品品数数量量/ /缺缺陷陷数数量量12325111224子子组组编编号号2627282930313233343536子子组组容容量量4354244354522634421211不不良良品品数数量量/ /缺缺陷陷数数量量34124212412子子组组编编号号5152535455565758596061子子组组容容量量3546676589766552623626不不良良品品数数量量/ /缺缺陷陷数数量量32233217131子子组组编编号号767778798081828

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

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

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

15、182967121156263646566676869707172737475211112112976867238788899091929394959697989910042346235324634nPnP图图、C C图图数数据据登登入入表表生成控制图返回X-RX-R、X-SX-S、中中位位数数图图数数据据运运算算表表子组内计算批次号12345678910111213X1149.0001158.0001167.0001176.0001185.0001194.0001203.0001212.0001362.0001420.0001118.0001126.0001257.000X127.66712

16、8.667129.667130.667131.667132.667133.667134.667151.333157.778124.222125.111139.667X131.000132.000133.000134.000135.000136.000137.000138.000139.000140.000111.000112.000143.000R60.00060.00060.00060.00060.00060.00060.00060.000141.000190.000121.000122.00060.000S27.83927.83927.83927.83927.83927.83927.839

17、27.83945.21159.32537.32937.57827.839X2152889.00 155196.00 157521.00 159864.00 162225.00 164604.00 167001.00 169416.00 222468.00 252200.00 150028.00 152172.00 181761.00总样本合计X-RX和R的中位数图子组容量 n9.0000R=84.167R=总组数 Count30.0000R=2525.000R=总样本数 N270.0000上限值 UCL (X)171.349上限值 UCL (X)平均值 X142.9852中心限 CL (X)1

18、42.985中心限 CL (X)最大值 Max X300.0000下限值 LCL (X)114.621下限值 LCL (X)最小值 Min X40.0000上限值 UCL (R)152.847上限值 UCL (R)平均中位数 Mid X143.5000中心限 CL (R)84.167中心限 CL (R)规范上限 USL200.0000下限值 LCL (R)15.487下限值 LCL (R)中心限 CL150.0000预估不良率(PPM)86771.407预估不良率(PPM)规范下限 LSL100.0000 Std.Dev.=34.603 Std.Dev.=偏度 Skewness0.8966Si

19、gma=28.339Sigma=峰度 Kurtosis3.7034Pp=0.482Pp=X38606.0000Ppk=0.414Ppk=X25842180.0000Ca=14.03%Ca=Cp=0.588Cp=CPU=0.671CPU=运算符号=CPL=0.506CPL=Cpk=0.506Cpk=Grade=EGrade=平方矩阵批次号12345678910111213 样品测量值的平方110201.0010404.0010609.0010816.0011025.0011236.0011449.0011664.0011881.0090000.0012321.0012544.0012769.00

20、217161.0017424.0017689.0017956.0018225.0018496.0018769.0019044.0019321.0019600.0019881.0020164.0020449.00325921.0026244.0026569.0026896.0027225.0027556.0027889.0028224.0028561.0028900.0029241.002500.0029929.00410201.0010404.0010609.0010816.0011025.0011236.0011449.0011664.0062500.0012100.0012321.0012

21、544.0012769.00517161.0017424.0017689.0017956.0018225.0018496.0018769.0019044.0019321.0019600.0019881.0020164.0020449.00625921.0026244.0026569.0026896.0027225.0027556.0027889.0028224.0028561.0028900.0029241.0029584.0029929.00725921.0026244.0026569.0026896.0027225.0027556.0027889.0028224.0028561.00289

22、00.002500.0029584.0029929.00810201.0010404.0010609.0010816.0011025.0011236.0011449.0011664.0011881.0012100.0012321.0012544.0012769.00910201.0010404.0010609.0010816.0011025.0011236.0011449.0011664.0011881.0012100.0012321.0012544.0012769.00X-RMinMax柱状图坐标组界频率左边计算组界起点-55.387341.3581-69.5570=-56.33206135

23、42837LCL/UCL (X)114.621171.3493-43.1070=-43.1072203516649LSL/USL100.000200.0004-29.8820=-29.88237934904617Sigma-55.387341.3585-16.6580=-16.65753834642736-3.4330=-3.43269734380854X-R79.7920=9.79214365881024Delta13.225823.0170=23.016984661429乘数系数3570.707936.2420=36.2418256640478画线长度标记55.2631049.4671=4

24、9.46666666666661162.6923=62.69150766928541275.9160=75.91634867190411389.1410=89.141189674522914102.3668=102.36603067714215115.59150=115.5908716797616128.81650=128.81571268237917142.04132=142.04055368499818155.26525=155.26539468761719168.49034=168.49023569023620181.71536=181.71507669285421194.94027=1

25、94.93991769547322208.1650=208.16475869809223221.3900=221.38959970071124234.6140=234.61444070332925247.8390=247.83928170594826261.0641=261.06412270856727274.2890=274.28896371118628287.5140=287.51380471380529300.7393=300.73864571642330313.9630=313.96348671904231327.1880=327.188327721661越界0中位数MinMax柱状图

26、坐标组界频率左边计算组界起点-54.873341.8731-69.0420=-55.8172465394688LCL/UCL (X)108.823178.1773-42.5920=-42.59240553685LSL/USL100.000200.0004-29.3680=-29.36756453423127Sigma-54.873341.8735-16.1430=-16.14272353161246-2.9180=-2.91788252899365中位数710.3070=10.3069584736251Delta13.225823.5320=23.5317994762439乘数系数3570.7

27、07936.7570=36.7566404788627画线长度标记58.3001049.9811=49.98148148148151163.2063=63.20632248410031276.4310=76.4311634867191389.6560=89.656004489337814102.8818=102.88084549195715116.10653=116.10568649457516129.33151=129.33052749719417142.55528=142.55536849981318155.78025=155.78020950243219169.00537=169.005

28、05050505120182.23036=182.22989150766921195.45524=195.45473251028822208.6800=208.67957351290723221.9040=221.90441451552624235.1290=235.12925551814425248.3540=248.35409652076326261.5791=261.57893752338227274.8040=274.80377852600128288.0290=288.0286195286229301.2533=301.25346053123830314.4780=314.47830

29、153385731327.7030=327.703142536476越界0X-SMinMax柱状图坐标组界频率左边计算组界起点-95.627381.5971-112.6710=-96.7631014329451LCL/UCL (X)138.624147.3473-80.8560=-80.8556321786616LSL/USL100.000200.0004-64.9480=-64.94816292437817Sigma-95.627381.5975-49.0410=-49.04069367009456-33.1330=-33.133224415811X-S7-17.2260=-17.22575

30、51615275Delta15.9078-1.3180=-1.31828590724399乘数系数4295.017914.5890=14.5891833470395画线长度标记63.8001030.4970=30.4966526013231146.4041=46.40412185560661262.3123=62.31159110989011378.2190=78.21906036417361494.1270=94.126529618457115110.03438=110.03399887274116125.94158=125.94146812702417141.84942=141.84893

31、738130818157.75631=157.75640663559119173.66443=173.66387588987520189.57147=189.57134514415821205.4793=205.47881439844222221.3860=221.38628365272523237.2940=237.29375290700924253.2011=253.20122216129225269.1090=269.10869141557626285.0160=285.01616066985927300.9243=300.92362992414328316.8310=316.83109

32、917842629332.7390=332.7385684327130348.6460=348.64603768699331364.5540=364.553506941277越界0141516171819202122232425262728291266.0001400.0001218.0001293.0001376.0001311.0001320.0001329.0001338.0001347.0001356.0001365.0001374.0001383.0001392.0001401.000140.667155.556135.333143.667152.889145.667146.6671

33、47.667148.667149.667150.667151.667152.667153.667154.667155.667144.000145.000146.000147.000148.000149.000150.000151.000152.000153.000154.000155.000156.000157.000158.000159.00060.000185.000126.00060.000260.00060.00060.00060.00060.00060.00060.00060.00060.00060.00060.00060.00027.83959.60541.21927.83970.

34、66927.83927.83927.83927.83927.83927.83927.83927.83927.83927.83927.839184284.00 246200.00 178428.00 191961.00 250328.00 197169.00 199800.00 202449.00 205116.00 207801.00 210504.00 213225.00 215964.00 218721.00 221496.00 224289.00X-S84.167S=33.0412525.000S=991.228178.177上限值 UCL (X)147.347143.500中心限 CL

35、 (X)142.985108.823下限值 LCL (X)138.624152.847上限值 UCL (S)58.18584.167中心限 CL (S)33.04115.487下限值 LCL (S)7.89785484.310预估不良率(PPM)150852.04034.603 Std.Dev.=34.60328.339Sigma=34.0870.482Pp=0.4820.419Ppk=0.41413.00%Ca=14.03%0.588Cp=0.4890.665CPU=0.5580.512CPL=0.4200.512Cpk=0.420EGrade=E1415161718192021222324

36、252627282912996.0013225.0013456.0013689.0013924.0014161.0014400.0014641.0014884.0015129.0015376.0015625.0015876.0016129.0016384.0016641.0020736.0021025.0021316.0021609.001600.0022201.0022500.0022801.0023104.0023409.0023716.0024025.0024336.0024649.0024964.0025281.0030276.0030625.0030976.0031329.00316

37、84.0032041.0032400.0032761.0033124.0033489.0033856.0034225.0034596.0034969.0035344.0035721.0012996.0013225.0013456.0013689.0013924.0014161.0014400.0014641.0014884.0015129.0015376.0015625.0015876.0016129.0016384.0016641.0020736.0021025.0021316.0021609.0021904.0022201.0022500.0022801.0023104.0023409.0

38、023716.0024025.0024336.0024649.0024964.0025281.0030276.0090000.0030976.0031329.0031684.0032041.0032400.0032761.0033124.0033489.0033856.0034225.0034596.0034969.0035344.0035721.0030276.0030625.0030976.0031329.0031684.0032041.0032400.0032761.0033124.0033489.0033856.0034225.0034596.0034969.0035344.00357

39、21.0012996.0013225.002500.0013689.0013924.0014161.0014400.0014641.0014884.0015129.0015376.0015625.0015876.0016129.0016384.0016641.0012996.0013225.0013456.0013689.0090000.0014161.0014400.0014641.0014884.0015129.0015376.0015625.0015876.0016129.0016384.0016641.00右边正态线坐标 XNormal标记线坐标n*SigmaLengthX-RX-R、

40、X-SX-S、中中位位数数图图数数据据运运算算表表左边1-69.5570.0001-27.0480.000=-69.55690235690242-66.9120.0002-27.04838.684=-56.33206135428373-64.2670.0003-27.0480.000=-43.10722035166494-61.6220.00041.2900.000=-29.88237934904615-58.9770.00051.29038.684=-16.65753834642736-56.3320.00061.2900.000=-3.432697343808547-53.6870.000

41、729.6290.000=9.792143658810248-51.0420.000829.62938.684=23.0169846614299-48.3970.000929.6290.000=36.241825664047810-45.7520.0001057.9680.000=49.466666666666611-43.1070.0001157.96838.684=62.691507669285412-40.4620.0001257.9680.000=75.916348671904113-37.8170.0001386.3070.000=89.141189674522914-35.1720

42、.0001486.30738.684=102.36603067714215-32.5270.0001586.3070.000=115.5908716797616-29.8820.00016114.6460.000=128.81571268237917-27.2370.00017114.64638.684=142.04055368499818-24.5920.00018114.6460.000=155.26539468761719-21.9470.00019142.9850.000=168.49023569023620-19.3030.00020142.98560.789X=181.715076

43、69285421-16.6580.00021142.9850.000=194.93991769547322-14.0130.00022171.3240.000=208.16475869809223-11.3680.00023171.32438.684=221.38959970071124-8.7230.00024171.3240.000=234.61444070332925-6.0780.00025199.6630.000=247.83928170594826-3.4330.00026199.66338.684=261.06412270856727-0.7880.00027199.6630.0

44、00=274.288963711186281.8570.00028228.0020.000=287.513804713805294.5020.00029228.00238.684=300.738645716423307.1470.00130228.0020.000=313.963486719042319.7920.00131256.3410.0003212.4370.00132256.34138.6843315.0820.00233256.3410.0003417.7270.00334284.6800.0003520.3720.00435284.68038.6843623.0170.00636

45、284.6800.0003725.6620.01037313.0190.0003828.3070.01438313.01938.6843930.9520.02039313.0190.0004033.5970.02940200.0000.0004136.2420.04241200.00055.263USL4238.8870.05942200.0000.0004341.5320.08343100.0000.0004444.1770.11544100.00055.263LSL4546.8220.15945100.0000.0004649.4670.2174752.1120.2944854.7570.

46、3954957.4020.5265060.0470.6945162.6920.9085265.3361.1785367.9811.5145470.6261.9305573.2712.4395675.9163.0555778.5613.7945881.2064.6705983.8515.6996086.4966.8946189.1418.2686291.7869.8296394.43111.5846497.07613.5336599.72115.67466102.36617.99567105.01120.482=-56.3320613542837=-43.1072203516649=-29.88

47、23793490461=-16.6575383464273=-3.43269734380854=9.79214365881024=23.016984661429=36.2418256640478=49.4666666666666=62.6915076692854=75.9163486719041=89.1411896745229=102.366030677142=115.59087167976=128.815712682379=142.040553684998=155.265394687617=168.490235690236=181.715076692854=194.939917695473

48、=208.164758698092=221.389599700711=234.614440703329=247.839281705948=261.064122708567=274.288963711186=287.513804713805=300.738645716423=313.963486719042=327.18832772166168107.65623.11069110.30125.84970112.94628.66171115.59131.50472118.23634.32973120.88137.08274123.52639.70975126.17142.15476128.8164

49、4.36077131.46146.27778134.10647.85979136.75149.06580139.39649.86581142.04150.23982144.68650.17683147.33049.67984149.97548.76185152.62047.44486155.26545.76287157.91043.75788160.55541.47789163.20038.97590165.84536.30691168.49033.52792171.13530.69293173.78027.85294176.42525.05795179.07022.34696181.7151

50、9.75697184.36017.31498187.00515.04399189.65012.956100192.29511.062101194.9409.363102197.5857.856103200.2306.535104202.8755.388105205.5204.405106208.1653.569107210.8102.867108213.4552.283109216.1001.802110218.7451.411111221.3901.094112224.0350.842113226.6800.642114229.3250.485115231.9690.363116234.61

51、40.270117237.2590.199118239.9040.145119242.5490.105120245.1940.075121247.8390.054122250.4840.038123253.1290.026124255.7740.018125258.4190.013126261.0640.009127263.7090.006128266.3540.004129268.9990.003130271.6440.002131274.2890.001132276.9340.001133279.5790.000134282.2240.000135284.8690.000136287.51

52、40.000137290.1590.000138292.8040.000139295.4490.000140298.0940.000141300.7390.000142303.3840.000143306.0290.000144308.6740.000145311.3190.000146313.9630.000147316.6080.000148319.2530.000149321.8980.000150324.5430.000151327.1880.000右边正态线坐标 XNormal标记线坐标n*SigmaLength1-69.0420.0001-26.5340.000=-69.04208

53、754208762-66.3970.0002-26.53440.810=-55.81724653946883-63.7520.0003-26.5340.000=-42.592405536854-61.1070.00041.8050.000=-29.36756453423125-58.4620.00051.80540.810=-16.14272353161246-55.8170.00061.8050.000=-2.917882528993657-53.1720.000730.1440.000=10.30695847362518-50.5270.000830.14440.810=23.531799

54、47624399-47.8820.000930.1440.000=36.756640478862710-45.2370.0001058.4830.000=49.981481481481511-42.5920.0001158.48340.810=63.206322484100312-39.9470.0001258.4830.000=76.43116348671913-37.3020.0001386.8220.000=89.656004489337814-34.6580.0001486.82240.810=102.88084549195715-32.0130.0001586.8220.000=11

55、6.10568649457516-29.3680.00016115.1610.000=129.33052749719417-26.7230.00017115.16140.810=142.55536849981318-24.0780.00018115.1610.000=155.78020950243219-21.4330.00019143.5000.000=169.00505050505120-18.7880.00020143.50064.130X=182.22989150766921-16.1430.00021143.5000.000=195.45473251028822-13.4980.00

56、022171.8390.000=208.67957351290723-10.8530.00023171.83940.810=221.90441451552624-8.2080.00024171.8390.000=235.12925551814425-5.5630.00025200.1780.000=248.35409652076326-2.9180.00026200.17840.810=261.57893752338227-0.2730.00027200.1780.000=274.803778526001282.3720.00028228.5170.000=288.02861952862295

57、.0170.00029228.51740.810=301.253460531238307.6620.00130228.5170.000=314.4783015338573110.3070.00131256.8560.0003212.9520.00132256.85640.8103315.5970.00233256.8560.0003418.2420.00334285.1950.0003520.8870.00435285.19540.8103623.5320.00636285.1950.0003726.1770.01037313.5340.0003828.8220.01438313.53440.

58、8103931.4670.02039313.5340.0004034.1120.02940200.0000.0004136.7570.04241200.00058.300USL4239.4020.05942200.0000.0004342.0470.08343100.0000.0004444.6920.11544100.00058.300LSL4547.3370.15945100.0000.0004649.9810.2174752.6260.294左边=-55.8172465394688=-42.59240553685=-29.3675645342312=-16.1427235316124=-

59、2.91788252899365=10.3069584736251=23.5317994762439=36.7566404788627=49.9814814814815=63.2063224841003=76.431163486719=89.6560044893378=102.880845491957=116.105686494575=129.330527497194=142.555368499813=155.780209502432=169.005050505051=182.229891507669=195.454732510288=208.679573512907=221.90441451

60、5526=235.129255518144=248.354096520763=261.578937523382=274.803778526001=288.02861952862=301.253460531238=314.478301533857=327.7031425364764855.2710.3954957.9160.5265060.5610.6945163.2060.9085265.8511.1785368.4961.5145471.1411.9305573.7862.4395676.4313.0555779.0763.7945881.7214.6705984.3665.6996087.