测量系统分析MSA-GR&R

331012345678910Total1.A10.29-0.561.340.47-0.80.020.59-0.312.26-1.361.942.20.41-0.681.170.5-0.92-0.110.75-0.21.99-1.251.663.30.64-0.581.270.64-0.84-0.210.66-0.172.01-1.312.114.均值Mean0.44667-0.606671.260000.53667-0.85333-0.100000.66667-0.226672.08667-1.306670.190333SumA1.34-1.823.781.61-2.56-0.32-0.686.26-3.925.71005.极差Range0.350.120.170.170.120.230.160.140.270.110.1840006.B10.08-0.471.190.01-0.56-0.20.47-0.631.8-1.680.017.20.25-1.220.941.03-1.20.220.550.082.12-1.6211.3048.30.07-0.681.340.2-1.280.060.83-0.342.19-1.50.899.均值Mean0.13333-0.790001.156670.41333-1.013330.026670.61667-0.296672.03667-1.600000.068333SumB0.4-2.373.471.24-3.040.081.85-0.896.11-4.82.050010.极差Range0.180.750.41.020.720.420.360.710.390.180.51300011.C10.04-1.380.880.14-1.46-0.290.02-0.461.77-1.49-2.2312.2-0.11-1.131.090.2-1.07-0.670.01-0.561.45-1.77-2.5613.3-0.15-0.960.670.11-1.45-0.490.21-0.491.87-2.16-2.8414.均值Mean-0.07333-1.156670.880000.15000-1.32667-0.483330.08000-0.503331.69667-1.80667-0.254333SumC-0.22-3.472.640.45-3.98-1.450.24-1.515.09-5.42-7.6315.极差Range0.19000.42000.42000.09000.39000.38000.20000.10000.42000.67000.3280000.168889-0.8511111.0988890.366667-1.064444-0.1855560.454444-0.3422221.940000-1.5711110.0014441.520000-7.6600009.8900003.300000-9.580000-1.6700004.090000-3.08000017.460000-14.1400000.133.5111110.34166723D43.272.5750.3509690.879792D300-0.3480810.000000A21.881.02312345678910UCLx0.35100.35100.35100.35100.35100.35100.35100.35100.35100.3510LCLx-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481UCLR0.87980.87980.87980.87980.87980.87980.87980.87980.87980.8798LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6σpp变差PVPV1.104596PVTVTV#DIV/0!TV基于公差baseonpartsspec%EV#DIV/0!基于零件变差baseonpartsvariation%AV#DIV/0!基于过程变差baseonprocessvariation%RR#DIV/0!基于过程能力BaseonprocessPP%PV#DIV/0!公式AFormulaAndc5.093692473公式BFormulaBX^2/nkr0.00018783.167450088.362122291.888366794.6473000SourceDFSSMSFPSourceDFSSMSFPParts988.361939.81799492.291420.00000988.361939.81799245.613910.0000023.167261.5836379.406050.0000023.167261.5836339.617250.00000180.358980.019940.433720.97411602.758930.04598783.117920.03997Total8994.647118994.64711SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance0.098110.313228.27%28.75%#DIV/0!0.091430.302377.76%27.86%#DIV/0!0.045980.214433.87%19.68%#DIV/0!0.039970.199933.39%18.42%#DIV/0!0.052120.228304.39%20.96%#DIV/0!0.051460.226844.37%20.90%#DIV/0!0.052120.228304.39%20.96%#DIV/0!0.051460.226844.37%20.90%#DIV/0!0.000000.000000.00%0.00%#DIV/0!1.088671.0433991.73%95.78%#DIV/0!1.086451.0423392.24%96.04%#DIV/0!测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.产品类型Description测量人员OperatorＡ测试日期TestTate量具编号EquipmentNO.基件编号P/N测量人员OperatorＢ平价人数Appraisers量具名称EquipmentName测量人员OperatorＣ参数规格Dimension规格上限USL0.2110000.001000试验次数Trials单位UnitMM规格下限LSL过程变差/过程能力ProcessVariation(σ/PP)样品数Samples分析时机AnalyticalOccasion零件编号PartsNO.平均值Average0.1940000.166000sumSQ(sum(men))/nrSUMSQ(sum(1-10part))/kr-0.28400017.61%1.146135-0.223000-0.256000零件均值PartsMeanTotal试验次数Trials0.1150000.0890000.444667#DIV/0!#DIV/0!0.0000000.0000001.1045961.104596#DIV/0!#DIV/0!20.04%#DIV/0!#DIV/0!26.68%#DIV/0!#DIV/0!96.38%注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。均值图meanchart1.104596TotalGaugeR&RTotalGaugeR&RRepeatabilityRepeatabilityPart-To-PartPart-To-PartGaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteractionOperatorsOperators*PartRepeatabilityRepeatabilityTotalsumSQ(all)n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionPartsOperators极差图RangechartSUMSQ(sum(men-part))/rReproducibilityReproducibilityOperatorOperatorOperators*Part=AX=AR=BX=BR=CX=CR=X=PRPX=-=XMinXMaxXDIFF=+=RAXUCLX2=-=RAXLCLX2==RDUCLR4==RDLCLR3-3.00000-2.00000-1.000000.000001.000002.000003.00000AUCLxLCLxBC0.00000.20000.40000.60000.80001.00001.2000CUCLRLCLRBARegularNewQCPPPAPOther=++=AppraisersRcRRbA/)(RPage：1/41.186781.08939100.00%100.00%#DIV/0!1.177881.08530100.00%100.00%#DIV/0!测试日期Test1900/1/0平价人数Appr3试验次数Trials3样品数100.3416670.4446673.511111分析方式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)==判定标准DecideCriterionTotalVariationTotalVariation量具名称Equipment产品类型Description测量人员OperatorＡ极差图Rangechart测量人员OperatorＢ报告编号ReportNO.量具编号EquipmentNO.基件编号PartNO.测量单位Unit测量系统分析MSAGR&R---均值极差法Averageandmethod参数规格Specification规格上限Upperlimit测量人员OperatorＣ0.305766Datasheet：基于零件变差baseonpartsvariation测量系统分析MSA%总变差Totalvariation（TV）17.61%0.20185720.04%0.229667MM规格下限LowerLimit过程变差/过程能力ProcessVariation(σ/PP)1.104596有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）26.68%基于零件公差Baseonpartsspec公式AFormulaA96.38%基于零件变差Baseonpartsvariation51.146135基于过程变差Baseonprocessvariation基于过程能力BaseonprocessPP1)   0%%R&R1