programa para parcial 2.xlsx

Upload: mario-lopez

Post on 14-Apr-2018

217 views

Category:

Documents


0 download

TRANSCRIPT

  • 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