SPC CPK分析Excel版.xls
《SPC CPK分析Excel版.xls》由会员分享,可在线阅读,更多相关《SPC CPK分析Excel版.xls(118页珍藏版)》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、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.2
2、85.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.
3、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.
4、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.967
5、A 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.0
6、534.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.770
7、5.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.970
8、100.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.5
9、505.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.399
10、0.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.399
11、0.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.399
12、0.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.399
13、0.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.399
14、0.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.399
15、0.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.399
16、0.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.0
17、005.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.32
18、70.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
19、(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
20、)(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.21
21、0)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.2
22、832.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
23、.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.0
24、04)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.507
25、0.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.0
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SPC CPK分析Excel版 CPK 分析 Excel
限制150内