SPC八大控制图自动生成表

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

2、39.00140.00141.00142.00143.00144.003161.00162.00163.00164.00165.00166.00167.00168.00169.00170.00171.0050.00173.00174.004101.00102.00103.00104.00105.00106.00107.00108.00250.00110.00111.00112.00113.00114.005131.00132.00133.00134.00135.00136.00137.00138.00139.00140.00141.00142.00143.00144.006161.00162.

3、00163.00164.00165.00166.00167.00168.00169.00170.00171.00172.00173.00174.007161.00162.00163.00164.00165.00166.00167.00168.00169.00170.0050.00172.00173.00174.008101.00102.00103.00104.00105.00106.00107.00108.00109.00110.00111.00112.00113.00114.009101.00102.00103.00104.00105.00106.00107.00108.00109.0011

4、0.00111.00112.00113.00114.00生成控制图数据清零生成X-S图生成中位数图清除输入数据15161718192021222324252627282930115.00116.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00130.00145.00146.00147.0040.00149.00150.00151.00152.00153.00154.00155.00156.00157.00158.00159.00160.00175.00176.00177.00178.

5、00179.00180.00181.00182.00183.00184.00185.00186.00187.00188.00189.00190.00115.00116.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00130.00145.00146.00147.00148.00149.00150.00151.00152.00153.00154.00155.00156.00157.00158.00159.00160.00300.00176.00177.00178.00179.00180.

6、00181.00182.00183.00184.00185.00186.00187.00188.00189.00190.00175.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00187.00188.00189.00190.00115.0050.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00130.00115.00116.00117.00300.00119.00120.00121.00122.0

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

8、0321.00123.00155.00131.00412.00121.00批批次次号号26272829303132333435363738样样本本测测量量值值112.00151.00312.00321.00112.00151.00312.00321.00123.0012.00412.00132.00111.00批批次次号号51525354555657585960616263样样本本测测量量值值112.00151.00312.00321.00123.0012.00144.00412.00132.00111.00121.00114.00161.00批批次次号号7677787980818283848

9、5868788样样本本测测量量值值112.00151.00312.00321.00123.0012.00112.00151.00312.00321.00123.0012.00121.00数据清零生成X-MR图(批次大于50)清除输入数据141516171819202122232425144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.00394041424344454647484950121.00114.00161.00166.00162.00112.00151.00312.00321.00123.0012

10、.0012.00646566676869707172737475166.00162.00162.00123.00123.00112.00151.00312.00321.00123.0012.0021.008990919293949596979899100144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.00单单值值和和移移动动全全距距X-MRX-MR图图数数据据登登入入表表生成控制图通往初始面板P P图图、U U图图数数据据登登入入表表生成控制图生成P图(子组数在50以内)生成U图(子组数在50以内)请将

11、数据登入在白色方格内生成P图(子组数大于50)生成U图(子组数大于50)子子组组编编号号123456789101112子子组组容容量量5060708090100901023123223不不良良品品数数量量/ /缺缺陷陷数数量量123251112244子子组组编编号号262728293031323334353637子子组组容容量量435424435452263442121135不不良良品品数数量量/ /缺缺陷陷数数量量341242124125子子组组编编号号515253545556575859606162子子组组容容量量354667658976655262362662不不良良品品数数量量/ /缺

12、缺陷陷数数量量322332171312子子组组编编号号767778798081828384858687子子组组容容量量242312325443235235235345不不良良品品数数量量/ /缺缺陷陷数数量量332317223441数据清零清除输入数据131415161718192021222324254354232423432343123243123221212341214123839404142434445464748495034541211324433544433222839311572155232263646566676869707172737475345332245322342423

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

14、262728293031323334353637不不良良品品数数量量/ /缺缺陷陷数数量量111213142118202123151110子子组组编编号号515253545556575859606162不不良良品品数数量量/ /缺缺陷陷数数量量1341213212123422321子子组组编编号号767778798081828384858687不不良良品品数数量量/ /缺缺陷陷数数量量456862356364生成C图(子组数在50以内)数据清零清除输入数据生成C图(子组数大于50)131415161718192021222324252215201222151414131312121138394

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

16、26.0001257.0001266.000X127.667128.667129.667130.667131.667132.667133.667134.667151.333157.778124.222125.111139.667140.667X131.000132.000133.000134.000135.000136.000137.000138.000139.000140.000111.000112.000143.000144.000R60.00060.00060.00060.00060.00060.00060.00060.000141.000190.000121.000122.00060.

17、00060.000S27.83927.83927.83927.83927.83927.83927.83927.83945.21159.32537.32937.57827.83927.839X2152889.00155196.00157521.00159864.00162225.00164604.00167001.00169416.00222468.00252200.00150028.00152172.00181761.00184284.00总样本合计X-RX和R的中位数图子组容量 n9.0000R=84.167R=84.167总组数 Count30.0000R=2525.000R=2525.0

18、00总样本数 N270.0000上限值 UCL (X)171.349上限值 UCL (X)178.177平均值 X142.9852中心限 CL (X)142.985中心限 CL (X)143.500最大值 Max X300.0000下限值 LCL (X)114.621下限值 LCL (X)108.823最小值 Min X40.0000上限值 UCL (R)152.847上限值 UCL (R)152.847平均中位数 Mid X143.5000中心限 CL (R)84.167中心限 CL (R)84.167规范上限 USL200.0000下限值 LCL (R)15.487下限值 LCL (R)1

19、5.487中心限 CL150.0000预估不良率(PPM)86771.407预估不良率(PPM)85484.310规范下限 LSL100.0000 Std.Dev.=34.603 Std.Dev.=34.603偏度 Skewness0.8966Sigma=28.339Sigma=28.339峰度 Kurtosis3.7034Pp=0.482Pp=0.482X38606.0000Ppk=0.414Ppk=0.419X25842180.0000Ca=14.03%Ca=13.00%Cp=0.588Cp=0.588CPU=0.671CPU=0.665运算符号=CPL=0.506CPL=0.512Cpk

20、=0.506Cpk=0.512Grade=EGrade=E平方矩阵批次号1234567891011121314 样品测量值的平方110201.0010404.0010609.0010816.0011025.0011236.0011449.0011664.0011881.0090000.0012321.0012544.0012769.0012996.00217161.0017424.0017689.0017956.0018225.0018496.0018769.0019044.0019321.0019600.0019881.0020164.0020449.0020736.00325921.002

21、6244.0026569.0026896.0027225.0027556.0027889.0028224.0028561.0028900.0029241.002500.0029929.0030276.00410201.0010404.0010609.0010816.0011025.0011236.0011449.0011664.0062500.0012100.0012321.0012544.0012769.0012996.00517161.0017424.0017689.0017956.0018225.0018496.0018769.0019044.0019321.0019600.001988

22、1.0020164.0020449.0020736.00625921.0026244.0026569.0026896.0027225.0027556.0027889.0028224.0028561.0028900.0029241.0029584.0029929.0030276.00725921.0026244.0026569.0026896.0027225.0027556.0027889.0028224.0028561.0028900.002500.0029584.0029929.0030276.00810201.0010404.0010609.0010816.0011025.0011236.

23、0011449.0011664.0011881.0012100.0012321.0012544.0012769.0012996.00910201.0010404.0010609.0010816.0011025.0011236.0011449.0011664.0011881.0012100.0012321.0012544.0012769.0012996.00X-RMinMax柱状图坐标组界频率左边计算组界起点-55.387341.3581-69.5570=-56.3320613542837LCL/UCL (X)114.621171.3493-43.1070=-43.1072203516649LS

24、L/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=49.46666666666661162.6923=62.69150766928541275.9160=75.91634

25、867190411389.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=194.93991769547322208.1650=208.16475869809223221.3900=221.38

26、959970071124234.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柱状图坐标组界频率左边计算组界起点-54.873341.8731-69.0420=-55.81724653

27、94688LCL/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.707936.7570=36.7566404788627画线长度标记58.3001049.9811=4

28、9.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.00505050505120182.23036=182.22989150766921195.45524=1

29、95.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.47830153385731327.7030=327.703142536476越界0X-SMinMax柱状图坐

30、标组界频率左边计算组界起点-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.2257551615275Delta15.9078-1.3180=-1.31828590724399乘数系数4

31、295.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.84893738130818157.75631=157.75640663559119173.66443=173

32、.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.83109917842629332.7390=332.7385684327130348.6460=348.64

33、603768699331364.5540=364.553506941277越界0151617181920212223242526272829301400.0001218.0001293.0001376.0001311.0001320.0001329.0001338.0001347.0001356.0001365.0001374.0001383.0001392.0001401.0001410.000155.556135.333143.667152.889145.667146.667147.667148.667149.667150.667151.667152.667153.667154.66715

34、5.667156.667145.000146.000147.000148.000149.000150.000151.000152.000153.000154.000155.000156.000157.000158.000159.000160.000185.000126.00060.000260.00060.00060.00060.00060.00060.00060.00060.00060.00060.00060.00060.00060.00059.60541.21927.83970.66927.83927.83927.83927.83927.83927.83927.83927.83927.83

35、927.83927.83927.839246200.00178428.00191961.00250328.00197169.00199800.00202449.00205116.00207801.00210504.00213225.00215964.00218721.00221496.00224289.00227100.00X-SS=33.041S=991.228上限值 UCL (X)147.347中心限 CL (X)142.985下限值 LCL (X)138.624上限值 UCL (S)58.185中心限 CL (S)33.041下限值 LCL (S)7.897预估不良率(PPM)15085

36、2.040 Std.Dev.=34.603Sigma=34.087Pp=0.482Ppk=0.414Ca=14.03%Cp=0.489CPU=0.558CPL=0.420Cpk=0.420Grade=E1516171819202122232425262728293013225.0013456.0013689.0013924.0014161.0014400.0014641.0014884.0015129.0015376.0015625.0015876.0016129.0016384.0016641.0016900.0021025.0021316.0021609.001600.0022201.00

37、22500.0022801.0023104.0023409.0023716.0024025.0024336.0024649.0024964.0025281.0025600.0030625.0030976.0031329.0031684.0032041.0032400.0032761.0033124.0033489.0033856.0034225.0034596.0034969.0035344.0035721.0036100.0013225.0013456.0013689.0013924.0014161.0014400.0014641.0014884.0015129.0015376.001562

38、5.0015876.0016129.0016384.0016641.0016900.0021025.0021316.0021609.0021904.0022201.0022500.0022801.0023104.0023409.0023716.0024025.0024336.0024649.0024964.0025281.0025600.0090000.0030976.0031329.0031684.0032041.0032400.0032761.0033124.0033489.0033856.0034225.0034596.0034969.0035344.0035721.0036100.00

39、30625.0030976.0031329.0031684.0032041.0032400.0032761.0033124.0033489.0033856.0034225.0034596.0034969.0035344.0035721.0036100.0013225.002500.0013689.0013924.0014161.0014400.0014641.0014884.0015129.0015376.0015625.0015876.0016129.0016384.0016641.0016900.0013225.0013456.0013689.0090000.0014161.0014400

40、.0014641.0014884.0015129.0015376.0015625.0015876.0016129.0016384.0016641.0016900.00X-RX-R、X-SX-S、中中位位数数图图数数据据运运算算表表84.1672525.000178.177143.500108.823152.84784.16715.48785484.31034.60328.3390.4820.41913.00%0.5880.6650.5120.512E右边正态线坐标 XNormal标记线坐标n*Sigma Length1-69.5570.0001-27.0480.000=-69.55690235

41、690242-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.000729.6290.000=9.792143658810248-51.0420.000829.62938.684=23.0169846

42、614299-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.0001486.30738.684=102.36603067714215-32.5270.0001586.3070.000=115

43、.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.71507669285421-16.6580.00021142.9850.000=194.93991769547322-14.0130.0002

44、2171.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.000=274.288963711186281.8570.00028228.0020.000=287.513804713805294.

45、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.00636284.6800.0003725.6620.01037313.0190.0003828.3070.01438313.01938.68

46、43930.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.3954957.4020.5265060.0470.6945162.6920.9085265.3361.1785367.9811.5

47、145470.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.48268107.65623.11069110.30125.84970112.94628.66171115.59131.50472118.23634.32973120.88137.08274123.52639.7097512

48、6.17142.15476128.81644.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.0579517

49、9.07022.34696181.71519.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.485115

50、231.9690.363116234.6140.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.000135

51、284.8690.000136287.5140.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*Sigma Length1-69.0420.0001

52、-26.5340.000=-69.04208754208762-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.0008

53、30.14440.810=23.53179947624399-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.01

54、30.0001586.8220.000=116.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.454

55、73251028822-13.4980.00022171.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.

56、000=288.02861952862295.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.000382

57、8.8220.01438313.53440.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.2944855.2710.3954957.9160.5265060.5610.6945163.2060.908

58、5265.8511.1785368.4961.5145471.1411.9305573.7862.4395676.4313.0555779.0763.7945881.7214.6705984.3665.6996087.0116.8946189.6568.2686292.3019.8296394.94611.5846497.59113.53365100.23615.67466102.88117.99567105.52620.48268108.17123.11069110.81625.84970113.46128.66171116.10631.50472118.75134.32973121.396

59、37.08274124.04139.70975126.68642.15476129.33144.36077131.97546.27778134.62047.85979137.26549.06580139.91049.86581142.55550.23982145.20050.17683147.84549.67984150.49048.76185153.13547.44486155.78045.76287158.42543.75788161.07041.47789163.71538.97590166.36036.30691169.00533.52792171.65030.69293174.295

60、27.85294176.94025.05795179.58522.34696182.23019.75697184.87517.31498187.52015.04399190.16512.956100192.81011.062101195.4559.363102198.1007.856103200.7456.535104203.3905.388105206.0354.405106208.6803.569107211.3252.867108213.9702.283109216.6141.802110219.2591.411111221.9041.094112224.5490.842113227.1