MSA测量系统分析表格

2015.1.27331012345678910Total1.A1350.41350.06349.8349.8349.78349.91349.94349.89349.8349.83499.192.2350.41350.02349.77349.78349.78349.93349.94349.91349.8349.833499.173.3350.41350.04349.78349.78349.76349.92349.97349.92349.8349.833499.214.均值Mean350.41000350.04000349.78333349.78667349.77333349.92000349.95000349.90667349.80000349.82000349.919000SumA1051.231050.121049.351049.361049.321049.761049.851049.721049.41049.4610497.57005.极差Range00.040.030.020.020.020.030.0300.030.0220006.B1350.36350.04349.76349.78349.78349.91349.9349.87349.78349.793498.977.2350.4350.04349.8349.77349.77349.92349.91349.88349.77349.811.3048.3350.39350.02349.82349.8349.81349.87349.92349.86349.84349.783499.119.均值Mean350.38333350.03333349.79333349.78333349.78667349.90000349.91000349.87000349.79667349.79000349.904667SumB1051.151050.11049.381049.351049.361049.71049.731049.611049.391049.3710497.140010.极差Range0.040.020.060.030.040.050.020.020.070.020.03700011.C1350.35350349.78349.77349.76349.94349.95349.9349.79349.853499.0912.2350.36350.01349.77349.78349.78349.92349.96349.93349.81349.813499.1313.3350.36350.02349.77349.75349.73349.89349.94349.89349.79349.823498.9614.均值Mean350.35667350.01000349.77333349.76667349.75667349.91667349.95000349.90667349.79667349.82667349.906000SumC1051.071050.031049.321049.31049.271049.751049.851049.721049.391049.4810497.1815.极差Range0.01000.02000.01000.03000.05000.05000.02000.04000.02000.04000.029000350.383333350.027778349.783333349.778889349.772222349.912222349.936667349.894444349.797778349.812222349.9098893153.4500003150.2500003148.0500003148.0100003147.9500003149.2100003149.4300003149.0500003148.1800003148.31000031491.890.6111110.02933323D43.272.575349.9398970.075533D300349.8798810.000000A21.881.02312345678910UCLx349.9399349.9399349.9399349.9399349.9399349.9399349.9399349.9399349.9399349.9399LCLx349.8799349.8799349.8799349.8799349.8799349.8799349.8799349.8799349.8799349.8799UCLR0.07550.07550.07550.07550.07550.07550.07550.07550.07550.0755LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6σpp变差PVPV0.192256PVTVTV#DIV/0!TV基于公差baseonpartsspec%EV#DIV/0!基于零件变差baseonpartsvariation%AV#DIV/0!基于过程变差baseonprocessvariation%RR#DIV/0!基于过程能力BaseonprocessPP%PV#DIV/0!公式AFormulaAndc14.56203294公式BFormulaBX^2/nkr11019323.730801111019323.734563311019326.550011111019326.567300011019326.5857000SourceDFSSMSFPSourceDFSSMSFPParts92.819210.31325416.837410.0000092.819210.31325765.289990.0000020.003760.001882.503200.1098520.003760.001884.595740.01261180.013530.000752.450480.00499600.018400.00031780.031930.00041Total892.85490892.85490SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance0.000490.022191.40%11.83%#DIV/0!0.000460.021411.30%11.41%#DIV/0!0.000310.017510.87%9.33%#DIV/0!0.000410.020231.16%10.78%#DIV/0!0.000190.013640.53%7.27%#DIV/0!0.000050.007000.14%3.73%#DIV/0!0.000040.006140.11%3.27%#DIV/0!0.000050.007000.14%3.73%#DIV/0!0.000150.012180.42%6.49%#DIV/0!0.034720.1863498.60%99.30%#DIV/0!0.034760.1864498.70%99.35%#DIV/0!0.035210.18765100.00%100.00%#DIV/0!0.035220.18766100.00%100.00%#DIV/0!测试日期TestTate量具编号EquipmentNO.D6123679CD251/001-085基件编号P/N测量人员OperatorＢ程静娅平价人数Appraisers测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.QAC-001/20150127量具名称EquipmentName电阻测量工装产品类型Description电阻应变计测量人员OperatorＡ李永江试验次数Trials单位UnitΩ规格下限LSL过程变差/过程能力ProcessVariation(σ/PP)样品数Samples参数规格Dimension规格上限USL测量人员OperatorＣ冯博349.921000349.897000349.906000349.911000349.909000349.913000分析时机AnalyticalOccasion零件编号PartsNO.平均值Average349.919000349.917000#DIV/0!3.52%sumSQ(sum(men))/nrSUMSQ(sum(1-10part))/kr349.896000零件均值PartsMeanTotal试验次数Trials0.014333Part-To-PartPart-To-PartTotalVariationTotalVariation注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。均值图meanchart0.1922560.1922560.1922560.0000000.0000000.193155#DIV/0!#DIV/0!9.64%#DIV/0!#DIV/0!99.53%#DIV/0!#DIV/0!8.97%#DIV/0!TotalGaugeR&RTotalGaugeR&RRepeatabilityRepeatabilityOperatorsOperators*PartRepeatabilityRepeatabilityTotalSUMSQ(sum(men-part))/rsumSQ(all)n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionPartsOperatorsGaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteractionReproducibilityReproducibilityOperatorOperatorOperators*Part极差图Rangechart=AX=AR=BX=BR=CX=CR=X=PRPX=-=XMinXMaxXDIFF=+=RAXUCLX2=-=RAXLCLX2==RDUCLR4==RDLCLR3349.40000349.60000349.80000350.00000350.20000350.40000350.60000AUCLxLCLxBC0.00000.02000.04000.06000.0800CUCLRLCLRBARegularNewQCPPPAPOther=++=AppraisersRcRRbA/)(RPage：1/3测试日期Test2015.1.27平价人数Appr3试验次数Trials3样品数100.0293330.0143330.611111分析方式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分析人Analyst日期Date测量系统分析MSAGR&R---均值极差法Averageandmethod量具编号EquipmentNO.D6123679CD251/