SPC CPK分析Excel版 - 图文

工程能力分析表NO123456789101112131415161718192021222324252627282930313233样品数(n)最大(Max)最小(Min)平均(X-bar)标准偏差(σ)上限不良PPM下限不良PPM特别备注5.315.235.375.455.45测定 D A T A5.205.245.355.205.375.315.285.345.455.365.325.345.255.245.275.235.295.435.275.205.455.235.375.455.315.2518 4.8=SL16 5.365.245.385.395.245.385.395.425.285.385.395.425.285.455.315.395.425.375.375.285.455.315.285.455.315.235.375.455.315.235.375.345.375.245.255.375.245.255.205.375.245.255.245.295.425.285.385.395.3114 12 5.365.385.375.325.375.295.285.295.285.245.385.395.265.385.3010 8 6 4 2 0 5.175.205.235.26基准表★ 工程能力的有无是按照如下基准来判断A+? 2.0 > Cpk ≥ 1.67 : 优,应当保持5.375.295.285.295.39A? 1.67 > Cpk ≥ 1.33 : 能力良好，状态稳定，但应尽力提升为A 5.295.335.365.39B ? 1.33 > Cpk ≥ 1.00 : 状态一般，制程因素稍有变异即有产生不C? 1.00 > Cpk ≥ 0.67 : 差 制程不良较多，必须提升其能力D ? 0.67 > Cpk : 不可接受,其能力太差，应考虑重新整改设计制结论 ? 规格中心 (μ) 与 测定 平均值的差异 :4.8=SL5.3=μLOT NO1005.4505.2005.3270.0720.00.0下限规格 (SL)上限规格(SU)规格中心(μ)Cp测定者测定日做成者做成日4.805.805.302.332.20测定设备功率表客户名规格测定项目功率产品名工程名Cpk母集团推定不良率0PPM