MSA测量系统分析表格.xlsx

1、Page：1/3测量系统分析MSA GR&R-数据记录表 Data Worksheet报告编号Report NO. QAC-001/20150127量具名称Equipment Name 电阻测量工装产品类型Description 电阻应变计测量人员Operator 李永江测试日期Test Tate 2015.1.27量具编号Equipment NO.D6123679CD251/001-085基件编号P/N测量人员Operator 程静娅平价人数Appraisers 3参数规格Dimension规格上限USL测量人员Operator 冯博试验次数Trials 3单位Unit 规格下限LSL过程变

2、差/过程能力Process Variation(/PP)样 品 数Samples 10分析时机Analytical Occasion零件编号Parts NO. 1 2 3 4 5 6 7 8 9 10 Total 平均值Average 1. A 1 350.41 350.06 349.8 349.8 349.78 349.91 349.94 349.89 349.8 349.8 3499.19 349.9190002. 2 350.41 350.02 349.77 349.78 349.78 349.93 349.94 349.91 349.8 349.83 3499.17 349.91700

3、03. 3 350.41 350.04 349.78 349.78 349.76 349.92 349.97 349.92 349.8 349.83 3499.21 349.9210004. 均值Mean 350.41000350.04000349.78333349.78667349.77333349.92000349.95000349.90667349.80000349.82000 349.919000Sum A 1051.23 1050.12 1049.35 1049.36 1049.32 1049.76 1049.85 1049.72 1049.4 1049.46 10497.57005

4、. 极差Range 0 0.04 0.03 0.02 0.02 0.02 0.03 0.03 0 0.03 0.0220006. B 1 350.36 350.04 349.76 349.78 349.78 349.91 349.9 349.87 349.78 349.79 3498.97 349.8970007. 2 350.4 350.04 349.8 349.77 349.77 349.92 349.91 349.88 349.77 349.8 11.304 349.9060008. 3 350.39 350.02 349.82 349.8 349.81 349.87 349.92 34

5、9.86 349.84 349.78 3499.11 349.9110009. 均值Mean 350.38333350.03333349.79333349.78333349.78667349.90000349.91000349.87000349.79667349.79000 349.904667Sum B 1051.15 1050.1 1049.38 1049.35 1049.36 1049.7 1049.73 1049.61 1049.39 1049.37 10497.140010. 极差Range 0.04 0.02 0.06 0.03 0.04 0.05 0.02 0.02 0.07 0

6、.02 0.03700011. C 1 350.35 350 349.78 349.77 349.76 349.94 349.95 349.9 349.79 349.85 3499.09 349.90900012. 2 350.36 350.01 349.77 349.78 349.78 349.92 349.96 349.93 349.81 349.81 3499.13 349.91300013. 3 350.36 350.02 349.77 349.75 349.73 349.89 349.94 349.89 349.79 349.82 3498.96 349.89600014. 均值Me

7、an 350.35667350.01000349.77333349.76667349.75667349.91667349.95000349.90667349.79667349.82667 349.906000Sum C 1051.07 1050.03 1049.32 1049.3 1049.27 1049.75 1049.85 1049.72 1049.39 1049.48 10497.1815. 极差Range 0.0100 0.0200 0.0100 0.0300 0.0500 0.0500 0.0200 0.0400 0.0200 0.0400 0.029000零件均值Parts Mea

8、n350.383333 350.027778 349.783333 349.778889 349.772222 349.912222 349.936667 349.894444 349.797778 349.812222 349.909889Total 3153.450000 3150.250000 3148.050000 3148.010000 3147.950000 3149.210000 3149.430000 3149.050000 3148.180000 3148.310000 31491.89 0.6111110.029333 试验次数Trials 2 30.014333 D4 3

9、.267 2.575349.939897 0.075533 D3 0 0349.879881 0.000000 A2 1.88 1.023注:当分析结果超出要求后，利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。均值图meanchart1 2 3 4 5 6 7 8 9 10UCLx 349.9399 349.9399 349.9399 349.9399 349.9399 349.9399 349.9399 349.9399 349.9399

10、349.9399LCLx 349.8799 349.8799 349.8799 349.8799 349.8799 349.8799 349.8799 349.8799 349.8799 349.8799UCLR 0.0755 0.0755 0.0755 0.0755 0.0755 0.0755 0.0755 0.0755 0.0755 0.0755LCLR 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000公差： 6 pp 变差PV 0.192256 PV 0.192256 0.192256 PV 0.1

11、92256TV 0.000000 TV 0.000000 #DIV/0! TV 0.193155 基于公差base on parts spec%EV#DIV/0! #DIV/0! #DIV/0! 8.97% 基于零件变差base on parts variation%AV#DIV/0! #DIV/0! #DIV/0! 3.52% 基于过程变差base on process variation%RR#DIV/0! #DIV/0! #DIV/0! 9.64% 基于过程能力Base on process PP%PV#DIV/0! #DIV/0! #DIV/0! 99.53% 公式A Formula

12、Andc 14.56203294 公式B Formula BX2/nkr11019323.7308011 sumSQ(sum(men)/nr 11019323.7345633 SUMSQ(sum(1-10part)/kr 11019326.5500111极差图RangechartSUMSQ(sum(men-part)/r 11019326.5673000 sumSQ(all) 11019326.5857000 n=part k=men r=timeANOVA Table With Operator*Part Interaction ANOVA Table Without Operator*Pa

13、rt InteractionSource DF SS MS F P Source DF SS MS F PParts 9 2.81921 0.31325 416.83741 0.00000 Parts 9 2.81921 0.31325 765.28999 0.00000Operators 2 0.00376 0.00188 2.50320 0.10985 Operators 2 0.00376 0.00188 4.59574 0.01261Operators*Part 18 0.01353 0.00075 2.45048 0.00499Repeatability 60 0.01840 0.0

14、0031 Repeatability 78 0.03193 0.00041Total 89 2.85490 Total 89 2.85490Gauge R&R With Operator*Part Interaction Gauge R&R Without Operator*Part InteractionSource VarComp Stdev %Contribution %TV %Tolerance Source VarComp Stdev %Contribution%TV %ToleranceTotal Gauge R&R 0.00049 0.02219 1.40% 11.83% #DI

15、V/0! Total Gauge R&R 0.00046 0.02141 1.30% 11.41% #DIV/0!Repeatability 0.00031 0.01751 0.87% 9.33% #DIV/0! Repeatability 0.00041 0.02023 1.16% 10.78% #DIV/0!Reproducibility 0.00019 0.01364 0.53% 7.27% #DIV/0! Reproducibility 0.00005 0.00700 0.14% 3.73% #DIV/0!Operator 0.00004 0.00614 0.11% 3.27% #DI

16、V/0! Operator 0.00005 0.00700 0.14% 3.73% #DIV/0!Operators*Part 0.00015 0.01218 0.42% 6.49% #DIV/0!Part - To - Part 0.03472 0.18634 98.60% 99.30% #DIV/0! Part - To - Part 0.03476 0.18644 98.70% 99.35% #DIV/0!Total Variation 0.03521 0.18765 100.00% 100.00% #DIV/0! Total Variation 0.03522 0.18766 100.

17、00% 100.00% #DIV/0!AX=R=BXR=CX佃R礽PPX=-=X楍n慍xLX2AL=RDL屒4吳349.40000 349.60000 349.80000 350.00000 350.20000 350.40000 350.60000 AUCLxLCLxBC0.0000 0.0100 0.0200 0.0300 0.0400 0.0500 0.0600 0.0700 0.0800 CUCLRLCLRBARegular New QCPPPAP Other+praiseRcb/)(Page：2/3测量系统分析MSA GR&R-均值极差法Average and method报告编号R

18、eport NO. QAC-001/20150127量具名称Equipment 电阻测量工装产品类型Description 电阻应变计测量人员Operator 李永江测试日期TestTate2015.1.27量具编号Equipment NO.D612367 9CD251/001-085 基件编号Part NO.测量人员Operator 程静娅平价人数Appraisers3参数规格Specification规格上限Upper limit测量人员Operator 冯博试验次数Trials3测量单位Unit 规格下限Lower Limit 过程变差/过程能力Process Variation(/PP

19、)样 品数Samples10Datasheet： 0.029333 0.014333 0.611111分析方式Analysis mode 基于零件变差base on parts variation测量系统分析MSA % 总变差Total variation（TV）重复性Repeatability设备变差Equipment Variation(EV)= 8.97%= 0.017330 试验次数TrialsK12 0.88623 0.5908再现性Reproducibility評价人变差Appraiser Variation(AV)= 3.52%= 0.006797 评价人数AppraisersK

20、22 0.70713 0.5231重复性和再现性Repeatability and Reproducibility(R&R)零件数量Part QTYK3 = 9.64%= 0.018616 3 0.52314 0.44675 0.4043零件变差Parts Variation(PV) 6 0.3742公式A Formula A 7 0.3534 = 99.53%= 0.192256 8 0.33759 0.324910 0.3146总变差Total Variation(TV) 有效分辨率Availability Resolution(NDC)=1.41*（PV/R&R）基于零件变差Base o

21、n parts variation = 15= 0.193155 基于过程变差Base on process variation基于零件公差Base on parts spec基于过程能力Base on process PP判定标准Decide Criterion1) 0%R&R10%：量测系统状况良好Excellent； 判定Decide良好Excellent10%R&R30%：量测系统状况可以接收，但需改进Accepted but need improvement；30%R&R100%：量测系统必须改进Rejected and must be improved 。2) 数据分级数NDC经四

22、舍五入取整后，必须大于或等于5 The NDC is truncated to theinteger and ought to be greater than or equal to 5。分析评价措施Analysis andaction高精度数字万用表D612367与测阻夹9CD251/001-085重复性及再现性良好，完成能满足试验要求。分析人Analyst 李永江 日期Date 2015.1.27倱楋R噅()牮臶K噁/2- 2&池噅偬汒倫倽 )/(0噔噅琩琯琨氰氥瑬噁硴汸璴琽)/&(0%噔R)/(0噐=P=XDIF3PVKRp 6/TolV=s2P&+LS)-U(3PV KRp=GRT-2

23、 BPage：3/3测量系统分析MSA GR&R-变差数分析法ANOVA method报告编号Report NO. QAC-001/20150127量具名称Equipment电阻测量工装 产品类型Description电阻应变计 测量人员Operator 李永江 测试日期TestTate2015.1.27量具编号Equipment NO.D612367 9CD251/001-085 基件编号Part NO.测量人员Operator 程静娅平价人数Appraisers3参数规格Specification规格上限Upper limit测量人员Operator 冯博试验次数Trials3测量单位Un

24、it 规格下限Lower Limit 过程变差Process Variation(6)样 品数Samples10方差分析表格ANOVATable 包含With操作员和零件的相互作用Operator*Part Interaction变差来源Source自由DFDegree of freedom平方的总和SSSum of squares平均平方MSMean squareF-比率F-ratio 有效分辨率AvailabilityResolution(NDC)零件Parts 9 2.8192 0.3132 416.8374评价者Operators 2 0.0038 0.0019 2.5032评价者和零

25、件Operators*Part 18 0.0135 0.0008 2.4505设备Equipment 60 0.0184 0.0003 11.83790 11汇总Total 89 2.8549变差来源Source变差估计值Estimate of vaiance标准偏差Stdev %贡献率Contribution %总变差TV %公差Tolerance系统Total Gauge R&R 0.0005 0.0222 1.40% 11.83% #DIV/0!重复性Repeatability 0.0003 0.0175 0.87% 9.33% #DIV/0!再现性Reproducibility 0.0

26、002 0.0136 0.53% 7.27% #DIV/0!评价者Operator 0.0000 0.0061 0.11% 3.27% #DIV/0!相互作用InteractionINT=0 0 0 0 0 0零件Part 0.0347 0.1863 98.60% 99.30% #DIV/0!总变差Total Variation 0.0352 0.1877 100.00% 100.00% #DIV/0!Note:Refer to above tables because P value of operator*Part is less than setting value人与零件相互作用分界

27、P值The interaction between Operator and part boundaries P value is 0.25实际P值Actual P Value 0.005基于零件变差Base on parts variation%贡献率Contribution %总变差TV1.40% 11.83%基于公差Base on parts spec1.40% #DIV/0!可接收Accepted#DIV/0!分析方法Analysismethod基于零件变差Base on partsvariation结论Result 可接收Accepted分析评价措施Analysis andactio

28、n分析人Analyst 日期Date1 . 4 0 % 0 . 8 7 % 0 . 5 3 %9 8 . 6 0 %1 1 . 8 3 %9 . 3 3 %7 . 2 7 %9 9 . 3 0 %0 % 0 % 0 % 0 %变 差 比 重 C o m p o n e n t s o f v a r i a t ion系 统 T o t a l G a u g e R & R 重 复 性 R e p e a t a b ility 再 现 性 R e p r o d u c i bility0 %2 0 0 %贡 献 率 C o n tribution%总 变 差 TV%公 差 T o leranceR e s p o n s e b y p art1 2 3 4 5 6 7 8 9 1 03 4 9 . 3 3 4 9 . 5 3 4 9 . 7 3 4 9 . 9 3 5 0 . 1 3 5 0 . 3 3 5 0 . 5 R e s p o n s e b y o p e r a torA B C3 4 9 . 43 4 9 . 63 4 9 . 83 5 03 5 0 . 23 5 0 . 43 5 0 . 6