Paretos y Cartas en Excel
Paretos y Cartas en Excel
Paretos y Cartas en Excel
Total
DEFECTOS P1 P2 P3 P4 P5 %
Defectos
Lineamiento 2 5 9 8 7 31 26%
Nivelación de piso 7 9 3 4 2 25 21% Diagrama de
Humedad 3 3 9 4 4 23 19%
100%
Espuma auto nivelante 1 5 3 2 2 13 11%
80%
Color Homogéneo 1 2 3 4 1 11 9% 6
60%
Limpieza sector 2 2 2 2 2 10 8%
40%
47%
Uniones 1 1 1 1 1 5 4%
20%
26%
Total 118
0%
o so ad
nt pi ed
Pisos ie
Frec % % Acum D. de Pareto de 2do Nivel m de m
ea ió
n Hu
P3 9 29% 29% Desv Est. 2.77 Lin ac
120%
ve
l au
a
P4 8 26% 55% Prom 6.20 44.8% Ni um
100% 100% sp
P5 7 23% 77% 94% E
80% 77%
P2 5 16% 94%
P1 2 6% 100% 60%
55%
Total 31 40%
29%
20%
0%
P3 P4 P5 P2 P1
% Acumulado
26%
47%
Diagrama de Pareto 1er Nivel
100% 66.9% 96% 100%
87%
80% 78% 78%
87% 67%
60%
40% 96%47%
26% 100%
20%
0%
nt
o so ad nt
e
ne
o or es
ie pi ed la é e ct i on
vel m de m ve og s
Un
ea ió
n Hu ni om ez
a
Lin ac to rH pi
l au o Lim
ive a Co
l
N Cvar um
100% sp
94% E
P2 P1
Tipo de
Frecuencia Ponderación
defectos: Frec Pond % % Acumulado
Hoyos 40 7 280 29% 29%
Marcas 85 3 255 26% 55%
Quemaduras 20 9 180 18% 73%
Perforaciones 30 5 150 15% 89%
Ampollas 50 2 100 10% 99%
Otros 5 2 10 1% 100%
Total 975
Chart Title
100%
8
80%
73%
60%
55%
40%
29%
20%
0%
Hoyos Marcas Quemaduras Perforac
Chart Title
99%
89%
73%
55%
0.020
0.020
0.020
0.020
0.020
0.020
0.020
0.020 Chart Title
0.020 0.250
0.020
0.020 0.200
0.020
0.150
0.100
0.050
0.000
1 2 3 4 5 6 7 8 9 10 11 12 13
LSC 26.4
LC 14.8
LIC 3.3
sidades
7 8 9 10 11 12
mn E Column F
mn B
Consumo
Semana Rango Móvil (2) LSC LC LIC LSC
(m3)
1 562 649.3 545.8 442.3
2 577 15 649.3 545.8 442.3 127.1
3 536 41 649.3X-Individual
545.8 442.3 127.1
4 536 0 700 649.3 545.8 442.3 127.1
7 533 8 650 649.3 545.8 442.3 127.1
8 569 36 600 649.3 545.8 442.3 127.1
9 563 6 550 649.3 545.8 442.3 127.1
10 553 10 500 649.3 545.8 442.3 127.1
11 549 4 450
649.3 545.8 442.3 127.1 R. Mó
400
12 480 69 1 2 3 649.3
4 5 545.8
6 7 442.3
8 9 10 127.1
140
Promedios 552.8 38.9 120
100
X-Individual Rango Móvil(2)
80
LSC 649.3 LSC 127.1 60
LC 545.8 27.5 LC 38.9 40
LIC 442.3 545.8 LIC 0.0 20
5.0% 0
1 2 3 4
LC LIC
38.9 0.0
38.9 0.0
38.9 0.0
38.9 0.0
38.9 0.0
38.9 0.0
38.9 0.0
38.9R. Móvil
0.0(2)
38.9 0.0
2 3 4 5 6 7 8 9