cafe
DESCRIPTION
excel guia de practica del caeTRANSCRIPT
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