谁能帮我解这张表格里运用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

九号半

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

九号半

忧郁者

你好！你可以把原表格发到我邮箱 我看看给你回复！

一个白痴

可以发到我邮箱，分析后给你，