SPC八大控制图自动生成表(系统)表格文件下载.xls
- 文档编号:5164778
- 上传时间:2023-05-04
- 格式:XLS
- 页数:224
- 大小:4.09MB
SPC八大控制图自动生成表(系统)表格文件下载.xls
《SPC八大控制图自动生成表(系统)表格文件下载.xls》由会员分享,可在线阅读,更多相关《SPC八大控制图自动生成表(系统)表格文件下载.xls(224页珍藏版)》请在冰点文库上搜索。
通往初始面板X-R、X-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.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.00168.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图生成中位数图清除输入数据14151617181920212223242526272829114.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.00187.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.00189.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-R、X-S、中中位位数数图图数数据据登登入入表表30130.00160.00190.00130.00160.00190.00190.00130.00130.00通往初始面板单单值值和和移移动动全全距距X-MR图图数数据据登登入入表表规规范范标标准准值值生成控制图上上限限值值USL200请将数据登入在白色方格内,若显红色则超上差,显蓝色则超下差。
@#@生成X-MR图(批次在50以内)中中心心限限CL150下下限限值值LSL100批批次次号号123456789101112样样本本测测量量值值112.00151.00312.00321.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批批次次号号767778798081828384858687样样本本测测量量值值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.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-MR图图数数据据登登入入表表生成控制图通往初始面板P图图、U图图数数据据登登入入表表生成控制图生成P图(子组数在50以内)请将数据登入在白色方格内生成P图(子组数大于50)子子组组编编号号1234567891011子子组组容容量量50607080901009010231232不不良良品品数数量量/缺缺陷陷数数量量12325111224子子组组编编号号2627282930313233343536子子组组容容量量4354244354522634421211不不良良品品数数量量/缺缺陷陷数数量量34124212412子子组组编编号号5152535455565758596061子子组组容容量量3546676589766552623626不不良良品品数数量量/缺缺陷陷数数量量32233217131子子组组编编号号7677787980818283848586子子组组容容量量2423123254432352352353不不良良品品数数量量/缺缺陷陷数数量量33231722344生成U图(子组数在50以内)数据清零清除输入数据生成U图(子组数大于50)12131415161718192021222324252343542324234323431232431232421212341214123738394041424344454647484950353454121132443354443322283953115721552322626364656667686970717273747562345332245322342423432234532122334211315587888990919293949596979899100456464346434544466456463909013721323212755P图图、U图图数数据据登登入入表表生成控制图通往初始面板nP图图、C图图数数据据登登入入表表生成控制图生成nP图(子组数在50以内)固固定定子子组组容容量量150请将数据登入在白色方格内生成nP图(子组数大于50)子子组组编编号号1234567891011不不良良品品数数量量/缺缺陷陷数数量量1215201222151417171720子子组组编编号号2627282930313233343536不不良良品品数数量量/缺缺陷陷数数量量1112131421182021231511子子组组编编号号5152535455565758596061不不良良品品数数量量/缺缺陷陷数数量量13412132121234223子子组组编编号号7677787980818283848586不不良良品品数数量量/缺缺陷陷数数量量45686235636生成C图(子组数在50以内)数据清零清除输入数据生成C图(子组数大于50)1213141516171819202122232425122215201222151414131312121137383940414243444546474849501024415161182967121156263646566676869707172737475211112112976867238788899091929394959697989910042346235324634nP图图、C图图数数据据登登入入表表生成控制图返回X-R、X-S、中中位位数数图图数数据据运运算算表表子组内计算批次号12345678910111213X1149.0001158.0001167.0001176.0001185.0001194.0001203.0001212.0001362.0001420.0001118.0001126.0001257.000X127.667128.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.83927.83945.21159.32537.32937.57827.839X2152889.00155196.00157521.00159864.00162225.00164604.00167001.00169416.00222468.00252200.00150028.00152172.00181761.00总样本合计X-RX和R的中位数图子组容量n9.0000R=84.167R=总组数Count30.0000R=2525.000R=总样本数N270.0000上限值UCL(X)171.349上限值UCL(X)平均值X142.9852中心限CL(X)142.985中心限CL(X)最大值MaxX300.0000下限值LCL(X)114.621下限值LCL(X)最小值MinX40.0000上限值UCL(R)152.847上限值UCL(R)平均中位数MidX143.5000中心限CL(R)84.167中心限CL(R)规范上限USL200.0000下限值LCL(R)15.487下限值LCL(R)中心限CL150.0000预估不良率(PPM)86771.407预估不良率(PPM)规范下限LSL100.0000Std.Dev.=34.603Std.Dev.=偏度Skewness0.8966Sigma=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.00217161.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.0012544.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.0028900.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.3320613542837LCL/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=49.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=194.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柱状图坐标组界频率左边计算组界起点-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.707936.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.00505050505120182.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.47830153385731327.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.2257551615275Delta15.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.84893738130818157.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.83109917842629332.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.667147.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.66927.83927.83927.83927.83927.83927.83927.83927.83927.83927.83927.839184284.00246200.00178428.00191961.00250328.00197169.00199800.00202449.00205116.00207801.00210504.00213225.00215964.00218721.
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SPC 八大 控制 自动 生成 系统
![提示](https://static.bingdoc.com/images/bang_tan.gif)