MAS测量数据分析.xls
Page:1/4测量系统分析MSA GR&R---数据记录表 Data Worksheet报告编号Report NO. XX/RD-010-ZL22量具名称Equipment Name 千分尺产品类型Description测量人员OperatorA测试日期Test Tate量具编号Equipment NO. No.1基件编号P/N测量人员OperatorB平价人数Appraisers参数规格Dimension 厚度规格上限USL测量人员OperatorC试验次数Trials单位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 #DIV/0!2. 2 0 #DIV/0!3. 3 0 #DIV/0!4. 均值Mean #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!Sum A 0 0 0 0 0 0 0 0 0 0 0.00005. 极差Range 0 0 0 0 0 0 0 0 0 0 0.0000006. B 1 0 #DIV/0!7. 2 11.304 #DIV/0!8. 3 0 #DIV/0!9. 均值Mean #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!Sum B 0 0 0 0 0 0 0 0 0 0 0.000010. 极差Range 0 0 0 0 0 0 0 0 0 0 0.00000011. C 1 0.65 0.47 0.49 0.55 0.59 0.5 0.51 0.45 0.51 0.51 5.23 0.52300012. 2 0.63 0.45 0.48 0.53 0.55 0.49 0.52 0.49 0.53 0.52 5.19 0.51900013. 3 0.62 0.52 0.51 0.55 0.54 0.47 0.52 0.47 0.55 0.53 5.28 0.52800014. 均值Mean 0.63333 0.48000 0.49333 0.54333 0.56000 0.48667 0.51667 0.47000 0.53000 0.52000 0.523333Sum C 1.9 1.44 1.48 1.63 1.68 1.46 1.55 1.41 1.59 1.56 15.715. 极差Range 0.0300 0.0700 0.0300 0.0200 0.0500 0.0300 0.0100 0.0400 0.0400 0.0200 0.034000零件均值Parts Mean 0.633333 0.480000 0.493333 0.543333 0.560000 0.486667 0.516667 0.470000 0.530000 0.520000 0.523333Total1.900000 1.440000 1.480000 1.630000 1.680000 1.460000 1.550000 1.410000 1.590000 1.560000 15.7 0.1633330.011333 试验次数Trials 2 3#DIV/0! D4 3.267 2.5750.534927 0.029183 D3 0 00.511739 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 0.5349 0.5349 0.5349 0.5349 0.5349 0.5349 0.5349 0.5349 0.5349 0.5349LCLx 0.5117 0.5117 0.5117 0.5117 0.5117 0.5117 0.5117 0.5117 0.5117 0.5117UCLR 0.0292 0.0292 0.0292 0.0292 0.0292 0.0292 0.0292 0.0292 0.0292 0.0292LCLR 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000公差: 6σ pp 变差PV 0.051385 PV 0.051385 0.051385 PV 0.051385TV 0.000000 TV 0.000000 #DIV/0! TV #DIV/0! 基于公差base on parts spec%EV#DIV/0! #DIV/0! #DIV/0! #DIV/0! 基于零件变差base on parts variation%AV#DIV/0! #DIV/0! #DIV/0! #DIV/0! 基于过程变差base on process variation%RR#DIV/0! #DIV/0! #DIV/0! #DIV/0! 基于过程能力Base on process PP%PV#DIV/0! #DIV/0! #DIV/0! #DIV/0! 公式A Formula Andc #DIV/0! #DIV/0! 公式B Formula BX^2/nkr#DIV/0! sumSQ(sum(men))/nr #DIV/0! SUMSQ(sum(1-10part))/kr #DIV/0!极差图RangechartSUMSQ(sum(men-part))/r #DIV/0! sumSQ(all) 8.2866000 n=part k=men r=timeANOVA Table With Operator*Part Interaction ANOVA Table Without Operator*Part InteractionSource DF SS MS F P Source DF SS MS F PParts 9 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Parts 9 #DIV/0! #DIV/0! #DIV/0! #DIV/0!Operators -1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Operators -1 #DIV/0! #DIV/0! #DIV/0! #DIV/0!Operators*Part -9 #DIV/0! #DIV/0! #DIV/0! #DIV/0!Repeatability 0 #DIV/0! #DIV/0! Repeatability -9 #DIV/0! #DIV/0!Total -1 #DIV/0! Total -1 #DIV/0!Gauge 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 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Gauge R&R #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!Repeatability #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Repeatability #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!Reproducibility #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Reproducibility #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!Operator #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Operator #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!Operators*Part #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!Part - To - Part #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Part - To - Part #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!AX=R=BXR=CX佃R礽xPrPX=-=X楍nĶ慍xͧ]ɁLĠX2ALØ=RDLĠ屒4혽쩒Ø吳Regular New QCPPPAP Other+praiseRcb/)(Page:2/4Total Variation #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Variation #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!测量系统分析MSA GR&R---均值极差法Average and method报告编号Report NO. XX/RD-010-ZL22量具名称Equipment 千分尺产品类型Description测量人员OperatorA测试日期TestTate1899/12/31量具编号Equipment NO. No.1基件编号Part NO.测量人员OperatorB平价人数Appraisers0参数规格Specification 厚度规格上限Upper limit测量人员OperatorC试验次数Trials0测量单位UnitMM 规格下限Lower Limit 过程变差/过程能力Process Variation(σ/PP)样 品数Samples10Datasheet: 0.011333 #DIV/0! 0.163333分析方式Analysis mode 基于零件变差base on parts variation测量系统分析MSA % 总变差Total variation(TV)重复性Repeatability-设备变差Equipment Variation(EV)= #DIV/0!= 0.006696 试验次数TrialsK12 0.88623 0.5908再现性Reproducibility-評价人变差Appraiser Variation(AV)= #DIV/0!= #DIV/0! 评价人数AppraisersK22 0.70713 0.5231重复性和再现性Repeatability and Reproducibility(R&R)零件数量Part QTYK3 = #DIV/0!= #DIV/0! 3 0.52314 0.44675 0.4043零件变差Parts Variation(PV) 6 0.3742公式A Formula A 7 0.3534 = #DIV/0!= 0.051385 8 0.33759 0.324910 0.3146总变差Total Variation(TV) 有效分辨率Availability Resolution(NDC)=1.41*(PV/R&R)基于零件变差Base on parts variation = #DIV/0!= #DIV/0! 基于过程变差Base on process variation基于零件公差Base on parts spec基于过程能力Base on process PP判定标准Decide Criterion1) 0%%R&R10%:量测系统状况良好Excellent; 判定Decide#DIV/0!10%≤%R&R≤30%:量测系统状况可以接收,但需改进Accepted but need improvement;30%%R&R100%:量测系统必须改进Rejected and must be improved 。 #DIV/0!2) 数据分级数NDC经四舍五入取整后,必须大于或等于5 The NDC is truncated to theinteger and ought to be greater than or equal to 5。分析评价措施Analysis andaction倱楋R噅´()I牮臶K噁¨/IJ2-´̽ 2&池噅偬汒倫倽 )/(〱0À噔噅´琩琯琨〱氰¾氥瑬噁硴汸璴琽)/&(〱0¿%噔R´)/(〱0À噐´==Pr=XDIF3PVKRp´ 6/TolV=s2P&+LS)-U(3PV KRp´=GRT-2 B极差图RangechartPage:3/4分析人Analyst 日期Date测量系统分析MSA GR&R---变差数分析法ANOVA method报告编号Report NO. XX/RD-010-ZL22量具名称Equipment千分尺 产品类型Description测量人员OperatorA测试日期TestTate1899/12/31量具编号Equipment NO.No.1 基件编号Part NO.测量人员OperatorB平价人数Appraisers0参数规格Specification厚度 规格上限Upper limit测量人员OperatorC试验次数Trials0测量单位UnitMM 规格下限Lower Limit 过程变差Process Variation(6σ)样 品数Samples10方差分析表格ANOVATable #DIV/0!操作员和零件的相互作用Operator*Part Interaction变差来源Source自由DFDegree of freedom平方的总和SSSum of squares平均平方MSMean squareF-比率F-ratio 有效分辨率AvailabilityResolution(NDC)零件Parts #DIV/0! #DIV/0! #DIV/0! #DIV/0!评价者Operators #DIV/0! #DIV/0! #DIV/0! #DIV/0!评价者和零件Operators*Part #DIV/0! #DIV/0! #DIV/0! #DIV/0!设备Equipment #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!汇总Total #DIV/0! #DIV/0!变差来源Source变差估计值Estimate of vaiance标准偏差Stdev %贡献率Contribution %总变差TV %公差Tolerance系统Total Gauge R&R #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!重复性Repeatability #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!再现性Reproducibility #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!评价者Operator #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!相互作用InteractionINT=0 0 0 0 0 0零件Part #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!总变差Total Variation #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!##人与零件相互作用分界 P值The interaction between Operator and part boundaries P value is 0.25实际P值Actual P Value #DIV/0!基于零件变差Base on parts variation%贡献率Contribution %总变差TV#DIV/0! #DIV/0!基于公差Base on parts spec#DIV/0! #DIV/0!#DIV/0!#DIV/0!分析方法Analysismethod基于零件变差Base on partsvariation结论Result #DIV/0!分析评价措施Analysis andactionPage:4/4分析人Analyst 日期Date