第四版--MSA分析

2012..03.0535391012345678910Total1.A17.96.26.36.46.26.15.95.86.46.463.62.286.16.36.46.1665.86.46.563.63.38.16.26.46.56.26.15.966.36.564.24.均值Mean8.000006.166676.333336.433336.166676.066675.933335.866676.366676.466676.380000SumA2418.51919.318.518.217.817.619.119.4191.40005.极差Range0.20.10.10.10.10.10.10.20.10.10.1200006.B17.86.36.96.56.16.16.25.96.56.564.87.27.96.36.86.7666.166.56.411.3048.386.26.76.56.16.1666.56.464.59.均值Mean7.900006.266676.800006.566676.066676.066676.100005.966676.500006.433336.466667SumB23.718.820.419.718.218.218.317.919.519.3194.000010.极差Range0.20.10.20.20.10.10.20.100.10.13000011.C17.86.16.36.35.96.165.76.26.162.512.27.76.16.26.35.96.25.95.66.26.262.313.37.766.36.35.96.165.66.36.262.414.均值Mean7.733336.066676.266676.300005.900006.133335.966675.633336.233336.166676.240000SumC23.218.218.818.917.718.417.916.918.718.5187.215.极差Range0.10000.10000.10000.00000.00000.10000.10000.10000.10000.10000.0800007.8777786.1666676.4666676.4333336.0444446.0888896.0000005.8222226.3666676.3555566.36222270.90000055.50000058.20000057.90000054.40000054.80000054.00000052.40000057.30000057.200000572.62.0555560.11000023D43.272.5756.4747520.283250D3006.2496920.000000A21.881.02312345678910UCLx6.47486.47486.47486.47486.47486.47486.47486.47486.47486.4748LCLx6.24976.24976.24976.24976.24976.24976.24976.24976.24976.2497UCLR0.28330.28330.28330.28330.28330.28330.28330.28330.28330.2833LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6σpp变差PVPV0.646678PVTVTV#DIV/0!TV基于公差baseonpartsspec%EV#DIV/0!基于零件变差baseonpartsvariation%AV#DIV/0!基于过程变差baseonprocessvariation%RR#DIV/0!基于过程能力BaseonprocessPP%PV#DIV/0!公式AFormulaAndc6.769744862公式BFormulaBX^2/nkr3643.00844443643.79333333669.55555563670.94666673671.2200000SourceDFSSMSFPSourceDFSSMSFPParts926.547112.9496887.582110.00000926.547112.94968261.580930.0000020.784890.3924411.652490.0005720.784890.3924434.802430.00000180.606220.033687.392950.00000600.273330.00456780.879560.01128Total8928.211568928.21156SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance0.026220.161937.49%27.36%-24.29%0.023980.154866.84%26.16%-23.23%0.004560.067491.30%11.41%-10.12%0.011280.106193.22%17.94%-15.93%0.021670.147206.19%24.87%-22.08%0.012710.112723.63%19.04%-16.91%0.011960.109363.41%18.48%-16.40%0.012710.112723.63%19.04%-16.91%0.009710.098532.77%16.65%-14.78%0.324000.5692192.51%96.18%-85.38%0.326490.5713993.16%96.52%-85.71%ReproducibilityReproducibilityOperatorOperatorOperators*Part极差图RangechartSUMSQ(sum(men-part))/rsumSQ(all)n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionPartsOperatorsGaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteractionOperatorsOperators*PartRepeatabilityRepeatabilityTotalPart-To-PartPart-To-PartTotalGaugeR&RTotalGaugeR&RRepeatabilityRepeatability注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。均值图meanchart0.6466780.6466780.646678-20.20%#DIV/0!20.39%-97.00%#DIV/0!97.90%-9.75%#DIV/0!(0.666667)0.000000-17.70%#DIV/0!零件均值PartsMeanTotal试验次数Trials0.2266676.450000sumSQ(sum(men))/nrSUMSQ(sum(1-10part))/kr6.2400009.84%0.6605556.2500006.23000017.86%6.480000分析时机AnalyticalOccasion零件编号PartsNO.平均值Average6.470000样品数Samples测量人员OperatorＣ向俾香6.3600006.3600006.420000单位Unitum规格下限LSL过程变差/过程能力ProcessVariation(σ/PP)平价人数Appraisers量具名称EquipmentNameX-Ray膜厚仪参数规格Dimension0.1-30规格上限USL试验次数Trials量具编号EquipmentNO.ST-200基件编号P/NMP-SU001-03-C测量人员OperatorＢ张小磊产品类型Description汽配件测量人员OperatorＡ曾毅测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.Q074/2012.03.05测试日期TestTate=AX=AR=BX=BR=CX=CR=X=PRPX=-=XMinXMaxXDIFF=+=RAXUCLX2=-=RAXLCLX2==RDUCLR4==RDLCLR30.000002.000004.000006.000008.0000010.00000AUCLxLCLxBC0.00000.05000.10000.15000.20000.25000.3000CUCLRLCLRBARegularNewQCPPPAPOther=++=AppraisersRcRRbA/)(RPage：1/40.350220.59180100.00%100.00%-88.77%0.350470.59201100.00%100.00%-88.80%测试日期Test2012..03.05平价人数Appr35试验次数Trials39样品数100.1100000.2266672.055556分析方式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分析评价措施Analysisandaction通过数据分析，量具的再现性和重复性是合适的。基于过程能力BaseonprocessPP1)   0%%R&R10%：量测系统状况良好Excellent；判定Decide可接收Accepted10%≤%R&R≤30%：量测系统状况可以接收，但需改进Acceptedbutneedimprovement；30%%R&R100%：量测系统必须改进Rejectedandmustbeimproved。2)数据分级数NDC经四舍五入取整后，必须大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。0.646678有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）0.660555基于过程变差Baseonprocessvariation17.86%0.11797420.39%基于零件公差Baseonpartsspec公式AFormulaA97.90%基于零件变差Baseonpartsvariation7um规格下限LowerLimit0.134690Datasheet：基于零件变差baseonpartsvariation测量系统分析MSA%总变差Totalvariation（TV）9.84%0.064988过程变差/过程能力ProcessVariation(σ/PP)参数规格Specification0.1-30规格上限Upperlimit测量人员OperatorＣ向俾香测量单位Unit测量系统分析MSAGR&R---均值极差