61-重复性及再现性分析数据记录表.xls

重重复复性性及及再再现现性性分分析析数数据据记记录录表表 Repeatibility And Reproducibility Analysis Data Frame非破坏性测试（NON DESTRUCTIVE TEST）No.:EC6501-012014年 4 月 9 日零件代号EC6501零件名称：门后板操作者姓名特 性长度量具编号：LS-13-6A姚志强基本尺寸68上偏差0.5单位:mm量具名称：电子数显卡尺B王溶下偏差-0.5过程总变差(6)量具规格：0-300C戚小艾操作者编号次数零件计算结果12345678910A168.09067.92068.22068.09*68.10068.09068.22068.12067.96068.180A1268.12067.93068.20068.08068.09068.12068.20068.11067.95068.190A2368.11067.92068.22068.09068.09068.12068.20068.13067.96068.180A3均值(Average)68.107 67.923 68.213 68.085 68.09368.1168.20768.1267.957 68.183极差(Range)0.030.010.020.010.010.030.020.020.010.01操作者编号次数零件计算结果12345678910B168.06067.93068.21068.09*68.11068.10068.20068.12067.95068.190B1268.08067.93068.20068.08068.12068.12068.20068.11067.95068.190B2368.08067.92068.20068.09068.10068.12068.21068.13067.96068.200B3均值(Average)68.073 67.927 68.203 68.08568.1168.113 68.20368.1267.953 68.193极差(Range)0.020.010.010.010.020.020.010.020.010.01操作者编号次数零件计算结果12345678910C168.06067.92068.20068.09068.12068.10068.21068.12067.95068.190C1268.08067.94068.20068.08068.13068.12068.20068.12067.94068.190C2368.08067.92068.21068.09068.13068.12068.20068.13067.94068.180C3均值(Average)68.073 67.927 68.203 68.087 68.127 68.113 68.203 68.123 67.943 68.187极差(Range)0.020.020.010.010.010.020.010.010.010.01零件均值68.084 67.926 68.207 68.08668.1168.112 68.204 68.121 67.951 68.188RPART=RA+RB+RC/操作者数量=0.017+0.014+0.013/3Max(X)ABC-Min(X)ABC=68.168.09868.099+1.020.0147 次数系数23UCLX=68.0991.020.0147A21.881.02LCLX=0.01472.57D3*UCLR=RDIFFXDIFFXRARAXBRBXCXCRRAXUCLX2RAXLCLX2XRDUCLR4RDLCLR3第1页，共8页0.01470D43.272.57LCLR=重重复复性性及及再再现现性性分分析析报报告告Repeatibility And Reproducibility Analysis Report非破坏性测试（NON DESTRUCTIVE TEST）No.:#2014年 4 月 9 日零件代号EC6501零件名称：门后板计算方式特 性长度量具编号：LS-13-6基本尺寸68上偏差0.5单位:mm量具名称：0下偏差-0.5过程总变差(6)0量具规格：0-300数据表结论:0.01470.0017RPART=0.2811测量单元分析基于研究总变差的分析重重复复性性 设设备备变变差差（EV）EV=次数K1%EV=100 EV/TV EV=0.008720.8862%EV=9.8%30.5908再再现现性性 操操作作人人员员变变差差（AV）AV=人数K2%AV=100 AV/TV AV=020.7071%AV=0%30.5231重重复复性性和和再再现现性性（R&R）R&R=%R&R=100 R&R/TV R&R=0.0087%R&R=9.8%说说明明：双性可接受零零件件间间变变差差（PV）PV=RPART K3零件数K3%PV=100 PV/TV PV=0.088460.3742%PV=99.5%70.3534总总变变差差（TV）80.3375 数数据据分分级级数数（NDC）TV=90.3249NDC=1.41 （PV/R&R）TV=0.09100.3146NDC=14说说明明：数据分级数可以接受重重复复性性和和再再现现性性（%R&R）接接收收准准则则：低于10%：测量系统可接受。介于10%到30%之间：基于应用的重要性，该量具可能会被接受。在双性小于30%情况下，应计算风险参数“BREAKPOINT”，并且检查其值是否小于37.8。大于30%：测量系统需要改善。识别出原因并纠正它们。在该尺寸测量前，应从FMEA中确定风险顺序数（RPN）的值。将BREAKPOINT=RPNRPN值填写到右边栏中，计算BREAKPOINT的值，并按照接收准则作出相应的结论。=RDIFFX/nr)(EV)K*X(222DIFF利用公差计算利用过程变差进行计算利用研究零件间变差代替过程变差计算1KR 22AVEV22PVR&RRDLCLR3第2页，共8页结结论论测量系统可以接受评评价价人人/日日期期王佟霞重重复复性性及及再再现现性性分分析析-均均值值极极差差控控制制图图 Repeatibility And Reproducibility Analysis-Xbar-R Chart非破坏性测试（NON DESTRUCTIVE TEST）No.:#2014年 4 月 9 日零件代号EC6501零件名称：门后板操作者姓名特 性长度量具编号：LS-13-6A姚志强基本尺寸68上偏差0.5单位:mm量具名称：电子数显卡尺B王溶下偏差-0.5过程总变差(6)0量具规格：0-300C戚小艾数数据据表表结结论论数数据据精精度度均值图上限UCL=68.114中心CL=68.099下限LCL=68.084极差图上限UCL=0.038中心CL=0.015下限LCL=0均值图数据选项=3评价人A均值68.10767.92368.21368.08568.09368.1168.20768.1267.95768.183评价人B均值68.07367.92768.20368.08568.1168.11368.20368.1267.95368.193评价人C均值68.07367.92768.20368.08768.12768.11368.20368.12367.94368.187上控限 68.11468.11468.11468.11468.11468.11468.11468.11468.11468.114中心68.09968.09968.09968.09968.09968.09968.09968.09968.09968.099下控限 68.08468.08468.08468.08468.08468.08468.08468.08468.08468.084最大值=68.213最小值=67.923极差图数据评价人A极差0.030.010.020.010.010.030.020.020.010.01评价人B极差0.020.010.010.010.020.020.010.020.010.01评价人C极差0.020.020.010.010.010.020.010.010.010.01上控限0.0380.0380.0380.0380.0380.0380.0380.0380.0380.038中心0.0150.0150.0150.0150.0150.0150.0150.0150.0150.015下控限0000000000极差受控否TRUE测量系统分析（MSA）-极差图(Range Chart)1234567891000.0050.010.0150.020.0250.030.0350.04零件极差评价人A评价人B评价人CUCLRbarLCL测量系统分析（MSA）-均值图(Xbar Chart)1234567891001020304050607080零件均值评价人A评价人B评价人CUCL(Xbar)barLCL第3页，共8页测量系统分析（MSA）-极差图(Range Chart)1234567891000.0050.010.0150.020.0250.030.0350.04零件极差评价人A评价人B评价人CUCLRbarLCL第4页，共8页编编号号：ZG-QR-61均值68.168.09968.10268.09980.017均值68.096768.09868.10168.09820.014均值68.09668.168.168.09870.01368.09890.281110.014670.0016768.113868.08390.037692014年 4 月 9 日姓名姚志强王溶戚小艾计算结果计算结果计算结果第5页，共8页0编编号号：ZG-QR-61ZG-QR-61%GR&R2014年 4 月 9 日计算方式1.41 （PV/R&R）利用公差计算利用过程变差进行计算利用研究零件间变差代替过程变差计算第6页，共8页编编号号：ZG-QR-61ZG-QR-613 32014年 4 月 9 日姓名姚志强王溶戚小艾测量系统分析（MSA）-极差图(Range Chart)1234567891000.0050.010.0150.020.0250.030.0350.04零件极差评价人A评价人B评价人CUCLRbarLCL测量系统分析（MSA）-均值图(Xbar Chart)1234567891001020304050607080零件均值评价人A评价人B评价人CUCL(Xbar)barLCL第7页，共8页测量系统分析（MSA）-极差图(Range Chart)1234567891000.0050.010.0150.020.0250.030.0350.04零件极差评价人A评价人B评价人CUCLRbarLCL第8页，共8页