Cafe

Post on 19-Dec-2015

217 views 1 download

description

excel guia de practica del cae

Transcript of Cafe

PAN MANTEQUILLA EN GRAMOSMUESTRA

lote

lote 067 48.6 49.9 53.6 57.7 40.7 48.6lote 077 56.8 45.2 60.9 62.0 40.7 60.9lote 78 55.6 46.8 45.8 53.6 41.8 53.6

lote 103 42.0 51.6 42.4 39.7 56.6 56.6lote 120lote 150

PESO EN GRAMOSN° X1 X2 X3 X4 X5

1 lote 067 7.47 7.91 7.94 7.54 7.642 lote 077 7.61 7.84 7.83 7.72 7.633 lote 078 7.11 7.49 7.72 7.74 7.564 lote 103 7.34 7.29 7.59 7.76 7.715 lote 120 7.78 7.75 7.31 7.62 7.816 lote 150 7.79 7.71 7.78 7.89 7.73

TOTAL

CALCULOS TOTALX (DOBLE RAYA) = 7.6537

R(UNA RAYA) = 0.3800

SUBGRUPO Nº

0 1 2 3 4 5 6 70.00

0.10

0.20

0.30

0.40

0.50

0.60

0.70

0.80

LIC

LC

LSC

x LIC LCC LSC7.70 0.27 0 0.3800 0.76 DATO K = 7.73 0.23 0 0.3800 0.767.52 0.63 0 0.3800 0.767.54 0.47 0 0.3800 0.76 LIC = 7.65 0.50 0 0.3800 0.767.78 0.18 0 0.3800 0.76 LCC = 7.65 2.28

LIC LCC LSC LSC = 7.47126667 7.65367 7.836077.47126667 7.65367 7.836077.47126667 7.65367 7.836077.47126667 7.65367 7.836077.47126667 7.65367 7.836077.47126667 7.65367 7.83607

PROMEDIO X INTERVALO

R(s/r)

0 1 2 3 4 5 6 77.20000

7.30000

7.40000

7.50000

7.60000

7.70000

7.80000

7.90000

LIC

LC

LSC

6

0

7.9

14.9

DATOSCALCULOS TOTAL

TAMAÑO DE MUESTRA R FACTOR D3 FACTOR D4 X = 47.88136 7.4667 0 2 R = 14.9125

PROCEDIMEINTO PARA EL GRAFICO R

LIC = 0

LCC = 7.5

LSC = 2.0

PROCEDIMEINTO PARA EL GRAFICO X

LIC = #REF!

LCC = 47.8813

LCS = #REF!

0 1 2 3 4 5 6 7 80.00

0.50

1.00

1.50

2.00

2.50GRAFICO R

GRAFICO R

0 1 2 3 4 5 6 7 87.35

7.40

7.45

7.50

7.55

7.60

7.65

7.70

7.75

7.80

7.85GRAFICO X

GRAFICO X

0 1 2 3 4 5 6 7 80.00

0.50

1.00

1.50

2.00

2.50GRAFICO R

GRAFICO R

0 1 2 3 4 5 6 7 87.35

7.40

7.45

7.50

7.55

7.60

7.65

7.70

7.75

7.80

7.85GRAFICO X

GRAFICO X