GRR表格MSA第四版(手册例)
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
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.41-0.56 1.340.47-0.80.020.59-0.31 2.01-1.36 1.81
7.2
0.41
-0.68
1.17
0.5
-0.92
-0.11
0.75
-0.2
1.99
-1.25
11.304
8.30.64-0.58 1.270.64-0.84-0.210.66-0.17 2.01-1.31 2.119.均值
Mean
0.48667-0.60667 1.260000.53667-0.85333-0.100000.66667-0.22667 2.00333-1.30667
0.186000
Sum B 1.46
-1.82 3.78 1.61-2.56-0.32-0.68 6.01-3.92 5.580010. 极差
Rang
0.230.120.170.170.120.230.160.140.020.11
0.147000
11.C 10.29-0.56 1.340.47-0.80.020.59-0.31 2.26-1.36 1.94
12.2
0.41
-0.68
1.170.5-0.92-0.110.75-0.2 1.99-1.25 1.6613.
30.64-0.58 1.27
0.64
-0.84
-0.21
0.66
-0.17
2.01
-1.31
2.11
14.均值
Mean
0.44667-0.60667
1.260000.53667-0.85333-0.100000.66667-0.22667
2.08667-1.306670.190333
Sum C 1.34
-1.82 3.78
1.61
-2.56
-0.3
2
-0.68
6.26
-3.92
5.71
15. 极差
Rang
0.35000.1200
0.17000.17000.12000.23000.16000.14000.27000.1100
0.1840000.460000-0.60666
1.2600000.536667-0.85333-0.100000.666667-0.22666
2.058889-1.306660.1888894.140000-5.46000
11.340000 4.830000-7.68000-0.90000 6.000000-2.0400018.530000-11.7600
17 3.365556
0.17166
7
23
D4 3.27 2.575
0.3645040.44204
2D3000.0132740.00000
A2 1.88 1.023
1
2345678910UCLx 0.36450.36450.36450.36450.36450.36450.36450.36450.36450.3645LCLx 0.01330.01330.01330.01330.01330.01330.01330.01330.01330.0133UCL R 0.44200.44200.44200.44200.44200.44200.44200.44200.44200.4420LCL R
0.00000.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.00000.0000
0.0000
公差:
6σpp
变差
PV PV 1.058804PV TV
TV
#DIV/0!TV 基于公差base
%#DIV/0!基于零件变差%#DIV/0!基于过程变差%
#DIV/0!基于过程能力%#DIV/0!
公式A Formula ndc 14.720010
公式B Formula
X^2/nkr 3.2111111
3.211486786.720911186.738000
87.300200Source DF SS MS F P Source DF SS MS F
P Parts 983.509809.278879993.19500.00000983.509809.278871250.1
0.0000020.000380.000190.202230.8187320.000380.000190.0253
0.97502180.016710.000930.09909 1.00000600.562200.00937780.578910.00742
Total 8984.089098984.08909
Source VarComp Stdev %Contribu %TV %Toleranc Source VarComp Stdev %Contribut %TV %Tolerance 0.009370.096800.90%9.49%#DIV/0!0.007420.08615#N/A #N/A
#N/A 0.009370.096800.90%9.49%#DIV/0!0.007420.08615#N/A #N/A #N/A 0.000000.000000.00%0.00%#DIV/0!0.000000.00000#N/A #N/A
#N/A 0.000000.000000.00%0.00%#DIV/0!0.000000.00000#N/A #N/A #N/A
0.000000.000000.00%0.00%#DIV/0!
1.03088 1.0153299.10%99.55%#DIV/0! 1.03016 1.0149799.28%99.64%#DIV/0!1.04025 1.01993100.00%100.00%#DIV/0! 1.03758 1.01862100.00%100.00
#DIV/0!
产品类型
Description 测量系统分析MSA GR&R---数据记录表 Data Worksheet
报告编号Report NO.
测量人员Operator A测试日期Test Tate 试验次数
Trials 测量人员Operator B平价人数Appraisers 量具名称
Equipment Name 量具编号Equipment NO.
基件编号
P/N 参数规格Dimension
规格上限
USL 测量人员Operator C
样 品 数Samples
分析时机Analytical Occasion 单位
Unit
MM 规格下限
LSL
过程变差/过程能力Process Variation(σ/PP)
0.004333零件编号Parts
NO.
平均值Average 0.1940000.1660000.211000
0.1810000.1660000.211000
0.1940000.1660000.211000
零件均值
Parts Mean Total
试验次数Trials 注:当分析结果超出要求后,利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。
1.058804 1.058804 1.058804均值图
mean chart
0.0000000.000000 1.063650#DIV/0!#DIV/0!9.54%#DIV/0!#DIV/0!0.00%#DIV/0!#DIV/0!9.54%SUMSQ(sum(men-part))/r sumSQ(all)n=part k=men Total Gauge R&R With Operator*Part Interaction Gauge R&R Without Operator*Part Interaction ANOVA Table With Operator*Part Interaction ANOVA Table Without Operator*Part Interaction
#DIV/0!#DIV/0!99.54%
sumSQ(sum(men))/nr SUMSQ(sum(1-10part))/kr Parts Operators Operators Operators*Part Repeatability Repeatability Reproducibility Reproducibility Operator Operator Total Gauge R&R Total Gauge R&R Repeatability Repeatability Total Variation Total Variation 极差图Range chart
Operators*Part Part - To - Part Part - To - Part =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-1.50000
-1.00000-0.500000.000000.500001.000001.500002.000002.50000A
UCL x LCL x B C
0.00000.10000.20000.30000.40000.5000C
UCL
R LCL
R
B
A Regular
New QCP
PPAP
Other
=++=Appraisers Rc R R b A /)(R