1
UseofMinitab
forParetoDiagram
用Minitab件做柏拉图
Preparedby:JosephHo
Date:Jun26,2013
2
在Minitab上开一张新的工作表
3
从Excel复制数据资料到Minitab工作表
4
从Excel复制数据资料到Minitab工作表
5
从Excel复制数据资料到Minitab工作表
6
从工具列Stat中选择ParetoChart
7
当原始数据是没有频率时
选用这模式
8
软件自动将数据频率计算,做出柏拉图
Count11111165442111
Percent333333201713137333
Cum%83879093971002037506370737780
Defectdescription
W
i
r
e
L
e
a
d
D
a
m
a
g
e
S
o
l
d
e
r
S
h
o
r
t
s
P
o
s
i
t
i
o
n
E
l
e
c
t
P
a
r
t
s
M
i
s
s
i
n
g
S
o
l
d
e
r
M
i
s
s
i
n
g
E
l
e
c
t
P
a
r
t
s
F
o
r
e
i
g
n
M
a
t
e
r
i
a
l
D
a
m
a
g
e
d
P
a
r
t
s
C
o
r
r
o
s
i
o
n
B
e
l
o
w
H
o
l
e
s
S
o
l
d
e
r
B
e
n
d
R
a
d
i
u
s
P
o
o
r
W
e
t
t
i
n
g
E
x
c
e
s
s
S
o
l
d
e
r
C
o
l
d
S
o
l
d
e
r
I
n
s
u
f
f
i
c
i
e
n
t
S
o
l
d
e
r
30
25
20
15
10
5
0
100
80
60
40
20
0
C
o
unt
Pe
r
c
e
n
t
ParetoChartofDefectdescription
9
原数据有频率提供时
选择这模式
10
所有缺陷的频率都显示出来
Cost/eachdefect1.01.00.40.40.40.40.40.210.010.01.61.01.01.01.01.0
Percent331111113232533333
Cum%909394959798991003265707377808386
Defect
P
o
o
r
W
e
t
t
i
n
g
S
o
l
d
e
r
S
h
o
r
t
s
D
a
m
a
g
e
d
P
a
r
t
s
C
o
r
r
o
s
i
o
n
C
o
l
d
S
o
l
d
e
r
B
e
l
o
w
H
o
l
e
s
W
i
r
e
L
e
a
d
D
a
m
a
g
e
S
o
l
d
e
r
B
e
n
d
R
a
d
i
u
s
M
i
s
s
i
n
g
S
o
l
d
e
r
M
i
s
c
E
l
e
c
P
a
r
t
L
e
a
d
L
e
n
g
t
h
F
o
r
e
i
g
n
M
a
t
e
r
i
a
l
E
x
c
e
s
s
S
o
l
d
e
r
I
n
s
u
f
f
i
c
i
e
n
t
S
o
l
d
e
r
P
o
s
i
t
i
o
n
E
l
e
c
t
P
a
r
t
s
M
i
s
s
i
n
g
E
l
e
c
t
P
a
r
t
s
35
30
25
20
15
10
5
0
100
80
60
40
20
0
Co
s
t
/
e
a
c
h
d
e
f
e
c
t
Pe
r
c
e
n
t
ParetoChartofDefect
16种缺陷
11
将95%以後的缺陷合并
12
柏拉图将95%後的缺陷合并成为Other
Cost/eachdefect1.01.00.40.41.410.010.01.61.01.01.01.01.0
Percent331153232533333
Cum%909394951003265707377808386
Defect
O
t
h
e
r
C
o
l
d
S
o
l
d
e
r
B
e
l
o
w
H
o
l
e
s
W
i
r
e
L
e
a
d
D
a
m
a
g
e
S
o
l
d
e
r
B
e
n
d
R
a
d
i
u
s
M
i
s
s
i
n
g
S
o
l
d
e
r
M
i
s
c
E
l
e
c
P
a
r
t
L
e
a
d
L
e
n
g
t
h
F
o
r
e
i
g
n
M
a
t
e
r
i
a
l
E
x
c
e
s
s
S
o
l
d
e
r
I
n
s
u
f
f
i
c
i
e
n
t
S
o
l
d
e
r
P
o
s
i
t
i
o
n
E
l
e
c
t
P
a
r
t
s
M
i
s
s
i
n
g
E
l
e
c
t
P
a
r
t
s
35
30
25
20
15
10
5
0
100
80
60
40
20
0
Co
s
t
/
e
a
c
h
d
e
f
e
c
t
Pe
r
c
e
n
t
ParetoChartofDefect
13
TotalCost3391690166613491349163160130129
Percent4.924.223.919.319.32.32.31.91.8
Cum%100.024.248.167.586.889.191.493.395.1
Defect
O
t
h
e
r
L
e
a
d
L
e
n
g
t
h
S
o
l
d
e
r
S
h
o
r
t
s
M
i
s
s
i
n
g
E
l
e
c
t
P
a
r
t
s
E
x
c
e
s
s
S
o
l
d
e
r
B
e
l
o
w
H
o
l
e
s
P
o
o
r
W
e
t
t
i
n
g
I
n
s
u
f
f
i
c
i
e
n
t
S
o
l
d
e
r
P
o
s
i
t
i
o
n
E
l
e
c
t
P
a
r
t
s
7000
6000
5000
4000
3000
2000
1000
0
100
80
60
40
20
0
To
t
a
lC
o
s
t
Pe
r
c
e
n
t
ParetoChartofDefect
80%线显示4个缺陷是我们的重点改善问题
14
活用Minitab软件,
寻找统计学给你的帮助和乐趣。
数据解释一切!
|
|