CPK分析Excel版.xls

CPK分析Excel版.xls

《CPK分析Excel版.xls》由会员分享，可在线阅读，更多相关《CPK分析Excel版.xls（118页珍藏版）》请在冰豆网上搜索。

NO测定DATA15.315.205.355.375.284.8=SL25.235.245.205.315.3435.375.365.375.345.4545.455.245.285.375.3655.455.385.455.245.3265.365.395.315.255.3475.385.245.285.375.2585.375.385.455.245.2495.325.395.315.255.27105.375.425.235.205.23115.295.285.375.375.29125.285.385.455.245.43135.295.395.315.255.27145.285.425.235.245.20基基准准表表工程能力的有无是按照如下基准来判断155.245.285.375.295.45A+2.0Cpk1.67:

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

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

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

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

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

24254.8=SL262728293031325.3=33LOTNO测测定定者者样样品品数数（n）100下下限限规规格格（SL）4.80测测定定设设备备功率表测测定定日日最最大大（Max）5.450上上限限规规格格（SU）5.80客客户户名名做做成成者者最最小小（Min）5.200规规格格中中心心（）5.30规规格格做做成成日日平平均均（X-bar）5.327Cp2.33测测定定项项目目功率标标准准偏偏差差（）0.072Cpk2.20产产品品名名上上限限不不良良PPM0.0母母集集团团推推定定不不良良率率工工程程名名下下限限不不良良PPM0.00PPM特特别别备备注注工工程程能能力力分分析析表表5.175.205.235.265.295.335.365.395.425.455.485.510246810121416185.8=SU55.0000.9179.9179.91756.0000.9339.9339.93357.0000.9509.9509.95058.0000.9679.9679.96759.0000.9839.9839.9835.0000.0839.0830.0265.8=SU0.967A1.67Cpk1.33:

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

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

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

不可接受,其能力太差，应考虑重新整改设计制程5.175.205.235.265.295.335.365.395.425.455.485.510246810121416185.1695.2005.2315.2635.2945.3255.3565.3885.4195.4505.4815.5130.010K0.0534.6102.2024.6204.6300.0314.6405.1840.0000.0004.6505.2164.0004.0004.6605.24714.00014.0004.6705.2788.0008.0004.6805.30916.00016.0004.6905.34113.00013.0004.7005.37217.00017.0004.7105.40314.00014.0004.7205.4345.0005.0004.7305.4669.0009.0004.7405.4970.0000.0004.7505.5280.0000.0004.7605.5590.0004.7705.5910.0004.7805.6220.0004.7905.6530.0004.8005.6840.0004.8105.7160.0004.8205.7470.0004.8305.7780.0004.8405.8090.0004.8505.8410.0004.8605.8720.0004.8705.9030.0004.8805.9340.0004.8905.9660.0004.9005.9970.0004.9106.0280.0004.9206.0590.0004.9306.0910.0004.9406.1220.0004.9506.1530.0004.9606.1840.0004.970100.0004.9804.9905.0005.0105.0205.0305.0405.0505.0605.0705.0805.0905.1005.1105.1205.1305.1405.1505.1605.1705.1805.1905.2005.2105.2205.2305.2405.2505.2605.2705.2805.2905.3005.3005.3105.3205.3305.3405.3505.3605.3705.3805.3905.4005.4105.4205.4305.4405.4505.4605.4705.4805.4905.5005.5105.5205.5305.5405.5505.5605.5705.5805.5905.6005.6105.6205.6305.6405.6505.6605.6705.6805.6905.7005.7105.7205.7305.7405.7505.7605.7705.7805.7905.8005.8105.8205.8305.8405.8505.8605.8705.8805.8905.9005.9105.9205.9305.9405.9505.9605.9705.9805.9906.0006.0106.0206.0306.0406.050UUE5.3270.072（9.996）（49.957）0.0006.2832.5070.3990.0005.3270.072（9.856）（48.572）0.0006.2832.5070.3990.0005.3270.072（9.717）（47.207）0.0006.2832.5070.3990.0005.3270.072（9.577）（45.861）0.0006.2832.5070.3990.0005.3270.072（9.438）（44.535）0.0006.2832.5070.3990.0005.3270.072（9.298）（43.228）0.0006.2832.5070.3990.0005.3270.072（9.159）（41.941）0.0006.2832.5070.3990.0005.3270.072（9.019）（40.673）0.0006.2832.5070.3990.0005.3270.072（8.880）（39.424）0.0006.2832.5070.3990.0005.3270.072（8.740）（38.195）0.0006.2832.5070.3990.0005.3270.072（8.601）（36.985）0.0006.2832.5070.3990.0005.3270.072（8.461）（35.795）0.0006.2832.5070.3990.0005.3270.072（8.322）（34.625）0.0006.2832.5070.3990.0005.3270.072（8.182）（33.473）0.0006.2832.5070.3990.0005.3270.072（8.043）（32.342）0.0006.2832.5070.3990.0005.3270.072（7.903）（31.229）0.0006.2832.5070.3990.0005.3270.072（7.764）（30.137）0.0006.2832.5070.3990.0005.3270.072（7.624）（29.063）0.0006.2832.5070.3990.0005.3270.072（7.485）（28.009）0.0006.2832.5070.3990.0005.3270.072（7.345）（26.975）0.0006.2832.5070.3990.0005.3270.072（7.206）（25.960）0.0006.2832.5070.3990.0005.3270.072（7.066）（24.965）0.0006.2832.5070.3990.0005.3270.072（6.927）（23.989）0.0006.2832.5070.3990.0005.3270.072（6.787）（23.032）0.0006.2832.5070.3990.0005.3270.072（6.648）（22.095）0.0006.2832.5070.3990.0005.3270.072（6.508）（21.177）0.0006.2832.5070.3990.0005.3270.072（6.369）（20.279）0.0006.2832.5070.3990.0005.3270.072（6.229）（19.400）0.0006.2832.5070.3990.0005.3270.072（6.090）（18.541）0.0006.2832.5070.3990.0005.3270.072（5.950）（17.701）0.0006.2832.5070.3990.0005.3270.072（5.810）（16.881）0.0006.2832.5070.3990.0005.3270.072（5.671）（16.080）0.0006.2832.5070.3990.0005.3270.072（5.531）（15.299）0.0006.2832.5070.3990.0005.3270.072（5.392）（14.537）0.0006.2832.5070.3990.0005.3270.072（5.252）（13.794）0.0006.2832.5070.3990.0005.3270.072（5.113）（13.071）0.0006.2832.5070.3990.0005.3270.072（4.973）（12.368）0.0006.2832.5070.3990.0005.3270.072（4.834）（11.683）0.0006.2832.5070.3990.0005.3270.072（4.694）（11.019）0.0006.2832.5070.3990.0005.3270.072（4.555）（10.374）0.0006.2832.5070.3990.0005.3270.072（4.415）（9.748）0.0006.2832.5070.3990.0005.3270.072（4.276）（9.142）0.0006.2832.5070.3990.0005.3270.072（4.136）（8.555）0.0006.2832.5070.3990.0005.3270.072（3.997）（7.988）0.0006.2832.5070.3990.0005.3270.072（3.857）（7.440）0.0016.2832.5070.3990.0005.3270.072（3.718）（6.911）0.0016.2832.5070.3990.0005.3270.072（3.578）（6.402）0.0026.2832.5070.3990.0015.