GR&R（msa） 测量系统分析MSA GR&R---数据记录表 Data Worksheet 报告编号Report NO. 量具名称 Equipment Name 产品类型 Description 测量人员 OperatorＡ 测试日期 Test Tate 量具编号 Equipment NO. 基件编号 P/N 测量人员 OperatorＢ 平价人数 Appraisers 3 参数规格 Dimension 规格上限 USL 测量人员 OperatorＣ 试验次数 Trials 3 单位 Unit MM 规格下限 LSL 过程变差/过程能力 Process Variation(σ/PP) 样 品 数 Samples 10 分析时机Analytical Occasion 零件编号Parts NO. 1 2 3 4 5 6 7 8 9 10 Total 平均值Average 1. A 1 0.29 -0.56 1.34 0.47 -0.8 0.02 0.59 -0.31 2.26 -1.36 1.94 0.194000 2. 2 0.41 -0.68 1.17 0.5 -0.92 -0.11 0.75 -0.2 1.99 -1.25 1.66 0.166000 3. 3 0.64 -0.58 1.27 0.64 -0.84 -0.21 0.66 -0.17 2.01 -1.31 2.11 0.211000 4. 均值Mean 0.44667 -0.60667 1.26000 0.53667 -0.85333 -0.10000 0.66667 -0.22667 2.08667 -1.30667 0.190333 Sum A 1.34 -1.82 3.78 1.61 -2.56 -0.3 2 -0.68 6.26 -3.92 5.7100 5. 极差Range 0.35 0.12 0.17 0.17 0.12 0.23 0.16 0.14 0.27 0.11 0.184000 6. B 1 0.08 -0.47 1.19 0.01 -0.56 -0.2 0.47 -0.63 1.8 -1.68 0.01 0.001000 7. 2 0.25 -1.22 0.94 1.03 -1.2 0.22 0.55 0.08 2.12 -1.62 11.304 0.115000 8. 3 0.07 -0.68 1.34 0.2 -1.28 0.06 0.83 -0.34 2.19 -1.5 0.89 0.089000 9. 均值Mean 0.13333 -0.79000 1.15667 0.41333 -1.01333 0.02667 0.61667 -0.29667 2.03667 -1.60000 0.068333 Sum B 0.4 -2.37 3.47 1.24 -3.04 0.08 1.85 -0.89 6.11 -4.8 2.0500 10. 极差Range 0.18 0.75 0.4 1.02 0.72 0.42 0.36 0.71 0.39 0.18 0.513000 11. C 1 0.04 -1.38 0.88 0.14 -1.46 -0.29 0.02 -0.46 1.77 -1.49 -2.23 -0.223000 12. 2 -0.11 -1.13 1.09 0.2 -1.07 -0.67 0.01 -0.56 1.45 -1.77 -2.56 -0.256000 13. 3 -0.15 -0.96 0.67 0.11 -1.45 -0.49 0.21 -0.49 1.87 -2.16 -2.84 -0.284000 14. 均值Mean -0.07333 -1.15667 0.88000 0.15000 -1.32667 -0.48333 0.08000 -0.50333 1.69667 -1.80667 -0.254333 Sum C -0.22 -3.47 2.64 0.45 -3.98 -1.45 0.24 -1.51 5.09 -5.42 -7.63 15. 极差Range 0.1900 0.4200 0.4200 0.0900 0.3900 0.3800 0.2000 0.1000 0.4200 0.6700 0.328000 零件均值 Parts Mean 0.168889 -0.851111 1.098889 0.366667 -1.064444 -0.185556 0.454444 -0.342222 1.940000 -1.571111 0.001444 Total 1.520000 -7.660000 9.890000 3.300000 -9.580000 -1.670000 4.090000 -3.080000 17.460000 -14.140000 0.13 3.511111 0.341667 试验次数Trials 2 3 0.444667 D4 3.267 2.575 0.350969 0.879792 D3 0 0 -0.348081 0.000000 A2 1.88 1.023 注:当分析结果超出要求后，利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。 均值图 mean chart 1 2 3 4 5 6 7 8 9 10 UCLx 0.3510 0.3510 0.3510 0.3510 0.3510 0.3510 0.3510 0.3510 0.3510 0.3510 LCLx -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 UCLR 0.8798 0.8798 0.8798 0.8798 0.8798 0.8798 0.8798 0.8798 0.8798 0.8798 LCLR 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 公差： 6σ pp 变差 PV 1.104596 PV 1.104596 1.104596 PV 1.104596 TV 0.000000 TV 0.000000 #DIV/0! TV 1.146135 基于公差base on parts spec %EV #DIV/0! #DIV/0! #DIV/0! 17.61% 基于零件变差base on parts variation %AV #DIV/0! #DIV/0! #DIV/0! 20.04% 基于过程变差base on process variation %RR #DIV/0! #DIV/0! #DIV/0! 26.68% 基于过程能力Base on process PP %PV #DIV/0! #DIV/0! #DIV/0! 96.38% 公式A Formula A ndc 5.093692473 公式B Formula B X^2/nkr 0.0001878 sumSQ(sum(men))/nr 3.1674500 SUMSQ(sum(1-10part))/kr 88.3621222 极差图 Range chart SUMSQ(sum(men-part))/r 91.8883667 sumSQ(all) 94.6473000 n=part k=men r=time ANOVA Table With Operator*Part Interaction ANOVA Table Without Operator*Part Interaction Source DF SS MS F P Source DF SS MS F P Parts 9 88.36193 9.81799 492.29142 0.00000 Parts 9 88.36193 9.81799 245.61391 0.00000 Operators 2 3.16726 1.58363 79.40605 0.00000 Operators 2 3.16726 1.58363 39.61725 0.00000 Operators*Part 18 0.35898 0.01994 0.43372 0.97411 Repeatability 60 2.75893 0.04598 Repeatability 78 3.11792 0.03997 Total 89 94.64711 Total 89 94.64711 Gauge R&R With Operator*Part Interaction Gauge R&R Without Operator*Part Interaction Source VarComp Stdev %Contribution %TV %Tolerance Source VarComp Stdev %Contribution %TV %Tolerance Total Gauge R&R 0.09811 0.31322 8.27% 28.75% #DIV/0! Total Gauge R&R 0.09143 0.30237 7.76% 27.86% #DIV/0! Repeatability 0.04598 0.21443 3.87% 19.68% #DIV/0! Repeatability 0.03997 0.19993 3.39% 18.42% #DIV/0! Reproducibility 0.05212 0.22830 4.39% 20.96% #DIV/0! Reproducibility 0.05146 0.22684 4.37% 20.90% #DIV/0! Operator 0.05212 0.22830 4.39% 20.96% #DIV/0! Operator 0.05146 0.22684 4.37% 20.90% #DIV/0! Operators*Part 0.00000 0.00000 0.00% 0.00% #DIV/0! Part - To - Part 1.08867 1.04339 91.73% 95.78% #DIV/0! Part - To - Part 1.08645 1.04233 92.24% 96.04% #DIV/0! Total Variation 1.18678 1.08939 100.00% 100.00% #DIV/0! Total Variation 1.17788 1.08530 100.00% 100.00% #DIV/0! 测量系统分析MSA GR&R---均值极差法Average and method 报告编号Report NO. 量具名称 Equipment 产品类型 Description 测量人员 OperatorＡ 测试日期 Test Tate 12/31/99 量具编号 Equipment NO. 基件编号 Part NO. 测量人员 OperatorＢ 平价人数 Appraisers 3 参数规格 Specification 规格上限 Upper limit 测量人员 OperatorＣ 试验次数 Trials 3 测量单位 Unit MM 规格下限 Lower Limit 过程变差/过程能力 Process Variation(σ/PP) 样 品 数 Samples 10 Datasheet： 0.341667 0.444667 3.511111 分析方式Analysis mode 基于零件变差base on parts variation 测量系统分析MSA % 总变差Total variation（TV） 重复性Repeatability－设备变差Equipment Variation(...