Fracción
Producción Producto Número de Fracción
Muestra Defectuosa
(N) Defectuoso Defectos Defectuosa (p)
(p)
1 96 8 12 0.083 0.083
2 99 12 14 0.121 0.121
3 99 17 21 0.172 0.172
4 100 16 21 0.160 0.160
5 100 9 15 0.090 0.090
6 100 15 18 0.150 0.150
7 100 18 22 0.180 0.180
8 100 14 20 0.140 0.140
9 100 15 19 0.150 0.150
10 99 14 20 0.141 0.141
11 100 17 19 0.170 0.170
12 100 15 17 0.150 0.150
13 100 15 20 0.150 0.150
14 94 8 9 0.085 0.085
15 94 10 13 0.106 0.106
16 99 22 32 0.222 0.222
17 100 15 21 0.150 0.150
18 97 12 19 0.124 0.124
19 87 9 12 0.103 0.103
20 100 12 12 0.120 0.120
21 100 13 18 0.130 0.130
22 98 18 24 0.184 0.184
23 97 14 19 0.144 0.144
24 97 13 19 0.134 0.134
2356 331 436 3.361
Producción Total de Total de Suma de
Total Producto Defectos Fracción
Defectuoso Defectuosa
Pbarra =
LCI LC LCS
0.034 0.140 0.247
0.036 0.140 0.245 Chart Title
0.036 0.140 0.245 0.300
0.036 0.140 0.245
0.036 0.140 0.245 0.250
0.036 0.140 0.245
0.200
0.036 0.140 0.245
0.036 0.140 0.245 0.150
0.036 0.140 0.245
0.100
0.036 0.140 0.245
0.036 0.140 0.245 0.050
0.036 0.140 0.245
0.000
0.036 0.140 0.245 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
0.033 0.140 0.248
0.033 0.140 0.248 Column H Column I Column J Column K
0.036 0.140 0.245
0.036 0.140 0.245
0.035 0.140 0.246
0.029 0.140 0.252
0.036 0.140 0.245
0.036 0.140 0.245
0.035 0.140 0.246
0.035 0.140 0.246
0.035 0.140 0.246
0.140 (Total de Producto Defectuoso)/(Total de Producto Producido)
(331/2356)=0.140492
le
14 15 16 17 18 19 20 21 22 23 24
Column J Column K
PROCEDIMIENTO DE CARTA DE CONTROL POR ATRIBUTOS
GRAFICA np
NOTA: Total piezas 1250 n= 50
m= 25
Ingrese los datos en las celdas de amarillo
Nº MuestraMuestra (const)
Nº Art. Def.(np) DIAS LSC
1 50 1 1 4.8107
2 50 3 2 4.8107
3 50 4 3 4.8107
4 50 4 4 4.8107
5 50 3 5 4.8107
6 50 4 6 4.8107
7 50 1 7 4.8107
8 50 1 8 4.8107
9 50 0 9 4.8107
10 50 1 10 4.8107
11 50 0 11 4.8107
12 50 1 12 4.8107
13 50 1 13 4.8107
14 50 1 14 4.8107
15 50 2 15 4.8107
16 50 1 16 4.8107
17 50 1 17 4.8107
18 50 0 18 4.8107
19 50 0 19 4.8107
20 50 2 20 4.8107
21 50 1 21 4.8107
22 50 1 22 4.8107
23 50 0 23 4.8107
24 50 0 24 4.8107
25 50 1 25 4.8107
TOTAL 34
p 0.0272 p = Articulos defectuosos / Total de piezas
np 1.3600 np = Articulos defectuosos / Total de muestras
HALLAMOS LOS LÍMITES DE CONTROL
LSC = +3 = 4.8107
LC = = 1.3600
LIC = -3 = -2.0907
DIAS LSC LC LIC np
1 4.8107 1.3600 -2.0907 1
2 4.8107 1.3600 -2.0907 3
3 4.8107 1.3600 -2.0907 4
4 4.8107 1.3600 -2.0907 4
5 4.8107 1.3600 -2.0907 3
6 4.8107 1.3600 -2.0907 4
7 4.8107 1.3600 -2.0907 1
8 4.8107 1.3600 -2.0907 1 Chart Title
9 4.8107 1.3600 -2.0907 0
6.0000
10 4.8107 1.3600 -2.0907 1
5.0000
11 4.8107 1.3600 -2.0907 0
12 4.8107 1.3600 -2.0907 1 4.0000
13 4.8107 1.3600 -2.0907 1 3.0000
14 4.8107 1.3600 -2.0907 1 2.0000
15 4.8107 1.3600 -2.0907 2 1.0000
16 4.8107 1.3600 -2.0907 1 0.0000
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
17 4.8107 1.3600 -2.0907 1 -1.0000
18 4.8107 1.3600 -2.0907 0 -2.0000
19 4.8107 1.3600 -2.0907 0 -3.0000
20 4.8107 1.3600 -2.0907 2
21 4.8107 1.3600 -2.0907 1 Column B Column C Column D Col
22 4.8107 1.3600 -2.0907 1
23 4.8107 1.3600 -2.0907 0
24 4.8107 1.3600 -2.0907 0
25 4.8107 1.3600 -2.0907 1
LC LIC np
1.3600 -2.0907 1
1.3600 -2.0907 3
1.3600 -2.0907 4
1.3600 -2.0907 4
1.3600 -2.0907 3
1.3600 -2.0907 4
1.3600 -2.0907 1
1.3600 -2.0907 1
1.3600 -2.0907 0
1.3600 -2.0907 1
1.3600 -2.0907 0
1.3600 -2.0907 1
1.3600 -2.0907 1
1.3600 -2.0907 1
1.3600 -2.0907 2
1.3600 -2.0907 1
1.3600 -2.0907 1
1.3600 -2.0907 0
1.3600 -2.0907 0
1.3600 -2.0907 2
1.3600 -2.0907 1
1.3600 -2.0907 1
1.3600 -2.0907 0
1.3600 -2.0907 0
1.3600 -2.0907 1
1.36
Chart Title
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Column C Column D Column E
Muestra Número de LCI LC LCS
Defectos ci Gráfico de Control c (Número de d
1 8 0.67 10.30 19.93
2 4 0.67 10.30 19.93 1
0.9
3 14 0.67 10.30 19.93
Número de Defectos c
0.8
4 9 0.67 10.30 19.93
0.7
5 6 0.67 10.30 19.93
0.6
6 9 0.67 10.30 19.93 0.5
7 13 0.67 10.30 19.93 0.4
8 15 0.67 10.30 19.93 0.3
9 10 0.67 10.30 19.93 0.2
10 17 0.67 10.30 19.93 0.1
0
11 14 0.67 10.30 19.93
1234567891111111111222
12 13 0.67 10.30 19.93 0123456789012
13 16 0.67 10.30 19.93
14 8 0.67 10.30 19.93
15 9 0.67 10.30 19.93
16 14 0.67 10.30 19.93
17 6 0.67 10.30 19.93
18 9 0.67 10.30 19.93 10.3
c
19 13 0.67 10.30 19.93
20 7 0.67 10.30 19.93 Cbarra = 10.3
21 13 0.67 10.30 19.93
22 8 0.67 10.30 19.93
23 11 0.67 10.30 19.93 LCS c 3 c
24 9 0.67 10.30 19.93 LC c
25 6 0.67 10.30 19.93
LCI c 3 c
26 6 0.67 10.30 19.93
27 11 0.67 10.30 19.93
m
28 12 0.67 10.30 19.93
c ci m
29 12 0.67 10.30 19.93 i 1
30 8 0.67 10.30 19.93
31 16 0.67 10.30 19.93 n= Total de defectos
32 13 0.67 10.30 19.93 N= Numero total de muestras
33 12 0.67 10.30 19.93
34 11 0.67 10.30 19.93
35 6 0.67 10.30 19.93
36 10 0.67 10.30 19.93
37 13 0.67 10.30 19.93
38 6 0.67 10.30 19.93
39 9 0.67 10.30 19.93
40 10 0.67 10.30 19.93
41 11 0.67 10.30 19.93
42 7 0.67 10.30 19.93
43 11 0.67 10.30 19.93
44 13 0.67 10.30 19.93
45 9 0.67 10.30 19.93
46 11 0.67 10.30 19.93
47 7 0.67 10.30 19.93
48 16 0.67 10.30 19.93
49 5 0.67 10.30 19.93
50 9 0.67 10.30 19.93
515
Total de
Defectos
Gráfico de Control c (Número de defectos por Muestra)
2345678911111111112222222222333333333344444444445
01234567890123456789012345678901234567890
Muestra
(Total de Defectos)/(Número de Muestras)
(515/50)
otal de defectos
umero total de muestras
En una fábrica de componentes electrónicos, se realiza una
inspección final para detectar defectos relativamente
menores Modifcar las columnas
Muestra (n) y Defectos (d)
Nota: el valor de n NO ES constante
Si el límite inferior es negativo, reemplazar por cero
Proporción Carta U
Lectura Componentes Defectos
defectos
o Lote o muestra (n) totales (d) LCI LCC
(u)
1 20 17 0.850 0.389 1.050
2 20 24 1.200 0.389 1.050
3 20 16 0.800 0.389 1.050
4 20 26 1.300 0.389 1.050
5 15 15 1.000 0.389 1.050
6 15 15 1.000 0.389 1.050
7 15 20 1.333 0.389 1.050
8 25 18 0.720 0.389 1.050
9 25 26 1.040 0.389 1.050
10 25 10 0.400 0.389 1.050
11 25 25 1.000 0.389 1.050
12 30 21 0.700 0.389 1.050
13 30 40 1.333 0.389 1.050
14 30 24 0.800 0.389 1.050
15 30 46 1.533 0.389 1.050
16 30 32 1.067 0.389 1.050
17 30 30 1.000 0.389 1.050
18 30 34 1.133 0.389 1.050
19 15 11 0.733 0.389 1.050
20 15 14 0.933 0.389 1.050
21 15 30 2.000 0.389 1.050
22 15 17 1.133 0.389 1.050
23 15 18 1.200 0.389 1.050
24 15 20 1.333 0.389 1.050
25 15 18 1.200 0.389 1.050
Total 540 567 1.070
Cart
𝒖 ̅= 567/ 540 1.05
TOTAL DEFECTOS / MUESTRA 1
𝒏 ̅= 540 / 25 21.6 0.9
SUMA TOTAL COMPONENTES / CANTIDAD DE MUESTRAS
Carta u 0.8
0.7
Defectos proporción u
LCs 𝒖 ̅+𝟑√(𝒖 ̅/𝒏 ̅ ) 1.711 1.05+3RAIZ(1.05/21.6)
LCc 𝒖 ̅ 1.050 0.6
LCi 𝒖 ̅−𝟑√(𝒖 ̅/𝒏 ̅ ) 0.389 1.05-3RAIZ(1.05/21.6) 0.5
0.4
0.3
0.2
0.1
0.5
Defectos pro
0.4
0.3
0.2
0.1
0
0 0.1 0.2 0.3 0.4
u LCi
ar las columnas
(n) y Defectos (d)
Carta U
LCS
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
1.711
Carta u
0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1
Lotes
u LCi LCc LCs
