MSA计量型测量系统分析GRR表格(全公式自动生成未加密)

3310
1234567
8910Total 1.A 10.29-0.56 1.340.47-0.80.020.59-0.31 2.26-1.36 1.942.2
0.41
-0.68
1.17
0.5
-0.92
-0.11
0.75
-0.2
1.99
-1.25
1.66
3.30.64-0.58 1.270.64-0.84-0.210.66-0.17 2.01-1.31 2.11
4.均值
Mean
0.44667-0.60667 1.260000.53667-0.85333-0.100000.66667-0.22667 2.08667-1.30667
0.190333Sum A 1.34
-1.82 3.78 1.61-2.56-0.32-0.68 6.26-3.92 5.71005. 极差
Rang
0.350.120.170.170.120.230.160.140.270.11
0.184000
6.B 10.08-0.47 1.190.01-0.56-0.20.47-0.63 1.8-1.680.01
7.2
0.25
-1.22
0.94
1.03
-1.2
0.22
0.55
0.08
2.12
-1.62
11.304
8.30.07-0.68 1.340.2-1.280.060.83-0.34 2.19-1.50.899.均值
Mean
0.13333-0.79000 1.156670.41333-1.013330.026670.61667-0.29667 2.03667-1.60000
0.068333
Sum B
0.4-2.37 3.47 1.24-3.040.08 1.85-0.89 6.11-4.8 2.050010. 极差
Rang
0.180.750.4 1.020.720.420.360.710.390.18
0.513000
11.C 10.04-1.380.880.14-1.46-0.290.02-0.46 1.77-1.49-2.23
12.2
-0.11
-1.13
1.090.2-1.07-0.670.01-0.56 1.45-1.77-
2.561
3.
3-0.15-0.960.67
0.11
-1.45
-0.49
0.21
-0.49
1.87
-2.16
-2.84
14.均值
Mean
-0.07333-1.15667
0.880000.15000-1.32667-0.483330.08000-0.50333 1.69667-1.80667-0.254333
Sum C -0.22
-3.47 2.64
0.45
-3.98
-1.45
0.24
-1.51
5.09
-5.42
-7.63
15. 极差
Rang
0.19000.4200
0.42000.09000.39000.38000.20000.10000.42000.6700
0.3280000.168889-0.85111
1.0988890.366667-1.06444-0.185550.454444-0.34222 1.940000-1.571110.0014441.520000-7.66000
9.890000 3.300000-9.58000-1.67000 4.090000-3.0800017.460000-14.1400
0.13 3.511111
0.34166
7
23D4 3.27 2.575
0.3509690.87979
2D300-0.348080.00000
A2 1.88 1.023
12345678910UCLx
0.35100.35100.35100.35100.35100.35100.35100.35100.35100.3510LCLx
-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481UCL R 0.87980.87980.87980.87980.87980.87980.87980.87980.87980.8798LCL R
0.00000.00000.00000.00000.0000
0.00000.00000.00000.00000.0000
公差：
6σpp
变差PV PV 1.104596PV TV
TV
#DIV/0!TV
基于公差base
%#DIV/0!基于零件变差
%
#DIV/0!基于过程变差
%#DIV/0!基于过程能力
%
#DIV/0!
公式A Formula
ndc 5.0936924
公式B Formula
X^2/nkr 0.0001878 3.167450088.3621222
91.888366
94.647300Source DF SS MS F P Source DF SS MS F P
Parts 988.361939.81799492.291420.00000988.361939.81799245.61
0.000002 3.16726 1.5836379.406050.000002 3.16726 1.5836339.6170.00000
180.358980.019940.433720.9741160 2.758930.0459878 3.117920.03997Total 8994.647118994.64711
Source VarComp Stdev %Contribu %TV %Toleranc Source VarComp Stdev %Contribut %TV
%Tolerance 0.098110.313228.27%28.75%#DIV/0!0.091430.302377.76%27.86%#DIV/0!0.045980.21443 3.87%19.68%#DIV/0!0.039970.19993 3.39%18.42%#DIV/0!
0.052120.22830 4.39%20.96%#DIV/0!0.051460.22684 4.37%20.90%#DIV/0!0.052120.22830 4.39%20.96%#DIV/0!0.051460.22684 4.37%20.90%#DIV/0!
0.000000.000000.00%0.00%#DIV/0!1.08867 1.0433991.73%95.78%#DIV/0! 1.08645 1.0423392.24%96.04%#DIV/0!
Reproducibility Reproducibility Operator Operator Operators*Part 极差图Range chart
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
Total Gauge R&R Total Gauge R&R Repeatability Repeatability Operators Operators*Part Repeatability Repeatability Total Part - To - Part Part - To - Part 注:当分析结果超出要求后，利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。

均值图
mean chart
1.104596 1.104596 1.1045960.0000000.000000 1.146135#DIV/0!#DIV/0!26.68%#DIV/0!#DIV/0!96.38%#DIV/0!#DIV/0!17.61%#DIV/0!#DIV/0!20.04%sumSQ(sum(men))/nr SUMSQ(sum(1-10part))/kr -0.284000
零件均值
Parts Mean Total
试验次数Trials 0.4446670.211000
0.0010000.1150000.089000
-0.223000-0.256000分析时机Analytical Occasion 零件编号Parts
NO.
平均值Average 0.1940000.166000试验次数
Trials 单位
Unit
MM 规格下限
LSL
过程变差/过程能力Process Variation(σ/PP)
样 品 数Samples
参数规格Dimension
规格上限
USL 测量人员Operator Ｃ
测试日期Test Tate 量具编号Equipment NO.
基件编号
P/N 测量人员Operator Ｂ平价人数Appraisers ××××××有限公司
测量系统分析MSA GR&R---数据记录表 Data Worksheet
报告编号Report NO.
量具名称
Equipment Name 产品类型
Description 测量人员Operator Ａ=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 3-3.00000-2.00000
-1.00000
0.00000
1.00000
2.00000
3.00000A UCLx
LCLx B C 0.0000
0.2000
0.4000
0.60000.80001.00001.2000
C
UCLR
LCLR B A
Regular
New QCP
PPAP
Other
=++=Appraisers Rc R R b A /)(R。