Paretos y Cartas en Excel

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 10

Pisos

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%

arcas Quemaduras Perforaciones Ampollas Otros


Casas Defectos Superficie (m2) Defporm2 (U) LSC LC

1 12 100 0.120 0.233 0.126


2 15 100 0.150 0.233 0.126
3 7 100 0.070 0.233 0.126
4 14 90 0.156 0.233 0.126
5 12 90 0.133 0.233 0.126
6 11 90 0.122 0.233 0.126
7 15 90 0.167 0.233 0.126
8 9 110 0.082 0.233 0.126
9 10 110 0.091 0.233 0.126
10 27 150 0.180 0.233 0.126
11 10 110 0.091 0.233 0.126
12 11 70 0.157 0.233 0.126
Sumas 153 1210 0.126
n 100.8
LSC 0.233
LC 0.126 Coe de Var 5.08339543 0.0354120418
LIC 0.020 12.75 28.0% 0.126
LIC

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

Column F Column G Column H Column D


Lote Rugosidades LSC LC LIC
1 27 26.4 14.8 3.3
2 18 26.4 14.8 3.3 Carta de rugosidades
3 9 26.4 14.8 3.3
30.0
4 13 26.4 14.8 3.3
5 25.0
17 26.4 14.8 3.3
6 11 26.4 14.8
20.0 3.3
7 18 26.4 14.8
15.0 3.3
8 14 26.4 14.8 3.3
10.0
9 13 26.4 14.8 3.3
5.0
10 11 26.4 14.8 3.3
11 17 26.4 0.0
14.8 3.3
1 2 3 4 5 6 7 8 9 10 11 12
12 10 26.4 14.8 3.3
Promedio 14.8 Column D Column E Column F
27 Column B

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

También podría gustarte