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

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

《CPK过程能力控制计算表格表格文件下载.xls》由会员分享，可在线阅读，更多相关《CPK过程能力控制计算表格表格文件下载.xls（2页珍藏版）》请在冰豆网上搜索。

过程能力认证报告过过程程能能力力充充分分规格设定：

@#@单组数据个数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.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页部门统计AAA日期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样样本本柱柱状状分分布布图图控控制制线线柱柱状状分分布布图图最大值Max35.9620LSLUSL最小值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分分组组数数据据n1234567891011121314151617181920135.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.95635.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.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.953235.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页