CPK过程能力控制计算表格表格文件下载.xls

1、过程能力认证报告过过程程能能力力充充分分 规格设定：#单组数据个数5过过程程通通知知数据趋势X 值R 值部 门统 计AAA日 期2009/5/4增加运转周期33零件图号25311-03602审 核BBB日 期2009/5/511零件名称变档凸轮操作人员CCC减少运转周期33检测器具微米千分尺No.SL-342设备标号M6140-233描 述对磨削25311-03602变档凸轮轴径过程能力认证单 位mm失控限制00公称尺寸36.0上公差-0.025下公差-0.064连续数据高于平均值34下限尺寸35.936名义尺寸36.0上限尺寸35.975连续数据低于平均值3335.958035.953035

2、.9481均均值值 （X（X 表表）1234567891011121314151617181920212223242535.94235.94435.94635.94835.9535.95235.95435.95635.95835.96均 值上控制线UCLx平均均值下控制线LCLx0.01820.0086极极差差（R（R 表表）1234567891011121314151617181920212223242500.0020.0040.0060.0080.010.0120.0140.0160.0180.02极 差上控制线r平均均值下控制线LCLr双侧公差下限公差上限公差第1页，共2页部 门统 计A

3、AA日 期2009/5/4统统计计描描述述数数值值零件图号25311-03602审 核BBB日 期2009/5/5数据个数n125零件名称变档凸轮操作人员CCC尺寸下限（LSL）35.9360检测器具微米千分尺No.SL-342设备标号M6140-2公称值36.0000描 述对磨削25311-03602变档凸轮轴径过程能力认证单 位mm尺寸上限（USL）35.9750公称尺寸36.0上公差-0.025下公差-0.064数据总数4,494.1290下限尺寸35.936名义尺寸36.0上限尺寸35.975平均均值（X）35.9530样样本本柱柱状状分分布布图图控控制制线线柱柱状状分分布布图图最大值

4、Max35.9620 LSL USL最小值Min35.9450低于下限数据个数0高于上限数据个数035.936035.9750平均极差（R）0.0086D2，n=52.3260高能力指数（CPU）1.9805低能力指数（CPL）1.5355过程能力指数（Cp）1.7580过过程程能能力力（Cpk）1.5355过程比率（CR）0.5688标准偏差（n-1）0.0034标准偏差（n）0.0034方差（n-1）0.0000方差（n）0.0000性能指数（PP）1.8854性能比率（PR）0.5304性性能能指指数数（Ppk）1.6467分分 组组 数数 据据n12345678910111213141

5、51617181920135.94935.95635.94935.95135.95635.95135.95135.95635.95135.95135.95335.95135.95135.95135.95535.94935.95135.95135.95235.953235.95935.95735.94635.95835.95435.94735.95635.94735.95535.94935.95235.95635.95635.95735.96035.95935.95335.95735.96135.947335.94735.95235.94935.94935.95535.95135.95635.9

6、5635.95635.95735.96035.95135.94935.96035.95135.95135.96035.95435.95535.952435.95135.94935.95035.95335.95335.95335.95335.95335.95335.94835.95335.95535.94935.95335.95235.95135.95135.95035.95035.955535.95335.95535.95535.95535.95535.95535.95435.95535.95435.95035.95735.95835.95135.94935.95135.94835.95035

7、.95235.95635.953均值X35.951835.953835.949835.953235.954635.951435.95435.953435.953835.95135.95535.954235.951235.95435.953835.951635.95335.952835.954835.952极差R0.0120.0080.0090.0090.0030.0080.0050.0090.0050.0090.0080.0070.0070.0110.0090.0110.010.0070.0110.008n2122232425注 意135.95635.95235.95135.94935.953

8、235.95835.94935.95335.95835.950335.95535.95735.95435.95135.952435.95735.95435.95335.95335.956535.94535.95635.96235.95135.948均值X35.954235.953635.954635.952435.9518极差R0.0130.0080.0110.0090.0081171822251913116235.94435.94635.94835.94935.95135.95335.95435.95635.95835.95935.9610510152025300004970600035.92435.93235.94035.94835.95635.96335.97135.97935.98701020304050607080过程能力认证报告过过程程能能力力充充分分第2页，共2页