CPK分析Excel版演示教学.xls

NO测定 D A T A15.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.0 Cpk 1.67:优,应当保持165.385.455.375.425.23A 1.67 Cpk 1.33:能力良好，状态稳定，但应尽力提升为A级175.395.315.295.285.37B 1.33 Cpk 1.00:状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及方法将其提升为 A级185.265.395.285.385.45C 1.00 Cpk 0.67:差 制程不良较多，必须提升其能力195.385.425.295.395.31D 0.67 Cpk :不可接受,其能力太差，应考虑重新整改设计制程205.305.375.395.315.25结结论论212223 规格中心()与 测定 平均值的差异:24254.8=SL262728293031325.3=33LOT NO测测定定者者样样品品数数(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.00 PPM特特别别备备注注工工程程能能力力分分析析表表5.175.205.235.265.295.335.365.395.425.455.485.510 2 4 6 8 10 12 14 16 18 5.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.967A 1.67 Cpk 1.33:能力良好，状态稳定，但应尽力提升为A级B 1.33 Cpk 1.00:状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及方法将其提升为 A级C 1.00 Cpk 0.67:差 制程不良较多，必须提升其能力D 0.67 Cpk :不可接受,其能力太差，应考虑重新整改设计制程5.175.205.235.265.295.335.365.395.425.455.485.510 2 4 6 8 10 12 14 16 18 5.1695.2005.2315.2635.2945.3255.3565.3885.4195.4505.4815.5130.010K0.0534.6102.202 4.6204.6300.031 4.6405.1840.0000.0004.6505.2164.0004.0004.6605.24714.00014.000 4.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.3270.072(3.439)(5.913)0.0036.2832.5070.3990.0015.3270.072(3.299)(5.443)0.0046.2832.5070.3990.0025.3270.072(3.160)(4.992)0.0076.2832.5070.3990.0035.3270.072(3.020)(4.561)0.0106.2832.5070.3990.0045.3270.072(2.881)(4.150)0.0166.2832.5070.3990.0065.3270.072(2.741)(3.757)0.0236.2832.5070.3990.0095.3270.072(2.602)(3.385)0.0346.2832.5070.3990.0145.3270.072(2.462)(3.031)0.0486.2832.5070.3990.0195.3270.072(2.323)(2.698)0.0676.2832.5070.3990.0275.3270.072(2.183)(2.383)0.0926.2832.5070.3990.0375.3270.072(2.044)(2.089)0.1246.2832.5070.3990.0495.3270.072(1.904)(1.813)0.1636.2832.5070.3990.0655.3270.072(1.765)(1.557)0.2116.2832.5070.3990.0845.3270.072(1.625)(1.321)0.2676.2832.5070.3990.1065.3270.072(1.486)(1.104)0.3326.2832.5070.3990.1325.3270.072(1.346)(0.906)0.4046.2832.5070.3990.1615.3270.072(1.207)(0.728)0.4836.2832.5070.3990.1935.3270.072(1.067)(0.569)0.5666.2832.5070.3990.2265.3270.072(0.928)(0.430)0.6506.2832.5070.3990.2595.3270.072(0.788)(0.311)0.7336.2832.5070.3990.2925.3270.072(0.649)(0.210)0.8106.2832.5070.3990.3235.3270.072(0.509)(0.130)0.8786.2832.5070.3990.3505.3270.072(0.370)(0.068)0.9346.2832.5070.3990.3735.3270.072(0.230)(0.026)0.9746.2832.5070.3990.3895.3270.072(0.091)(0.004)0.9966.2832.5070.3990.3975.3270.0720.049(0.001)0.9996.2832.5070.3990.3985.3270.0720.188(0.018)0.9826.2832.5070.3990.3925.3270.0720.328(0.054)0.9486.2832.5070.3990.3785.3270.0720.467(0.109)0.8976.2832.5070.3990.3585.3270.0720.607(0.184)0.8326.2832.5070.3990.3325.3270.0720.746(0.279)0.7576.2832.5070.3990.3025.3270.0720.886(0.392)0.6756.2832.5070.3990.2695.3270.0721.025(0.526)0.5916.2832.5070.3990.2365.3270.0721.165(0.678)0.5076.2832.5070.3990.2025.3270.0721.304(0.851)0.4276.2832.5070.3990.1705.3270.0721.444(1.042)0.3536.2832.5070.3990.1415.3270.0721.583(1.254)0.2856.2832.5070.3990.1145.3270.0721.723(1.484)0.2276.2832.5070.3990.0905.3270.0721.862(1.734)0.1776.2832.5070.3990.0705.3270.0722.002(2.004)0.1356.2832.5070.3990.0545.3270.0722.141(2.293)0.1016.2832.5070.3990.0405.3270.0722.281(2.601)0.0746.2832.5070.3990.0305.3270.0722.420(2.929)0.0536.2832.5070.3990.0215.3270.0722.560(3.277)0.0386.2832.5070.3990.0155.3270.0722.699(3.644)0.0266.2832.5070.3990.0105.3270.0722.839(4.030)0.0186.2832.5070.3990.0075.3270.0722.978(4.436)0.0126.2832.5070.3990.0055.3270.0723.118(4.861)0.0086.2832.5070.3990.0035.3270.0723.257(5.306)0.0056.2832.5070.3990.0025.3270.0723.397(5.770)0.0036.2832.5070.3990.0015.3270.0723.537(6.253)0.0026.2832.5070.3990.0015.3270.0723.676(6.757)0.0016.2832.5070.3990.0005.3270.0723.816(7.279)0.0016.2832.5070.3990.0005.3270.0723.955(7.821)0.0006.2832.5070.3990.0005.3270.0724.095(8.383)0.0006.2832.5070.3990.0005.3270.0724.234(8.964)0.0006.2832.5070.3990.0005.3270.0724.374(9.564)0.0006.2832.5070.3990.0005.3270.0724.513(10.184)0.0006.2832.5070.3990.0005.3270.0724.653(10.823)0.0006.2832.5070.3990.0005.3270.0724.792(11.482)0.0006.2832.5070.3990.0005.3270.0724.932(12.160)0.0006.2832.5070.3990.0005.3270.0725.071(12.858)0.0006.2832.5070.3990.0005.3270.0725.211(13.575)0.0006.2832.5070.3990.0005.3270.0725.350(14.312)0.0006.2832.5070.3990.0005.3270.0725.490(15.068)0.0006.2832.5070.3990.0005.3270.0725.629(15.844)0.0006.2832.5070.3990.0005.3270.0725.769(16.639)0.0006.2832.5070.3990.0005.3270.0725.908(17.453)0.0006.2832.5070.3990.0005.3270.0726.048(18.287)0.0006.2832.5070.3990.0005.3270.0726.187(19.140)0.0006.2832.5070.3990.0005.3270.0726.327(20.013)0.0006.2832.5070.3990.0005.3270.0726.466(20.906)0.0006.2832.5070.3990.0005.3270.0726.606(21.817)0.0006.2832.5070.3990.0005.3270.0726.745(22.749)0.0006.2832.5070.3990.0005.3270.0726.885(23.699)0.0006.2832.5070.3990.0005.3270.0727.024(24.670)0.0006.2832.5070.3990.0005.3270.0727.164(25.659)0.0006.2832.5070.3990.0005.3270.0727.303(26.668)0.0006.2832.5070.3990.0005.3270.0727.443(27.697)0.0006.2832.5070.3990.0005.3270.0727.582(28.745)0.0006.2832.5070.3990.0005.3270.0727.722(29.813)0.0006.2832.5070.3990.0005.3270.0727.861(30.900)0.0006.2832.5070.3990.0005.3270.0728.001(32.006)0.0006.2832.5070.3990.0005.3270.0728.140(33.132)0.0006.2832.5070.3990.0005.3270.0728.280(34.277)0.0006.2832.5070.3990.0005.3270.0728.419(35.442)0.0006.2832.5070.3990.0005.3270.0728.559(36.626)0.0006.2832.5070.3990.0005.3270.0728.698(37.830)0.0006.2832.5070.3990.0005.3270.0728.838(39.053)0.0006.2832.5070.3990.0005.3270.0728.977(40.296)0.0006.2832.5070.3990.0005.3270.0729.117(41.558)0.0006.2832.5070.3990.0005.3270.0729.256(42.840)0.0006.2832.5070.3990.0005.3270.0729.396(44.141)0.0006.2832.5070.3990.0005.3270.0729.535(45.461)0.0006.2832.5070.3990.0005.3270.0729.675(46.801)0.0006.2832.5070.3990.0005.3270.0729.814(48.161)0.0006.2832.5070.3990.0005.3270.0729.954(49.540)0.0006.2832.5070.3990.0005.3270.07210.093(50.938)0.0006.2832.5070.3990.0000.3190.319 0.3980.3980.3190.319NO测定 D A T A14.384.304.244.374.313.8=SL24.414.464.304.274.2434.274.414.464.424.3144.464.384.304.344.2454.424.414.464.414.3264.414.304.274.394.2974.384.274.344.244.2484.324.344.324.324.4194.294.44.274.344.29104.244.384.344.324.41114.344.294.274.344.42124.324.384.344.324.34134.334.274.324.334.41144.304.274.294.394.29基基准准表表 工程能力的有无是按照如下基准来判断154.344.344.244.244.32A+2.0 Cpk 1.67:优,应当保持164.334.44.344.464.29A 1.67 Cpk 1.33:能力良好，状态稳定，但应尽力提升为A级174.304.274.324.344.24B 1.33 Cpk 1.00:状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及方法将其提升为 A级184.344.344.334.324.34C 1.00 Cpk 0.67:差 制程不良较多，必须提升其能力194.314.314.304.274.32D 0.67 Cpk :不可接受,其能力太差，应考虑重新整改设计制程204.274.294.434.274.33结结论论212223 规格中心()与 测定 平均值的差异:24253.8=SL262728293031324.3=33LOT NO测测定定者者样样品品数数(n)(n)100下下限限规规格格 (SL)(SL)3.80测测定定设设备备功率表测测定定日日最最大大(Max)(Max)4.46上上限限规规格格(SU)(SU)4.80客客户户名名做做成成者者最最小小(Min)(Min)4.24规规格格中中心心()()4.30规规格格做做成成日日平平均均(X-bar)(X-bar)4.33CpCp2.84测测定定项项目目功率标标准准偏偏差差()()0.06CpkCpk2.662.66产产品品名名上上限限不不良良PPMPPM0.00.0母母集集团团推推定定不不良良率率工工程程名名下下限限不不良良PPMPPM0.00.00 0 PPMPPM特特别别备备注注工工程程能能力力分分析析表表4.214.244.274.304.324.354.384.414.434.464.494.520 5 10 15 20 25 4.8=SU 0.0314.8=SU5.0000.0830.0839.0839.08353.0000.8830.8838.8838.88354.0000.9000.9008.9008.90055.0000.9170.9178.9178.91756.0000.9330.9338.9338.93357.0000.9500.9508.9508.95058.0000.9670.9678.9678.96759.0000.9830.9838.9838.983A 1.67 Cpk 1.33:能力良好，状态稳定，但应尽力提升为A级B 1.33 Cpk 1.00:状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及方法将其提升为 A级C 1.00 Cpk 0.67:差 制程不良较多，必须提升其能力D 0.67 Cpk :不可接受,其能力太差，应考虑重新整改设计制程4.214.244.274.304.324.354.384.414.434.464.494.520 5 10 15 20 25 4.2134.2404.2684.2954.3234.3504.3784.4054.4334.4604.4884.5150.010K0.0623.6102.665 3.6203.6300.028 3.6404.2260.0000.0003.6504.2549.0009.0003.6604.28112.00012.000 3.6704.30915.00015.0003.6804.33621.00021.0003.6904.36416.00016.0003.7004.3918.0008.0003.7104.41910.00010.0003.7204.4464.0004.0003.7304.4745.0005.0003.7404.5010.0000.0003.7504.5290.0000.0003.7604.5560.0003.7704.5840.0003.7804.6110.0003.7904.6390.0003.8004.6660.0003.8104.6940.0003.8204.7210.0003.8304.7490.0003.8404.7760.0003.8504.8040.0003.8604.8310.0003.8704.8590.0003.8804.8860.0003.8904.9140.0003.9004.9410.0003.9104.9690.0003.9204.9960.0003.9305.0240.0003.9405.0510.0003.9505.0790.0003.9605.1060.0003.970100.0003.9803.9904.0004.0104.0204.0304.0404.0504.0604.0704.0804.0904.1004.1104.1204.1304.1404.1504.1604.1704.1804.1904.2004.2104.2204.2304.2404.2504.2604.2704.2804.2904.3004.3004.3104.3204.3304.3404.3504.3604.3704.3804.3904.4004.4104.4204.4304.4404.4504.4604.4704.4804.4904.5004.5104.5204.5304.5404.5504.5604.5704.5804.5904.6004.6104.6204.6304.6404.6504.6604.6704.6804.6904.7004.7104.7204.7304.7404.7504.7604.7704.7804.7904.8004.8104.8204.8304.8404.8504.8604.8704.8804.8904.9004.9104.9204.9304.9404.9504.9604.9704.9804.9905.0005.0105.0205.0305.0405.050UUE4.3310.059(12.294)(75.575)0.0006.2832.5070.3990.0004.3310.059(12.124)(73.493)0.0006.2832.5070.3990.0004.3310.059(11.953)(71.441)0.0006.2832.5070.3990.0004.3310.059(11.783)(69.418)0.0006.2832.5070.3990.0004.3310.059(11.612)(67.423)0.0006.2832.5070.3990.0004.3310.059(11.442)(65.458)0.0006.2832.5070.3990.0004.3310.059(11.271)(63.522)0.0006.2832.5070.3990.0004.3310.059(11.101)(61.614)0.0006.2832.5070.3990.0004.3310.059(10.930)(59.736)0.0006.2832.5070.3990.0004.3310.059(10.760)(57.887)0.0006.2832.5070.3990.0004.3310.059(10.589)(56.067)0.0006.2832.5070.3990.0004.3310.059(10.419)(54.277)0.0006.2832.5070.3990.0004.3310.059(10.248)(52.515)0.0006.2832.5070.3990.0004.3310.059(10.078)(50.782)0.0006.2832.5070.3990.0004.3310.059(9.907)(49.078)0.0006.2832.5070.3990.0004.3310.059(9.737)(47.404)0.0006.2832.5070.3990.0004.3310.059(9.566)(45.758)0.0006.2832.5070.3990.0004.3310.059(9.396)(44.142)0.0006.2832.5070.3990.0004.3310.059(9.225)(42.554)0.0006.2832.5070.3990.0004.3310.059(9.055)(40.996)0.0006.2832.5070.3990.0004.3310.059(8.884)(39.467)0.0006.2832.5070.3990.0004.3310.059(8.714)(37.966)0.0006.2832.5070.3990.0004.3310.059(8.543)(36.495)0.0006.2832.5070.3990.0004.3310.059(8.373)(35.053)0.0006.2832.5070.3990.0004.3310.059(8.202)(33.640)0.0006.2832.5070.3990.0004.3310.059(8.032)(32.256)0.0006.2832.5070.3990.0004.3310.059(7.861)(30.901)0.0006.2832.5070.3990.0004.3310.059(7.691)(29.576)0.0006.2832.5070.3990.0004.3310.059(7.520)(28.279)0.0006.2832.5070.3990.0004.3310.059(7.350)(27.011)0.0006.2832.5070.3990.0004.3310.059(7.179)(25.773)0.0006.2832.5070.3990.0004.3310.059(7.009)(24.563)0.0006.2832.5070.3990.0004.3310.059(6.839)(23.383)0.0006.2832.5070.3990.0004.3310.059(6.668)(22.231)0.0006.2832.5070.3990.0004.3310.059(6.498)(21.109)0.0006.2832.5070.3990.0004.3310.059(6.327)(20.016)0.0006.2832.5070.3990.0004.3310.059(6.157)(18.951)0.0006.2832.5070.3990.0004.3310.059(5.986)(17.916)0.0006.2832.5070.3990.0004.3310.059(5.816)(16.910)0.0006.2832.5070.3990.0004.3310.059(5.645)(15.933)0.0006.2832.5070.3990.0004.3310.059(5.475)(14.985)0.0006.2832.5070.3990.0004.3310.059(5.304)(14.067)0.0006.2832.5070.3990.0004.3310.059(5.134)(13.177)0.0006.2832.5070.3990.0004.3310.059(4.963)(12.316)0.0006.2832.5070.3990.0004.3310.059(4.793)(11.484)0.0006.2832.5070.3990.0004.3310.059(4.622)(10.682)0.0006.2832.5070.3990.0004.3310.059(4.452)(9.908)0.0006.2832.5070.3990.0004.3310.059(4.281)(9.164)0.0006.2832.5070.3990.0004.3310.059(4.111)(8.449)0.0006.2832.5070.3990.0004.3310.059(3.940)(7.762)0.0006.2832.507