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

文档编号：30854258
上传时间：2024-03-14
格式：XLS
页数：60
大小：195KB

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

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

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.202.202产产品品名名上上限限不不良良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.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.3190.3980.3980.3190.319NO测定DATA14.384.304.244.374.313.8=SL4.8=SU24.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.