7/29/2019 Programa para parcial 2.xlsx
1/19
OBSERVACIONES
MUESTRA 1 2 3 4 5
1 10.00 9.84 9.89 9.95 9.92
2 10.00 9.88 10.10 10.03 10.01
3 9.91 9.94 10.13 9.90 9.91
4 10.02 10.01 10.02 10.08 10.705 9.72 9.97 9.89 10.05 9.93
6 10.03 10.01 9.87 10.13 9.98
7 9.82 9.76 9.90 10.06 9.90
8 10.07 9.98 10.04 9.97 9.83
9 10.04 10.30 9.87 10.16 10.05
10 9.79 9.98 10.06 9.93 10.07
11 10.15 10.02 10.21 9.97 10.23
12 10.04 10.00 10.02 9.77 10.21
13 10.07 10.13 9.89 9.99 10.12
14 9.78 10.01 9.93 9.86 10.07
15 10.21 10.59 10.32 10.32 10.19
16 10.17 9.84 9.79 10.12 10.0317 10.10 10.03 10.13 10.11 9.95
18 9.96 10.10 10.05 9.76 10.00
19 10.15 10.02 9.94 9.92 9.96
20 10.02 10.21 10.10 10.06 10.16
21 10.05 10.04 10.02 10.07 9.89
22 9.90 9.90 10.14 10.11 9.79
USANDO PEGAR "TRASPONER" PARA COLOCAR LOS DATOS E1 2 3 4 5 6 7
1 10.00 10.00 9.91 10.02 9.72 10.03 9.82
2 9.84 9.88 9.94 10.01 9.97 10.01 9.763 9.89 10.10 10.13 10.02 9.89 9.87 9.90
4 9.95 10.03 9.90 10.08 10.05 10.13 10.06
5 9.92 10.01 9.91 10.70 9.93 9.98 9.90
7/29/2019 Programa para parcial 2.xlsx
2/19
7/29/2019 Programa para parcial 2.xlsx
3/19
16 17 18 19 20 21 22
10.17 10.10 9.96 10.15 10.02 10.05 9.90
9.84 10.03 10.10 10.02 10.21 10.04 9.909.79 10.13 10.05 9.94 10.10 10.02 10.14
10.12 10.11 9.76 9.92 10.06 10.07 10.11
10.03 9.95 10.00 9.96 10.16 9.89 9.79
7/29/2019 Programa para parcial 2.xlsx
4/19
This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells.
Enter the number of samples in cell E6 and the sample size in cell E7. Then enter your data in the grid below.
Click on sheet tabs for a display of the control charts. Specification limits may be entered in cells N7 and N8 for process capability.
Number of samples (
7/29/2019 Programa para parcial 2.xlsx
5/19
3 1.023 0 2.574 1.693 1.954 0 2.568
4 0.729 0 2.282 2.059 1.628 0 2.2665 0.577 0 2.114 2.326 1.427 0 2.089
6 0.483 0 2.004 2.534 1.287 0.03 1.977 0.419 0.076 1.924 2.704 1.182 0.118 1.882
8 0.373 0.136 1.864 2.847 1.099 0.185 1.8159 0.337 0.184 1.816 2.97 1.032 0.239 1.761
10 0.308 0.223 1.777 3.078 0.975 0.284 1.716
7/29/2019 Programa para parcial 2.xlsx
6/19
7/29/2019 Programa para parcial 2.xlsx
7/19
7/29/2019 Programa para parcial 2.xlsx
8/19
13 15 17 19 21
umber
Series1 Series2
Series3 Series4
7/29/2019 Programa para parcial 2.xlsx
9/19
0
0.5
1
1.5
2
2.5
1 3 5 7 9 11
Ranges
Sample num
R-Chart
7/29/2019 Programa para parcial 2.xlsx
10/19
7/29/2019 Programa para parcial 2.xlsx
11/19
This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells.
Enter the number of samples in cell E6 and the sample size in cell E7. Then enter your data in the grid below.
Click on sheet tabs for a display of the control charts. Specification limits may be entered in cells N7 and N8
Number of samples (
7/29/2019 Programa para parcial 2.xlsx
12/19
Z inf. -6.0753 6.185n A2 D3 D4 d2 A3 B3 B4 Z sup. 0.45377 0.6752 1.88 0 3.267 1.128 2.659 0 3.267
3 1.023 0 2.574 1.693 1.954 0 2.568 Desv. Est: 0.3064 0.729 0 2.282 2.059 1.628 0 2.266
5 0.577 0 2.114 2.326 1.427 0 2.089 % defectuosos 32.496 0.483 0 2.004 2.534 1.287 0.03 1.977 0.419 0.076 1.924 2.704 1.182 0.118 1.882
8 0.373 0.136 1.864 2.847 1.099 0.185 1.815 Productos defectuosos anuales
9 0.337 0.184 1.816 2.97 1.032 0.239 1.76110 0.308 0.223 1.777 3.078 0.975 0.284 1.716 Productos no defectuosos anuales
Ingresos anuales $
Cp 1.088187
Cpk 0.151258 El proceso est fabricando artculos que cumplen con las especificaciones (es capaz, parcialmente adecuado
Cpm 0.365 El Proceso es capaz
Z/2 1.96
Cp 0.345993 Cpk 0.153802364 Cpm 0.052056433
Cp sup. Cpk sup. Cpm sup.Cp inf. Cpk inf. Cmp inf.
* Desviacion estandar para Cp de seis sigma 0.16666667
Se tiene un proceso parcialmente adecuado y requiere de un control estricto. Es un proceso centrado.
Control Chart Factors
1.434180570.7421937
0.30506038-0.00254435
0.4170.313
7/29/2019 Programa para parcial 2.xlsx
13/19
Desviacion estandar para Cpk de1.25 (Cpu)Desviacion estandar para Cpk de 1.25 (Cpl)
Cpk optimo
0.037066670.49626667
Cpu nuevo
Cpl nuevo
0.10382432
1.39005079
1.39005079
7/29/2019 Programa para parcial 2.xlsx
14/19
s capability.
1.8379192
1.0882 N 90.151258 0.91386698
2.0251163 Cpm 0.365 86.10
0.1513
18 19 20 21 22
10.03 9.82 9.55 9.6 9.89
10 9.76 9.98 9.4 9.98
9.87 9.9 10.45 9.87 9.6
9.87 10.06 9.97 10.16 9.93
9.98 9.9 9.93 9.3 10.5
9.95 9.888 9.976 9.666 9.989.4498875 9.4498875 9.45 9.45 9.4498875
9.861 9.861 9.861 9.861 9.861
10.2721125 10.272113 10.27 10.27 10.2721125
0.16 0.3 0.9 0.86 0.9
0 0 0 0 0
0.7125 0.7125 0.713 0.713 0.7125
1.506225 1.506225 1.506 1.506 1.506225
pk
p
pu
pl
K (entre -20 y 20 esta centrado)
7/29/2019 Programa para parcial 2.xlsx
15/19
6.186E-08
67.500426
9343627.452
19406372.55
9703186.274
7/29/2019 Programa para parcial 2.xlsx
16/19
9
9.2
9.4
9.6
9.8
10
10.2
10.4
1 3 5 7 9 1
Averages
Sample n
X-bar Chart
7/29/2019 Programa para parcial 2.xlsx
17/19
1 13 15 17 19
mber
Series1 Series2
Series3 Series4
7/29/2019 Programa para parcial 2.xlsx
18/19
0
0.20.4
0.6
0.8
1
1.2
1.4
1.6
1 3 5 7 9 11
Ranges
Sample num
R-Chart
7/29/2019 Programa para parcial 2.xlsx
19/19
N
13 15 17 19
ber
Series1 Series2
Series3 Series4
Top Related