CPK分析表模板 自动计算.xlsx

PROCESSCAPABILITY

~EnterdatainYELLOWhighlightedcells~MustPassNormalityandGaugeRRtobeavalidstudy

PartNumber

DrawingNumber

Dimension#(permarkddwg) ID

Nominal 3.14

UpperTolerance 0.01

LowerTolerance 0.015

UpperSpec 3.15

LowerSpec 3.125

StatisticalSummary

Average 3.133

Range 0.008

High 3.137

Low 3.129

Sigma 0.002

Cp 2.185

Cpk 1.375

Data

Sample# Dimension#

ID

1 3.129

2 3.135

3 3.137

4 3.132

5 3.135

6 3.134

7 3.130

8 3.132

9 3.133

10 3.130

11 3.134

12 3.132

13 3.133

14 3.132

15 3.135

16 3.137

17 3.131

18 3.133

19 3.133

20 3.132

21 3.130

22 3.133

23 3.133

24 3.134

25 3.134

26 3.133

27 3.133

28 3.132

29 3.131

30