SPC-CPK分析Excel版有正态分布图.xlsx

SPC-CPK分析Excel版有正态分布图.xlsx

《SPC-CPK分析Excel版有正态分布图.xlsx》由会员分享，可在线阅读，更多相关《SPC-CPK分析Excel版有正态分布图.xlsx（478页珍藏版）》请在冰豆网上搜索。

NO测定DATA11.0201.0211.0221.0211.0211.014=SL21.0191.0201.0211.0191.01931.0211.0221.0201.0211.01941.0211.0221.0211.0191.02251.0201.0211.0221.0211.02161.0191.0201.0211.0191.01971.0211.0221.0201.0211.01981.0211.0221.0211.0191.02291.0211.0221.0211.0211.021101.0201.0211.0191.0191.019111.0211.0221.0201.0211.019121.0211.0221.0211.0191.022131.0201.0211.0221.0211.021141.0191.0201.0211.0191.019基基准准表表工程能力的有无是按照如下基准来判断151.0211.0221.0201.0211.019A+2.0Cpk1.67:

优,应当保持161.0211.0221.0211.0191.022A1.67Cpk1.33:

能力良好，状态稳定，但应尽力提升为A级171.0211.0221.0211.0211.021B1.33Cpk1.00:

状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及方法将其提升为A级181.0201.0211.0191.0191.019C1.00Cpk0.67:

差制程不良较多，必须提升其能力191.0221.0201.0211.0191.021D0.67Cpk:

不可接受,其能力太差，应考虑重新整改设计制程201.0211.0221.0211.0201.022结结论论212223规格中心（）与测定平均值的差异:

24251.014=SL262728293031321.02=33LOTNOGD201601测测定定者者样样品品数数（n）100下下限限规规格格（SL）1.014测测定定设设备备千分尺测测定定日日最最大大（Max）1.022上上限限规规格格（SU）1.026客客户户名名Guangda做做成成者者最最小小（Min）1.019规规格格中中心心（）1.020规规格格1.02ccs做做成成日日平平均均（X-bar）1.021Cp1.88测测定定项项目目外径标标准准偏偏差差（）0.001Cpk1.701.696产产品品名名CCS上上限限不不良良PPM0.0不不良良率率工工程程名名下下限限不不良良PPM0.00PPM特特别别备备注注光大科技1.02CCS外径SPC控制图，共生产了20个批次SPCSPC质质量量分分析析表表1.021.021.021.021.021.021.021.021.021.021.021.020510152025303540451.026=SU0.0011.026=SUQ3拉丝车间2016年1月份A1.67Cpk1.33:

能力良好，状态稳定，但应尽力提升为A级B1.33Cpk1.00:

状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及方法将其提升为A级C1.00Cpk0.67:

差制程不良较多，必须提升其能力D0.67Cpk:

不可接受,其能力太差，应考虑重新整改设计制程1.021.021.021.021.021.021.021.021.021.021.021.020510152025303540451.0191.0191.0191.0201.0201.0211.0211.0211.0221.0221.0221.0230.000K0.0971.0121.6961.0121.0120.0001.0121.0190.0000.0001.0121.01924.00024.0001.0121.0200.0000.0001.0121.0200.0000.0001.0131.02014.00014.0001.0131.0210.0000.0001.0131.02142.00042.0001.0131.0210.0000.0001.0131.0220.0000.0001.0131.02220.00020.0001.0131.0230.0000.0001.0131.0230.0000.0001.0141.0230.0001.0141.0240.0001.0141.0240.0001.0141.0240.0001.0141.0250.0001.0141.0250.0001.0141.0260.0001.0141.0260.0001.0141.0260.0001.0151.0270.0001.0151.0270.0001.0151.0270.0001.0151.0280.0001.0151.0280.0001.0151.0290.0001.0151.0290.0001.0151.0290.0001.0161.0300.0001.0161.0300.0001.0161.0300.0001.0161.0310.0001.016100.0001.0161.0161.0161.0171.0171.0171.0171.0171.0171.0171.0171.0171.0181.0181.0181.0181.0181.0181.0181.0181.0191.0191.0191.0191.0191.0191.0191.0191.0201.0201.0201.0201.0201.0201.0201.0201.0201.0201.0211.0211.0211.0211.0211.0211.0211.0211.0221.0221.0221.0221.0221.0221.0221.0221.0231.0231.0231.0231.0231.0231.0231.0231.0231.0241.0241.0241.0241.0241.0241.0241.0241.0251.0251.0251.0251.0251.0251.0251.0251.0261.0261.0261.0261.0261.0261.0261.0261.0261.0271.0271.0271.0271.0271.0271.0271.0271.0281.0281.0281.0281.0281.0281.0281.0281.0291.0291.0291.0291.029UUE1.0210.001（8.317）（34.583）0.0006.2832.5070.3990.0001.0210.001（8.204）（33.652）0.0006.2832.5070.3990.0001.0210.001（8.091）（32.735）0.0006.2832.5070.3990.0001.0210.001（7.979）（31.830）0.0006.2832.5070.3990.0001.0210.001（7.866）（30.937）0.0006.2832.5070.3990.0001.0210.001（7.753）（30.058）0.0006.2832.5070.3990.0001.0210.001（7.641）（29.191）0.0006.2832.5070.3990.0001.0210.001（7.528）（28.336）0.0006.2832.5070.3990.0001.0210.001（7.415）（27.495）0.0006.2832.5070.3990.0001.0210.001（7.303）（26.666）0.0006.2832.5070.3990.0001.0210.001（7.190）（25.849）0.0006.2832.5070.3990.0001.0210.001（7.078）（25.046）0.0006.2832.5070.3990.0001.0210.001（6.965）（24.255）0.0006.2832.5070.3990.0001.0210.001（6.852）（23.477）0.0006.2832.5070.3990.0001.0210.001（6.740）（22.711）0.0006.2832.5070.3990.0001.0210.001（6.627）（21.959）0.0006.2832.5070.3990.0001.0210.001（6.514）（21.218）0.0006.2832.5070.3990.0001.0210.001（6.402）（20.491）0.0006.2832.5070.3990.0001.0210.001（6.289）（19.776）0.0006.2832.5070.3990.0001.0210.001（6.176）（19.074）0.0006.2832.5070.3990.0001.0210.001（6.064）（18.385）0.0006.2832.5070.3990.0001.0210.001（5.951）（17.708）0.0006.2832.5070.3990.0001.0210.001（5.839）（17.044）0.0006.2832.5070.3990.0001.0210.001（5.726）（16.393）0.0006.2832.5070.3990.0001.0210.001（5.613）（15.754）0.0006.2832.5070.3990.0001.0210.001（5.501）（15.128）0.0006.2832.5070.3990.0001.0210.001（5.388）（14.515）0.0006.2832.5070.3990.0001.0210.001（5.275）（13.914）0.0006.2832.5070.3990.0001.0210.001（5.163）（13.327）0.0006.2832.5070.3990.0001.0210.001（5.050）（12.751）0.0006.2832.5070.3990.0001.0210.001（4.937）（12.189）0.0006.2832.5070.3990.0001.0210.001（4.825）（11.639）0.0006.2832.5070.3990.0001.0210.001（4.712）（11.102）0.0006.2832.5070.3990.0001.0210.001（4.599）（10.578）0.0006.2832.5070.3990.0001.0210.001（4.487）（10.066）0.0006.2832.5070.3990.0001.0210.001（4.374）（9.567）0.0006.2832.5070.3990.0001.0210.001（4.262）（9.080）0.0006.2832.5070.3990.0001.0210.001（4.149）（8.607）0.0006.2832.5070.3990.0001.0210.001（4.036）（8.146）0.0006.2832.5070.3990.0001.0210.001（3.924）（7.697）0.0006.2832.5070.3990.0001.0210.001（3.811）（7.262）0.0016.2832.5070.3990.0001.0210.001（3.698）（6.839）0.0016.2832.5070.3990.0001.0210.001（3.586）（6.429）0.0026.2832.5070.3990.0011.0210.001（3.473）（6.031）0.0026.2832.5070.3990.0011.0210.001（3.360）（5.646）0.0046.2832.5070.3990.0011.0210.001（3.248）（5.274）0.0056.2832.5070.3990.002