7
TEQUILLA EN GRAMOS lote lote 067 48.6 49.9 53.6 57.7 40.7 lote 077 56.8 45.2 60.9 62.0 40.7 lote 78 55.6 46.8 45.8 53.6 41.8 lote 103 42.0 51.6 42.4 39.7 56.6 lote 120 lote 150

Cafe

Embed Size (px)

DESCRIPTION

excel guia de practica del cae

Citation preview

Page 1: 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

Page 2: Cafe

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

Page 3: Cafe

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

Page 4: Cafe

6

0

7.9

14.9

Page 5: Cafe

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

Page 6: Cafe

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