x-ray测厚仪msa分析报告

测量系统分析MSAGR&R---数据记录表DataWorksheet,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,报告编号ReportNO.,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

"量具名称

EquipmentName",,,,X-Ray测厚仪,,"产品类型

Description",,,,"测量人员

OperatorＡ",,,,"测试日期

TestTate",,

,,,,,,,,,,,,,,,,,

"量具编号

EquipmentNO.",,,,,,"基件编号

P/N",,,,"测量人员

OperatorＢ",,,,"平价人数

Appraisers",,3

,,,,,,,,,,,,,,,,,

"参数规格

Dimension",,,,15,,"规格上限

USL",,16,,"测量人员

OperatorＣ",,,,"试验次数

Trials",,3

,,,,,,,,,,,,,,,,,

"单位

Unit",,,,um,,"规格下限

LSL",,14,"过程变差/过程能力

ProcessVariation(σ/PP)",,,,,"样品数

Samples",,10

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

分析时机AnalyticalOccasion,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

零件编号PartsNO.,,,,1,2,3,4,5,6,7,8,9,10,Total,平均值Average,

1.,A,,1,15.220,14.400,15.240,14.820,15.250,15.470,14.970,15.170,14.820,15.420,150.78,15.078000,

2.,,,2,15.310,14.370,15.230,14.730,15.240,15.460,14.870,15.240,14.770,15.330,150.55,15.055000,

3.,,,3,15.320,14.370,15.110,14.870,15.370,15.350,14.910,15.130,14.770,15.310,150.51,15.051000,

4.,,,均值Mean,15.28333,14.38000,15.19333,14.80667,15.28667,15.42667,14.91667,15.18000,14.78667,15.35333,,,15.061333

,,,SumA,45.85,43.14,45.58,44.42,45.86,46.28,44.75,45.54,44.36,46.06,451.8400,,

5.,,,极差Range,0.1,0.03,0.13,0.14,0.13,0.12,0.1,0.11,0.05,0.11,,,0.102000

6.,B,,1,15.440,14.920,15.320,14.820,15.450,15.220,14.870,15.340,14.820,15.440,151.64,15.164000,

7.,,,2,15.320,14.880,15.210,14.730,15.360,15.250,14.770,15.350,14.710,15.370,11.304,15.095000,

8.,,,3,15.470,14.910,15.240,14.710,15.470,15.320,14.730,15.280,14.730,15.420,151.28,15.128000,

9.,,,均值Mean,15.41000,14.90333,15.25667,14.75333,15.42667,15.26333,14.79000,15.32333,14.75333,15.41000,,,15.129000

,,,SumB,46.23,44.71,45.77,44.26,46.28,45.79,44.37,45.97,44.26,46.23,453.8700,,

10.,,,极差Range,0.15,0.04,0.11,0.11,0.11,0.1,0.14,0.07,0.11,0.07,,,0.101000

11.,C,,1,15.440,14.910,15.320,14.820,15.290,15.280,14.820,15.310,14.820,15.420,151.43,15.143000,

12.,,,2,15.420,14.870,15.410,14.780,15.310,15.280,14.780,15.270,14.770,15.510,151.4,15.140000,

13.,,,3,15.370,14.920,15.330,14.840,15.360,15.330,14.750,15.290,14.730,15.480,151.4,15.140000,

14.,,,均值Mean,15.41000,14.90000,15.35333,14.81333,15.32000,15.29667,14.78333,15.29000,14.77333,15.47000,,,15.141000

,,,SumC,46.23,44.7,46.06,44.44,45.96,45.89,44.35,45.87,44.32,46.41,454.23,,

15.,,,极差Range,0.07,0.05,0.09,0.06,0.07,0.05,0.07,0.04,0.09,0.09,,,0.068000

"零件均值

PartsMean",,,,15.367778,14.727778,15.267778,14.791111,15.344444,15.328889,14.830000,15.264444,14.771111,15.411111,,,15.110444

Total,,,,138.310000,132.550000,137.410000,133.120000,138.100000,137.960000,133.470000,137.380000,132.940000,138.700000,1359.94,,0.683333

,,,,,,,,0.090333,,,,试验次数Trials,,,2,3

,,,,,,,,0.079667,,,,,,D4,3.267,2.575

,,,,,,15.202855,,,,,0.232608,,,D3,0,0

,,,,,,15.018033,,,,,0.000000,,,A2,1.88,1.023

"注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。",,,,,,,,,,,,,,,,

"均值图

meanchart",,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,1,2,3,4,5,6,7,8,9,10,,,

,,,UCLx,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,,,

,,,LCLx,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,,,

,,,UCLR,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,,,

,,,LCLR,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,公差：,,,,6σ,,,pp,变差,,,,

,,,,PV,0.214977,,,PV,0.214977,,0.214977,PV,0.214977,,,

,,,,TV,0.333333,,,TV,0.000000,,#DIV/0!,TV,0.225178,,,基于公差baseonpartsspec

,,%EV,,,16.01%,,,,#DIV/0!,,#DIV/0!,,23.70%,,,基于零件变差baseonpartsvariation

,,%AV,,,12.16%,,,,#DIV/0!,,#DIV/0!,,17.99%,,,基于过程变差baseonprocessvariation

,,%RR,,,20.10%,,,,#DIV/0!,,#DIV/0!,,29.76%,,,基于过程能力BaseonprocessPP

,,%PV,,,64.49%,,,,#DIV/0!,,#DIV/0!,,95.47%,,,公式AFormulaA

,,,,ndc,4.523635354,,,,,,,,,,,公式BFormulaB

,,,,X^2/nkr,20549.2978178,,sumSQ(sum(men))/nr,,,20549.4085133,SUMSQ(sum(1-10part))/kr,,,20556.0457333,,

"极差图

Rangechart",,SUMSQ(sum(men-part))/r,,,,20556.8340667,,sumSQ(all),,20556.9886000,,,,n=partk=menr=time,,

,,,ANOVATableWithOperator*PartInteraction,,,,,,,ANOVATableWithoutOperator*PartInteraction,,,,,,

,,,Source,,DF,SS,MS,F,P,Source,,DF,SS,MS,F,P

,,,Parts,,9,6.74792,0.74977,19.91600,0.00000,Parts,,9,6.74792,0.74977,70.27633,0.00000

,,,Operators,,2,0.11070,0.05535,1.47020,0.25621,Operators,,2,0.11070,0.05535,5.18779,0.00739

,,,Operators*Part,,18,0.67764,0.03765,14.61686,0.00000,,,,,,,

,,,Repeatability,,60,0.15453,0.00258,,,Repeatability,,78,0.83217,0.01067,,

,,,Total,,89,7.69078,,,,Total,,89,7.69078,,,

,,,GaugeR&RWithOperator*PartInteraction,,,,,,,GaugeR&RWithoutOperator*PartInteraction,,,,,,

,,,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance

,,,TotalGaugeR&R,,0.01486,0.12188,15.81%,39.76%,36.57%,TotalGaugeR&R,,0.01216,0.11026,12.90%,35.91%,33.08%

,,,Repeatability,,0.00258,0.05075,2.74%,16.55%,15.22%,Repeatability,,0.01067,0.10329,11.32%,33.64%,30.99%

,,,Reproducibility,,0.01228,0.11082,13.07%,36.15%,33.25%,Reproducibility,,0.00149,0.03859,1.58%,12.57%,11.58%

,,,Operator,,0.00059,0.02429,0.63%,7.92%,7.29%,Operator,,0.00149,0.03859,1.58%,12.57%,11.58%

,,,Operators*Part,,0.01169,0.10812,12.44%,35.27%,32.44%,,,,,,,

,,,Part-To-Part,,0.07912,0.28129,84.19%,91.76%,84.39%,Part-To-Part,,0.08212,0.28657,87.10%,93.33%,85.97%

,,,TotalVariation,,0.09398,0.30656,100.00%,100.00%,91.97%,TotalVariation,,0.09428,0.30705,100.00%,100.00%,92.12%

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

测量系统分析MSAGR&R---均值极差法Averageandmethod,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,报告编号ReportNO.,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

"量具名称

Equipment",,,,X-Ray测厚仪,,"产品类型

Description",,,,"测量人员

OperatorＡ",,,,,"测试日期

TestTate",

,,,,,,,,,,,,,,,,,

"量具编号

EquipmentNO.",,,,,,"基件编号

PartNO.",,,,"测量人员

OperatorＢ",,,,,"平价人数

Appraisers",3

,,,,,,,,,,,,,,,,,

"参数规格

Specification",,,,15,,"规格上限

Upperlimit",,16,,"测量人员

OperatorＣ",,,,,"试验次数

Trials",3

,,,,,,,,,,,,,,,,,

"测量单位

Unit",,,,um,,"规格下限

LowerLimit",,14,"过程变差/过程能力

ProcessVariation(σ/PP)",,,,,,"样品数

Samples",10

,,,,,,,,,,,,,,,,,

Datasheet：,,,,,0.090333,,,0.079667,,,0.683333,,,,,

,,,,,,,,,,,分析方式Analysismode,基于零件变差baseonpartsvariation,,,,

,测量系统分析MSA,,,,,,,,,,%总变差Totalvariation（TV）,,,,,

,重复性Repeatability－设备变差EquipmentVariation(EV),,,,,,,,,,,,,,,

,,,,,,,,,,,,=,23.70%,,,

,=,0.053369,,,,,,,"试验次数

Trials",K1,,,,,,

,,,,,,,,,2,0.8862,,,,,,

,,,,,,,,,3,0.5908,,,,,,

,再现性Reproducibility－評价人变差AppraiserVariation(AV),,,,,,,,,,,,,,,

,,,,,,,,,,,,=,17.99%,,,

,=,0.040519,#DIV/0!,#DIV/0!,,,,,"评价人数

Appraisers",K2,,,,,,

,,,,,,,,,2,0.7071,,,,,,

,,,,,,,,,3,0.5231,,,,,,

,重复性和再现性RepeatabilityandReproducibility(R&R),,,,,,,,,,,,,,,

,,,,,,,,,"零件数量

PartQTY",K3,,=,29.76%,,,

,=,0.067007,,,,,,,3,0.5231,,,,,,

,,,,,,,,,4,0.4467,,,,,,

,,,,,,,,,5,0.4043,,,,,,

,零件变差PartsVariation(PV),,,,,,,,6,0.3742,,,,,,

,,,,,,公式AFormulaA,,,7,0.3534,,=,95.47%,,,

,=,0.214977,,,,,,,8,0.3375,,,,,,

,,,,,,,,,9,0.3249,,,,,,

,,,,,,,,,10,0.3146,,,,,,

,总变差TotalVariation(TV),,,,,,,,,,有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）,,,,,

,,,,,,,基于零件变差Baseonpartsvariation,,,,,=,5,,,

,=,0.225178,,,,,基于过程变差Baseonprocessvariation,,,,,,,,,

,,,,,,,基于零件公差Baseonpartsspec,,,,,,,,,

,,,,,,,基于过程能力BaseonprocessPP,,,,,,,,,

,判定标准DecideCriterion,,,,,,,,,,,,,,,

1)

0%<%R&R<10%：量测系统状况良好Excellent；,,,,,,,,,,,判定Decide,,可接收Accepted,,,

10%≤%R&R≤30%：量测系统状况可以接收，但需改进Acceptedbutneedimprovement；,,,,,,,,,,,,,,,,

30%<%R&R<100%：量测系统必须改进Rejectedandmustbeimproved。,,,,,,,,,,,,,,,,

2)数据分级数NDC经四舍五入取整后，必须大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。,,,,,,,,,,,,,,,,

"分析评价措施

Analysisandaction",,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,分析人Analyst,,Lake_dong,,,日期Date,2011/11/1,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,Operator,,#REF!,#REF!,#REF!,,#REF!,,,,,,,

,,,,,,,,,,,,,,,,,

,,,Part-To-Part,,#REF!,#REF!,#REF!,,#REF!,,,,,,,

,,,TotalVariation,,#REF!,#REF!,#REF!,,#REF!,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

测量系统分析MSAGR&R---变差数分析法ANOVAmethod,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,报告编号ReportNO.,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

"量具名称

Equipment",,,,X-Ray测厚仪,,"产品类型

Description",,,,"测量人员

OperatorＡ",,,,,"测试日期

TestTate",1899/12/31

,,,,,,,,,,,,,,,,,

"量具编号

EquipmentNO.",,,,,,"基件编号

PartNO.",,,,"测量人员

OperatorＢ",,,,,"平价人数

Appraisers",3

,,,,,,,,,,,,,,,,,

"参数规格

Specification",,,,15,,"规格上限

Upperlimit",,16,,"测量人员

OperatorＣ",,,,,"试验次数

Trials",3

,,,,,,,,,,,,,,,,,

"测量单位

Unit",,,,um,,"规格下限

LowerLimit",,14,"过程变差

ProcessVariation(6σ)",,,,,,"样品数

Samples",10

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,"方差分析表格

ANOVATable",,,包含With,操作员和零件的相互作用Operator*PartInteraction,,,,,,,,,,,

,"变差来源

Source",,,,"自由DF

Degreeoffreedom",,"平方的总和SS

Sumofsquares",,"平均平方MS

Meansquare",,"F-比率

F-ratio",,有效分辨率AvailabilityResolution(NDC),,,

,零件Parts,,,,9,,6.7479,,0.7498,,19.9160,,,,,

,评价者Operators,,,,2,,0.1107,,0.0553,,1.4702,,,,,

,评价者和零件Operators*Part,,,,18,,0.6776,,0.0376,,14.6169,,,,,

,设备Equipment,,,,60,,0.1545,,0.0026,,,,3.25406,≈3,,

,汇总Total,,,,89,,7.6908,,,,,,,,,

,,,,,,,,,,,,,,,,,

,"变差来源

Source",,,,"变差估计值

Estimateofvaiance",,"标准偏差

Stdev",,%贡献率Contribution,,%总变差TV,,%公差Tolerance,,,

,系统TotalGaugeR&R,,,,0.0149,,0.1219,,15.81%,,39.76%,,36.57%,,,

,重复性Repeatability,,,,0.0026,,0.0507,,2.74%,,16.55%,,15.22%,,,

,再现性Reproducibility,,,,0.0123,,0.1108,,13.07%,,36.15%,,33.25%,,,

,评价者Operator,,,,0.0006,,0.0243,,0.63%,,7.92%,,7.29%,,,

,相互作用InteractionINT=0,,,,0,,0,,