千分尺GR&R分析(EXCEL)

  • 格式:xls
  • 大小:350.50 KB
  • 文档页数:1

文件编号:RY-POF-QM-008
文件名称:MSA管理程序
版本:A
生效日期:2011.10.25


量具名称: 零件名称:
测量日期:

量具编号:测量参数:测量人员:A:陈海林B:徐茜伟C:张军军
量具量程:
25.4mm
3
零件编号

个数:10

312345678910

1.A12.7612.7622.7592.7752.7580.8760.8610.8620.8500.859
2.22.7692.7652.7652.7612.7550.8750.8610.8610.8520.859
3.32.7642.7682.7612.7662.7520.8770.8620.8610.8520.860
4.均值2.7652.7652.7622.7672.7550.8760.8610.8610.8510.8591.812
5. 极差0.0080.0060.0060.0140.0060.0020.0000.0010.0020.0010.0046
6.B12.7682.7612.7612.7632.7600.8770.8620.8630.8550.863
7.22.7642.7632.7612.7612.7580.8790.8600.8640.8530.859
8.32.7622.7612.7622.7612.7570.8770.8600.8640.8530.860
9.均值2.7652.7622.7612.7622.7580.8780.8610.8640.8540.8611.812
10. 极差0.0060.0020.0010.0020.0030.0020.0020.0010.0020.0040.0025
11.C12.7642.7592.7552.7652.7580.8760.8600.8670.8510.864
12.22.7632.7622.7592.7672.7570.8770.8610.8630.8510.859
13.32.7642.7662.7592.7632.7580.8750.8610.8630.8530.858
14.均值2.7642.7622.7582.7652.7580.8760.8610.8640.8520.8601.812
15. 极差0.0010.0070.0040.0040.0010.0020.0010.0040.0020.0060.0032
1.812
1.9124

17.0.00343试验次数23

18.0.0005D43.272.57
19.1.8157极差上限0.0088D300
20.1.8087极差下限0A21.881.02
注:
圈出那些超出控制限的值。查明原因並纠正。同一评价人采用最初的仪器重复这些读数或剔除这些值并由其余观测值再次平均

并计算R和极限值.

UCLx =1.81571.81571.81571.81571.81571.81571.81571.81571.81571.8157
LCLx =1.80871.80871.80871.80871.80871.80871.80871.80871.80871.8087
UCLR =
0.00880.00880.00880.00880.00880.00880.00880.00880.00880.0088

LCLR =
0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000



极差均值
最大均值差
均值上限
均值下限

16.评价人数试验次数极差图2012.9.28中热钢丝、电镀钢丝直径/mm1.81331.8122平均值1.81231.81231.81232.7642.7632.7602.7651.81171.81191.81191.8120 测量系统分析 MSA量具重复性和再现性数据表千分尺RY-SXWJQFC-0040.8520.860零件均值2.7570.8770.8610.863

012312345678910A 评价人012312345678910B 评价人0
1
2
3
12345678910
C 评价人

00.0020.0040.0060.0080.0112345678910B 评价人0
0.002
0.004
0.006
0.008
0.01
12345678910
C 评价人

0
0.5
1
1.5
2
2.5
3
12345678910
均值图

=AX
=AR

=BX
=BR

=CX
=CR
=X
=PR
P
X

()
=++=ÆÀ¼ÛÈËÊý/CBARRRR

0
0.001
0.002
0.003
0.004
0.005
0.006
0.007
12345678910
A 评价人

=-=XMinXMaxX
DIFF

=-=RAXLCL
X
2

=+=RAXUCL
X
2

==RDUCL

R4

==RDLCL
R3