标准下载论坛

标题: 谁能帮我解这张表格里运用MSA测试的情况（采用万用表收集的数据 [打印本页]
作者: 九号半    时间: 2011-10-27 00:41
标题: 谁能帮我解这张表格里运用MSA测试的情况（采用万用表收集的数据




Date:
2010 Aug., 08
Upper spec limit:




Gage Identification:
Vernier Caliper 06643737
Lower spec limit:




Part Number:
1S0429
Nominal




Comments:
8.20 / 8.00 〈2〉


Operator:
Xieqianghua
Operator:
Tangjie
Operator:
Hekeying

Trial 1
Trial 2
Trial 3
Range
Trial 1
Trial 2
Trial 3
Range
Trial 1
Trial 2
Trial 3
Range

1
13.1200
13.1400
13.1200
0.0200
13.1200
13.1400
13.1200
0.0200
13.1200
13.1300
13.1200
0.0100

2
13.1200
13.1200
13.1100
0.0100
13.1300
13.1200
13.1100
0.0200
13.1200
13.1300
13.1100
0.0200

3
13.1200
13.1200
13.1200
0.0000
13.1200
13.1300
13.1200
0.0100
13.1200
13.1200
13.1300
0.0100

4
13.1300
13.1200
13.1200
0.0100
13.1300
13.1200
13.1200
0.0100
13.1300
13.1200
13.1200
0.0100

5
13.1400
13.1400
13.1300
0.0100
13.1400
13.1400
13.1300
0.0100
13.1400
13.1400
13.1300
0.0100

6
13.1100
13.1300
13.1200
0.0200
13.1200
13.1300
13.1200
0.0100
13.1100
13.1300
13.1200
0.0200

7
13.1300
13.1200
13.1200
0.0100
13.1300
13.1200
13.1200
0.0100
13.1300
13.1200
13.1300
0.0100

8
13.1200
13.1200
13.1600
0.0400
13.1300
13.1200
13.1600
0.0400
13.1200
13.1300
13.1600
0.0400

9
13.1300
13.1300
13.1400
0.0100
13.1300
13.1300
13.1400
0.0100
13.1300
13.1300
13.1400
0.0100

10
13.1300
13.1500
13.1600
0.0300
13.1300
13.1400
13.1600
0.0300
13.1300
13.1400
13.1500
0.0200
作者: 九号半    时间: 2011-10-27 00:41




X bar
13.128
X bar
13.129
X bar
13.128333

R bar
0.016
R bar
0.017
R bar
0.016


13.128

R barbar
0.0163333
X bar diff:
0.001000
# Trials
2
3
UCLR = R barbar x D4
13.129

D4
3.27
2.58
UCLR:
0.042140
13.12833




































EV
= (Rbarbar)
x (K1)
Trials
2
3
%EV
= 100 x
[ (EV) /

=0.016333
x 3.05
K1
4.56
3.05
=100 x
0.04982
K3,"specs wrong",K3-K4))'>














Operators
2
3

K2
3.65
2.7















AV
=sqrt([(Xbardiff)x(K2)]^2
-[(EV^2/(nxr)])
n = number samples
%AV
= 100 x
[ (AV) /

((E25*IF(K22="",G37,H37))^2),0,(((E25*IF(K22="",G37,H37))^2)-(B35^2/(F42*IF(K22="",2,3)))))))'>



0,10,IF(B18>0,9,IF(B17>0,8,IF(B16>0,7,IF(B15>0,6,IF(B14>0,5,IF(B13>0,4,IF(B12>0,3,"run more samples"))))))))'>n = 10
=100 x
0.000000
K3,"specs wrong",K3-K4))'>



















R&R
= SQRT ((EV)^2
+(AV)^2)
R&R
= SQRT ((%EV)^2
+(%AV)^2)

= sqrt(0.049816667)^2
+(0)^2
= sqrt(24.90833333)^2
+(0)^2



























作者: 九号半    时间: 2011-10-27 00:41









作者: 忧郁者    时间: 2011-10-27 00:41
你好！你可以把原表格发到我邮箱 我看看给你回复！
作者: 一个白痴    时间: 2011-10-27 00:41
可以发到我邮箱，分析后给你，



欢迎光临 标准下载论坛 (http://bbs.bzxzk.net/) Powered by Discuz! X3.2