msa測量系統(tǒng)分析自動表格

1、Page：13測量系統(tǒng)分析MSAGR&R數據記錄表DataWksheet報告編號ReptNO.量具名稱EquipmentName錫厚3D測試儀產品類型DeionPCBA測量人員OperatＡA測試日期TestTate2016411量具編號EquipmentNO.SMT0001基件編號PN12511820B23測量人員OperatＢB平價人數Appraisers3參數規(guī)格Dimension6.8規(guī)格上限USL7.8測量人員OperatＣC

2、試驗次數Trials3單位UnituM規(guī)格下限LSL5.4過程變差過程能力ProcessVariation(σPP)樣品數Samples10分析時機AnalyticalOccasion零件編號PartsNO.12345678910Total平均值Average1.A17.297.277.137.217.287.367.257.047.007.1071.937.1930002.27.287.267.127.227.287.357.267.

3、037.017.0771.887.1880003.37.297.267.147.217.297.367.257.067.017.0871.957.1950004.均值Mean7.286677.263337.130007.213337.283337.356677.253337.043337.006677.083337.192000SumA21.8621.7921.3921.6421.8522.0721.7621.1321.0221.252

4、15.76005.極差Range0.010.010.020.010.010.010.010.030.010.030.0150006.B17.187.267.207.287.157.347.277.066.916.9371.587.1580007.27.167.257.207.287.157.347.257.056.916.9511.3047.1540008.37.187.267.217.267.147.337.267.066.946.9

5、571.597.1590009.均值Mean7.173337.256677.203337.273337.146677.336677.260007.056676.920006.943337.157000SumB21.5221.7721.6121.8221.4422.0121.7821.1720.7620.83214.710010.極差Range0.020.010.010.020.010.010.020.010.030.020.016000

6、11.C16.977.267.187.167.087.407.297.186.966.8071.287.12800012.26.957.257.187.147.077.387.297.186.986.8571.277.12700013.36.947.267.167.157.067.377.277.176.966.8371.177.11700014.均值Mean6.953337.256677.173337.150007.070007.38

7、3337.283337.176676.966676.826677.124000SumC20.8621.7721.5221.4521.2122.1521.8521.5320.920.48213.7215.極差Range0.03000.01000.02000.02000.02000.03000.02000.01000.02000.05000.023000零件均值PartsMean7.1377787.2588897.1688897.21222

8、27.1666677.3588897.2655567.0922226.9644446.9511117.157667Total64.24000065.33000064.52000064.91000064.50000066.23000065.39000063.83000062.68000062.560000644.190.4077780.018000試驗次數Trials230.068000D43.272.5757.1760810.04635

9、0D3007.1392530.000000A21.881.023注:當分析結果超出要求后，利用均值極差圖分析原因Whenanalysisresultisoutofspecneedanalysetherootcausebymeanranget。均值圖meant12345678910UCLx7.17617.17617.17617.17617.17617.17617.17617.17617.17617.1761LCLx7.13937.1393

10、7.13937.13937.13937.13937.13937.13937.13937.1393UCLR0.04630.04630.04630.04630.04630.04630.04630.04630.04630.0463LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6σpp變差PV0.128287PV0.1282870.128287PV0.128

11、287TV0.400000TV0.000000#DIV0!TV0.133537基于公差baseonpartsspec%EV2.66%#DIV0!#DIV0!7.96%基于零件變差baseonpartsvariation%AV8.88%#DIV0!#DIV0!26.60%基于過程變差baseonprocessvariation%RR9.27%#DIV0!#DIV0!27.76%基于過程能力BaseonprocessPP%PV32.07%#

12、DIV0!#DIV0!96.07%公式AFmulac4.87879765公式BFmulaBX^2nkr4610.8972900sumSQ(sum(men))nr4610.9666700SUMSQ(sum(110part))kr4612.2494333極差圖RangetSUMSQ(sum(menpart))r4612.6704333sumSQ(all)4612.6775000n=partk=menr=timeANOVATableWithO

13、peratPartInteractionANOVATableWithoutOperatPartInteractionSourceDFSSMSFPSourceDFSSMSFPParts91.352140.150247.690940.00013Parts91.352140.1502432.670790.00000Operats20.069380.034691.775840.19775Operats20.069380.034697.54369

14、0.00094OperatsPart180.351620.01953165.858490.00000Repeatability600.007070.00012Repeatability780.358690.00460Total891.78021Total891.78021GaugeR&RWithOperatPartInteractionGaugeR&RWithoutOperatPartInteractionSourceVarCompSt

15、dev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%ToleranceTotalGaugeR&R0.007100.0842332.82%57.29%21.06%TotalGaugeR&R0.005600.0748425.71%50.71%18.71%Repeatability0.000120.010850.54%7.38%2.71%Repeatability0.

16、004600.0678121.11%45.95%16.95%Reproducibility0.006980.0835332.28%56.81%20.88%Reproducibility0.001000.031674.60%21.46%7.92%Operat0.000510.022482.34%15.29%5.62%Operat0.001000.031674.60%21.46%7.92%OperatsPart0.006470.080452

17、9.94%54.72%20.11%PartToPart0.014520.1205167.18%81.96%30.13%PartToPart0.016180.1272174.29%86.19%31.80%TotalVariation0.021620.14703100.00%100.00%36.76%TotalVariation0.021780.14759100.00%100.00%36.90%?AX=AR=BX=BR=CX=佃R礽ｘ=Pｒ

18、PX==X楍n?X慍x?X????］R???L?X2==RAX?LX2?=RD?L?屒4???????吳6.500006.600006.700006.800006.900007.000007.100007.200007.300007.400007.50000AUCLxLCLxBC0.00000.01000.02000.03000.04000.05000.0600CUCLRLCLRBARegularNewQCPPPAPOther==App

19、raisersRcRRbA)(RPage：33量具名稱Equipment錫厚3D測試儀產品類型DeionPCBA測量人員OperatＡA測試日期TestTate2016411量具編號EquipmentNO.SMT0001基件編號PartNO.12511820B23測量人員OperatＢB平價人數Appraisers3參數規(guī)格Specification6.8規(guī)格上限Upperlimit7.8測量人員OperatＣC試驗次數Trials3測

20、量單位UnituM規(guī)格下限LowerLimit5.4過程變差ProcessVariation(6σ)樣品數Samples10方差分析表格ANOVATable包含With操作員和零件的相互作用OperatPartInteraction變差來源Source自由DFDegreeoffreedom平方的總和SSSumofsquares平均平方MSMeansquareF比率Fratio有效分辨率AvailabilityResolution(NDC

21、)零件Parts91.35210.15027.6909評價者Operats20.06940.03471.7758評價者和零件OperatsPart180.35160.0195165.8585設備Equipment600.00710.00012.01725≈2≈2匯總Total891.7802變差來源Source變差估計值Estimateofvaiance標準偏差Stdev%貢獻率Contribution%總變差TV%公差Toleranc

22、e系統(tǒng)TotalGaugeR&R0.00710.084232.82%32.82%57.29%57.29%21.06%21.06%重復性Repeatability0.00010.01090.54%7.38%2.71%再現(xiàn)性Reproducibility0.00700.083532.28%56.81%20.88%評價者Operat0.00050.02252.34%15.29%5.62%相互作用InteractionINT=000000零件P

23、art0.01450.120567.18%81.96%30.13%總變差TotalVariation0.02160.1470100.00%100.00%36.76%Note:RefertoabovetablesbecausePvalueofoperatPartislessthansettingvalue人與零件相互作用分界P值TheinteractionbetweenOperatpartboundariesPvalueis0.25實際P

24、值ActualPValue0.000基于零件變差Baseonpartsvariation%貢獻率Contribution%總變差TV32.82%57.29%基于公差Baseonpartsspec32.82%21.06%需改善Mustbeimproved需改善Mustbeimproved分析方法Analysismethod基于零件變差Baseonpartsvariation結論Result需改善Mustbeimproved分析評價措施An

25、alysisaction分析人Analyst日期Date32.82%0.54%32.28%67.18%57.29%7.38%56.81%81.96%21%3%21%30%變差比重Componentsofvariation系統(tǒng)TotalGaugeR&R重復性Repeatability再現(xiàn)性Reproducibility0%200%%貢獻率Contribution%總變差TV%公差ToleranceResponsebypart1234567