Practica de Excel

9
SUB-GRUPOS X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 1 22 21 23 18 19 21 23 22 24 19 2 25 17 18 21 23 19 24 17 15 24 3 15 15 24 19 22 20 23 19 15 20 4 24 24 23 16 23 19 25 19 16 15 5 25 5 5 24 25 25 5 5 24 24 6 20 16 17 24 19 23 25 19 22 21 7 17 15 20 23 15 19 24 23 23 17 8 25 24 24 17 21 23 21 18 20 23 9 22 15 20 21 18 18 21 25 24 24 10 5 21 20 16 23 5 23 23 17 20 11 18 21 20 23 22 22 22 25 16 25 12 15 22 15 19 22 22 18 25 15 21 13 24 24 22 19 25 19 25 16 23 24 14 21 16 17 21 25 22 16 25 22 25 15 24 18 22 21 21 25 16 22 15 16

description

total quality management

Transcript of Practica de Excel

Examen II P IES

MEDIASDESVIACION ESTANDARLIMITES E CONTROL-CORREGIDOSANALISIS DE CAPACIDADSUB-GRUPOSX1X2X3X4X5X6X7X8X9X10X11MEDIASLIMITES E CONTROLMEDIASLCSLCCLCILCSLCCLCI1222123181921232224192121.21.921.21.923.5619.9216.286.593.931.26LINEAS CENTRALESX0S0INDICES DE CAPACIDADES33EI23N283.32251718212319241715241720.03.5LINEAS CENTRALESXS20.03.523.5619.9216.286.593.931.2620.543.173151524192220231915201618.93.319.923.9318.93.323.5619.9216.286.593.931.26CP0.514242423162319251916152220.53.720.53.723.5619.9216.286.593.931.26LIMITES X3.2552555242525552424515.610.2LIMITES Xn1115.610.223.5619.9216.286.593.931.26CR1.986201617241923251922212320.82.920.82.923.5619.9216.286.593.931.26LCS23.40A00.9057171520231519242323171619.33.5LCS23.56A30.92719.33.523.5619.9216.286.593.931.26LCC20.54C40.9754CPK-0.258252424172123211820231621.13.0LCC19.9221.13.023.5619.9216.286.593.931.26LCI17.679221520211818212524242020.73.0LCI16.2820.73.023.5619.9216.286.593.931.26CPS1.2610521201623523231720516.27.516.27.523.5619.9216.286.593.931.26LIMITES Sn11CPI-0.2511182120232222222516252221.52.7LIMITES S21.52.723.5619.9216.286.593.931.2612152215192222182515212519.93.819.93.823.5619.9216.286.593.931.26LCS5.18B61.637k-1.4913242422192519251623242122.02.9LCS6.59B41.67922.02.923.5619.9216.286.593.931.26LCC3.17B50.31314211617212522162522251920.83.5LCC3.93B30.32120.83.523.5619.9216.286.593.931.26LCI0.9915241822212125162215162320.33.5LCI1.2620.33.523.5619.9216.286.593.931.26MEDIASDESVIACION ESTANDARMEDIASLCSLCCLCILCSLCCLCI121.21.923.4020.5417.675.183.170.99220.03.523.4020.5417.675.183.170.99INTERVALOS DE CONFIANZAz 0.025=1.96318.93.323.4020.5417.675.183.170.99420.53.723.4020.5417.675.183.170.99