MSA测量系统分析自动表格
2016/4/11
37.835.4
10
1
2
3
4
5
6
7
8
9
10
Total 1.A 17.297.277.137.217.287.367.257.047.007.1071.932.2
7.28
7.26
7.12
7.22
7.28
7.35
7.26
7.03
7.01
7.07
71.88
3.37.297.267.147.217.297.367.257.067.017.0871.95
4.均值
Mean 7.286677.263337.130007.213337.283337.356677.253337.043337.006677.083337.192000
Sum A 21.86
21.7921.3921.6421.8522.0721.7621.1321.0221.25215.760
05. 极差
Rang
0.010.010.020.010.010.010.010.030.010.03
0.0150006.B 17.187.267.207.287.157.347.277.06 6.91 6.9371.58
7.2
7.167.257.207.287.157.347.257.05 6.91 6.95
11.3048.37.187.267.217.267.147.337.267.06 6.94 6.9571.59
9.均值
Mean 7.173337.256677.203337.273337.146677.336677.260007.05667 6.92000 6.943337.157000
Sum B 21.52
21.7721.6121.8221.4422.0121.7821.1720.7620.83214.710
010. 极差
Rang
0.020.010.010.020.010.010.020.010.030.020.016000
11.C 1 6.977.267.187.167.087.407.297.18 6.96 6.8071.28
12.2
6.95
7.257.187.147.077.387.297.18 6.98 6.8571.2713.
3 6.947.26
7.16
7.15
7.06
7.37
7.27
7.17
6.96
6.83
71.17
14.均值
Mean
6.95333
7.25667
7.173337.150007.070007.383337.283337.17667 6.96667 6.82667
7.124000
Sum C 20.86
21.7721.52
21.45
21.21
22.15
21.85
21.53
20.9
20.48
213.72
15. 极差
Rang
0.03000.0100
0.02000.02000.02000.03000.02000.01000.02000.0500
0.0230007.1377787.258889
7.1688897.2122227.1666677.3588897.2655567.092222 6.964444 6.95111
1
7.15766764.24000065.3300
00
64.52000064.91000064.50000066.23000065.39000063.83000062.68000062.5600
00
644.190.407778
0.01800
23D4 3.27 2.575
7.1760810.04635
0D3007.1392530.00000
A2 1.88 1.023
12345678910UCLx
7.17617.17617.17617.17617.17617.17617.17617.17617.17617.1761LCLx
7.13937.13937.13937.13937.13937.13937.13937.13937.13937.1393UCL R 0.04630.04630.04630.04630.04630.04630.04630.04630.04630.0463LCL R
0.00000.00000.00000.00000.0000
0.00000.00000.00000.00000.0000
公差：
6σpp
变差PV PV 0.128287PV TV
TV
#DIV/0!TV
基于公差base
%#DIV/0!基于零件变差
%
#DIV/0!基于过程变差
%#DIV/0!基于过程能力
%
#DIV/0!
公式A Formula
ndc 4.8787976
公式B Formula
X^2/nkr 4610.89724610.96664612.24943
4612.6704
4612.6775Source DF SS MS F P Source DF SS MS F P
Parts 9 1.352140.150247.690940.000139 1.352140.1502432.670
0.0000020.069380.03469 1.775840.1977520.069380.034697.54360.00094
180.351620.01953165.858490.00000600.007070.00012780.358690.00460Total 89 1.7802189 1.78021
Source VarComp Stdev %Contribu %TV %Toleranc Source VarComp Stdev %Contribut %TV
%Tolerance
0.007100.0842332.82%57.29%21.06%0.005600.0748425.71%50.71%18.71%0.000120.010850.54%7.38% 2.71%0.004600.0678121.11%45.95%16.95%0.006980.0835332.28%56.81%20.88%0.001000.03167 4.60%21.46%7.92%0.000510.02248 2.34%15.29% 5.62%0.001000.03167 4.60%21.46%7.92%
0.006470.0804529.94%54.72%20.11%0.014520.1205167.18%81.96%30.13%0.016180.1272174.29%86.19%31.80%
测试日期
Test Tate 量具编号
Equipment NO.
SMT 0001
基件编号
P/N 12511820B-23测量人员
Operator ＢB
平价人数Appraisers 测量系统分析MSA GR&R---数据记录表 Data Worksheet
报告编号Report NO.
量具名称
Equipment Name 锡厚3D测试仪
产品类型
Description
PCBA
测量人员
Operator ＡA
试验次数
Trials 单位
Unit
uM 规格下限
LSL
过程变差/过程能力Process Variation(σ/PP)
样 品 数Samples
参数规格
Dimension
6.8
规格上限
USL 测量人员
Operator Ｃ
C
7.1950007.1580007.154000
7.1590007.1280007.127000分析时机Analytical Occasion 零件编号Parts
NO.
平均值Average 7.1930007.188000
#DIV/0!26.60%sumSQ(sum(men))/nr SUMSQ(sum(1-10part))/kr 7.117000
零件均值
Parts Mean Total
试验次数Trials 0.068000Part - To - Part Part - To - Part 注:当分析结果超出要求后，利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。
均值图
mean chart
0.1282870.1282870.1282870.4000000.0000000.1335379.27%#DIV/0!27.76%32.07%#DIV/0!96.07%2.66%#DIV/0!7.96%8.88%Total Gauge R&R Total Gauge R&R Repeatability Repeatability Operators Operators*Part Repeatability Repeatability Total SUMSQ(sum(men-part))/r sumSQ(all)n=part k=men ANOVA Table With Operator*Part Interaction ANOVA Table Without Operator*Part Interaction
Parts Operators Gauge R&R With Operator*Part Interaction Gauge R&R Without Operator*Part Interaction
Reproducibility Reproducibility Operator Operator Operators*Part 极差图Range chart
=A X =A R =B X =B R =C X =C R =X =P R P X =-=X Min X Max X DIFF =
+=R A X UCL X 2=-=R A X LCL X 2==R D UCL R 4==R D LCL R 36.400006.60000
6.80000
7.00000
7.20000
7.40000
7.60000A UCLx
LCLx B C 0.0000
0.0100
0.0200
0.03000.04000.05000.0600
C
UCLR
LCLR B A
Regular
New QCP
PPAP
Other
=++=Appraisers Rc R R b A /)(R
分析人
分析评价措施Analysis and
action 日期Date