MAS测量数据分析

1012345678910Total1.A102.203.304.均值Mean#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!SumA00000000000.00005.极差Range00000000000.0000006.B107.211.3048.309.均值Mean#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!SumB00000000000.000010.极差Range00000000000.00000011.C10.650.470.490.550.590.50.510.450.510.515.2312.20.630.450.480.530.550.490.520.490.530.525.1913.30.620.520.510.550.540.470.520.470.550.535.2814.均值Mean0.633330.480000.493330.543330.560000.486670.516670.470000.530000.520000.523333SumC1.91.441.481.631.681.461.551.411.591.5615.715.极差Range0.03000.07000.03000.02000.05000.03000.01000.04000.04000.02000.0340000.6333330.4800000.4933330.5433330.5600000.4866670.5166670.4700000.5300000.5200000.5233331.9000001.4400001.4800001.6300001.6800001.4600001.5500001.4100001.5900001.56000015.70.1633330.01133323D43.272.5750.5349270.029183D3000.5117390.000000A21.881.02312345678910UCLx0.53490.53490.53490.53490.53490.53490.53490.53490.53490.5349LCLx0.51170.51170.51170.51170.51170.51170.51170.51170.51170.5117UCLR0.02920.02920.02920.02920.02920.02920.02920.02920.02920.0292LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6σpp变差PVPV0.051385PVTVTV#DIV/0!TV基于公差baseonpartsspec%EV#DIV/0!基于零件变差baseonpartsvariation%AV#DIV/0!基于过程变差baseonprocessvariation%RR#DIV/0!基于过程能力BaseonprocessPP%PV#DIV/0!公式AFormulaAndc#DIV/0!#DIV/0!公式BFormulaBX^2/nkr#DIV/0!#DIV/0!#DIV/0!#DIV/0!8.2866000SourceDFSSMSFPSourceDFSSMSFPParts9#DIV/0!#DIV/0!#DIV/0!#DIV/0!9#DIV/0!#DIV/0!#DIV/0!#DIV/0!-1#DIV/0!#DIV/0!#DIV/0!#DIV/0!-1#DIV/0!#DIV/0!#DIV/0!#DIV/0!-9#DIV/0!#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!-9#DIV/0!#DIV/0!Total-1#DIV/0!-1#DIV/0!SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!均值图meanchart极差图RangechartOperators*PartPart-To-PartPart-To-PartRepeatabilityRepeatabilityReproducibilityReproducibilityOperatorOperatorRepeatabilityRepeatabilityTotalGaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteractionTotalGaugeR&RTotalGaugeR&RANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionPartsOperatorsOperatorsOperators*Part#DIV/0!#DIV/0!#DIV/0!sumSQ(sum(men))/nrSUMSQ(sum(1-10part))/krSUMSQ(sum(men-part))/rsumSQ(all)n=partk=menr=time#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.0000000.000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。0.0513850.0513850.0513850.528000零件均值PartsMeanTotal试验次数Trials#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.5230000.519000分析时机AnalyticalOccasion零件编号PartsNO.平均值Average#DIV/0!#DIV/0!试验次数Trials单位UnitMM规格下限LSL过程变差/过程能力ProcessVariation(σ/PP)样品数Samples参数规格Dimension厚度规格上限USL测量人员OperatorＣ测试日期TestTate量具编号EquipmentNO.No.1基件编号P/N测量人员OperatorＢ平价人数Appraisers测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.XX/RD-010-ZL22量具名称EquipmentName千分尺产品类型Description测量人员OperatorＡ=AX=AR=BX=BR=CX=CR=X=PRPX=-=XMinXMaxXDIFF=+=RAXUCLX2=-=RAXLCLX2==RDUCLR4==RDLCLR300.20.40.60.8100.20.40.60.81RegularNewQCPPPAPOther=++=AppraisersRcRRbA/)(RPage：1/4#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!测试日期Test1900/1/0平价人数Appr0试验次数Trials0样品数100.011333#DIV/0!0.163333分析方式Analysismode重复性Repeatability－设备变差EquipmentVariation(EV)==试验次数TrialsK120.886230.5908再现性Reproducibility－評价人变差AppraiserVariation(AV)==评价人数AppraiseK220.707130.5231重复性和再现性RepeatabilityandReproducibility(R&R)零件数量PartK3==30.523140.446750.4043零件变差PartsVariation(PV)60.374270.3534==80.337590.3249100.3146总变差TotalVariation(TV)==判定标准DecideCriterion#DIV/0!极差图Rangechart判定Decide#DIV/0!10%≤%R&R≤30%：量测系统状况可以接收，但需改进Acceptedbutneedimprovement；30%%R&R100%：量测系统必须改进Rejectedandmustbeimproved。2)数据分级数NDC经四舍五入取整后，必须大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。分析评价措施Analysisandaction#DIV/0!基于过程变差Baseonprocessvariation基于零件公差Baseonpartsspec基于过程能力BaseonprocessPP1)   0%%R&R10%：量测系统状况良好Excellent；公式AFormulaA#DIV/0!0.051385有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）基于零件变差Baseonpartsvariation#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Datasheet：基于零件变差baseonpartsvariation测量系统分析MSA%总变差Totalvariation（TV）#DIV/0!0.006696测量单位UnitMM规格下限LowerLimit过程变差/过程能力ProcessVariation(σ/PP)参数规格Specification厚度规格上限Upperlimit测量人员OperatorＣ量具编号EquipmentNO.No.1基件编号PartNO.测量人员OperatorＢ测量系统分析MSAGR&R---均值极差法Averageandmethod报告编号ReportNO.XX/RD-010-ZL22量具名称Equipment千分尺产品类型Description测量人员OperatorＡTotalVariationTotalVariation1KREV?=()()nrEVKXAVDIFF/222-?=22&AVEVRR+=)/(100%TVEVEV?=)/(100%TVAVAV=)/&(100&%TVRRRR?=)/(100%TVPVPV?==R=PR0=XDIFF3PVKRp=6/TolTV==TV22PVR&RTV+=LSL)/6PP-USL(TV=3PVAKRp=GRRTV-=2PVBPage：2/4分析人Analyst日期Date测试日期1900/1/0平价人数0试验次数0样品数10#DI