Alimentacion.xlsx
11
%Peso %Peso Ac Ret %Peso Ac Pas X Y GGS Malla Abertura peso f(x) G(x) F (x) log (X) log F(x) X2 XY Y2 F( x) 8" 203200 6" 152400 4 4750 0.00 0.00 100.00 6.00 3350.00 1.07 1.07 98.93 3.53 2.00 12.43 7.03 3.98 145.11 8 2360 2.07 3.14 96.87 3.37 1.99 11.38 6.70 3.94 117.79 10.00 1700.00 5.87 9.01 91.00 3.23 1.96 10.44 6.33 3.84 96.90 14 1180 9.03 18.04 81.97 3.07 1.91 9.44 5.88 3.66 77.97 20.00 850.00 9.87 27.91 72.10 2.93 1.86 8.58 5.44 3.45 64.14 28 600 10.10 38.01 62.00 2.78 1.79 7.72 4.98 3.21 52.12 35.00 425.00 9.90 47.91 52.10 2.63 1.72 6.91 4.51 2.95 42.45 48 300 4.87 52.78 47.23 2.48 1.67 6.14 4.15 2.80 34.50 65.00 212.00 16.10 68.88 31.13 2.33 1.49 5.41 3.47 2.23 28.06 100 150 8.23 77.11 22.90 2.18 1.36 4.74 2.96 1.85 22.84 150.00 106.00 5.20 82.31 17.70 2.03 1.25 4.10 2.53 1.56 18.57 200 75 3.40 85.71 14.30 1.88 1.16 3.52 2.17 1.33 15.11 270.00 53.00 2.73 88.44 11.57 1.72 1.06 2.97 1.83 1.13 12.29 400 38 1.63 90.07 9.93 1.58 1.00 2.50 1.57 0.99 10.08 -400.00 0.00 9.93 100.00 0.00 0 90.07 35.72 22.21 96.25 59.56 36.94
-
Upload
victor-derian-madridista -
Category
Documents
-
view
212 -
download
0
Transcript of Alimentacion.xlsx
GGSGRUPO 1GRUPO 2GRUPO 3GRUPO 4GRUPO 5GRUPO 6GRUPO 7GRUPO 8GRUPO 9PESOS (g)%Peso%Peso Ac Ret%Peso Ac PasXYGGSMallaFaja 9Faja 7Faja 3AFaja 3BFaja 5Faja 9Faja 7Faja 8BFaja 8DAberturapesof(x)G(x)F (x)log (X)log F(x)X2XYY2F( x)
8"023633.500002032006"013226.100001524004085989.817841.100047500.00 0.00 100.00 6.000.0033941.309022.60003350.001.07 1.07 98.93 3.53 2.00 12.43 7.03 3.98 145.11 8028394.423637.500023602.07 3.14 96.87 3.37 1.99 11.38 6.70 3.94 117.79 10.000.001479.0042471.3023456.503423.63584.41700.005.87 9.01 91.00 3.23 1.96 10.44 6.33 3.84 96.90 14014526.749956.233041.90015084.911784.811809.03 18.04 81.97 3.07 1.91 9.44 5.88 3.66 77.97 20.000.0057930.7059143.6048218.90066680.559204.6850.009.87 27.91 72.10 2.93 1.86 8.58 5.44 3.45 64.14 280100690.350835.859960.203930.2128411.6115648.560010.10 38.01 62.00 2.78 1.79 7.72 4.98 3.21 52.12 35.00873.3061643.8028917.8039785.09436034132.9121613.2132490.8021425.009.90 47.91 52.10 2.63 1.72 6.91 4.51 2.95 42.45 4827575.551956.232417.751115.18098.520456.690804.7119002.5215992.87053004.87 52.78 47.23 2.48 1.67 6.14 4.15 2.80 34.50 65.0030914.3010037.6013813.1027553.79797.328952.57296.215819.123711.1212.0016.10 68.88 31.13 2.33 1.49 5.41 3.47 2.23 28.06 10040946.15362.516341.232326.61681539029.5845.66304.27201.11508.23 77.11 22.90 2.18 1.36 4.74 2.96 1.85 22.84 150.0045591.002122.201335.5037119.621092.236155.241024212947.6106.005.20 82.31 17.70 2.03 1.25 4.10 2.53 1.56 18.57 20021739.4502.17683.718063.310165.215310.8113652.8933.4753.40 85.71 14.30 1.88 1.16 3.52 2.17 1.33 15.11 270.0016335.90376.105281.5012542.571988879.983.6480.4562.253.002.73 88.44 11.57 1.72 1.06 2.97 1.83 1.13 12.29 40025661.7643.610925.52515116776.817553141.5935.9914.8381.63 90.07 9.93 1.58 1.00 2.50 1.57 0.99 10.08 -400.0061659.104713.9028867.0055207.430862.535745.71248.77538.68613.40.009.93 100.00 0.00 271296.3311984.7533175514042.99121241.5202083.2139006.4488368.3583589.5726090.0735.7222.2196.2559.5636.94
CALCULO DE LA PENDIENTE ()Ecuacin de distribucin de G-G-S:n=15=0.5953318783
CALCULO DE C
C=0.0631210686
CALCULO DE FACTOR DE CORELACION RF801232.1422006741f50559.491228428f25174.639531441
R=0.9902290432HALLAMOS K CON LA ECUACION
K=1792.4374401659
HALLAMOS LA VARIANZA
=0.2291299113
Constante de regresina0.0631210686Pendienteb=0.5953318783Coeficiente de correlacinr0.9902290432Tamao maximo de la partculaXo1792.4374401659Tamao medio de la distribucinM668.8859932369Varianza de la distribucin^2289569.06506763680% PassingF801232.1422006741
RRGRUPO 1GRUPO 2GRUPO 3GRUPO 4GRUPO 5GRUPO 6GRUPO 7GRUPO 8GRUPO 9PESOS (g)%Peso%Peso Ac Ret%Peso Ac PasXYRRMallaFaja 9Faja 7Faja 3AFaja 3BFaja 5Faja 9Faja 7Faja 8BFaja 8DAberturaPesof(x)G(x)F (x)log (X)log ln(1/(1-F(x)))X2XYY2F( x)
00.023,6340.00.00.00.00.00.000.013,2260.00.00.00.00.00.04"0.085,99017,8410.00.00.047500.00.0000.000100.0003 1/2"0.033,9419,0230.00.00.03350.000.01.071.0798.933.5250.65712.4262.3150.43180.6253"0.028,39423,6380.00.00.023602.0703.14096.8703.3730.54011.3771.8200.29176.5352 1/2"0.01,47942,47123,4570.03,4243,5841700.005.879.01913.2300.38210.4361.2330.14672.4902"0.014,52749,95633,0420.00.015,08511,78511809.03018.04081.9703.0720.2349.4360.7180.05567.8271 1/2"0.057,93159,14448,2190.00.066,68159,205850.009.8727.9172.12.9290.1068.5810.3110.01163.5641"0.0100,69050,83659,9600.03,930128,412115,64960010.10038.01062.0002.778-0.0147.718-0.0400.00059.0343/4"87361,64428,91839,7854360.034,133121,613132,491425.009.947.9152.12.628-0.1336.908-0.3500.01854.6071/2"27,57651,95632,41851,1158,09920,45790,805119,003215,9933004.87052.78047.2302.477-0.1946.136-0.4810.03850.2483/8"30,91410,03813,81327,5549,79728,9537,29615,81923,711212.0016.168.8831.132.326-0.4285.412-0.9960.18346.0621/4"40,9465,36316,34132,32716,81539,0308466,3047,2011508.23077.11022.9002.176-0.5854.735-1.2730.34242.0816M45,5912,1221,33637,12021,09236,1554102,4212,948106.005.282.3117.72.025-0.7104.102-1.4390.50538.3028M21,7395027,68418,06310,16515,311113653933753.40085.71014.3001.875-0.8123.516-1.5220.65934.76810M16,3363765,28212,5437,1988,8808448056253.002.7388.4411.571.724-0.9102.973-1.5700.82931.46220M25,66264410,92625,15116,77717,553142936915381.63090.0709.9301.580-0.9812.496-1.5490.96128.522-20M61,6594,71428,86755,20730,86335,7461,2497,5398,6130.009.930100.0000.000271,296311,985533,175514,043121,242202,083139,006488,368583,5900.0009.93100.00035.720-2.85096.253-2.8224.469
CALCULO DE LA PENDIENTE ()n=15=0.354
CALCULO DE CHALLAMOS EL F80:C=-1.034X=F80= Ln(100/G(X))^(1/m)*X0
CALCULO DE FACTOR DE CORELACION RF803170.2115072056f50293.9989500518f2524.5616239078
R=0.598HALLAMOS K CON LA ECUACION
K=827.322
HALLAMOS LA VARIANZA
=0.150
RESUMEN
MallaAberturaREALGGSR-R8"2032006"1524004"1016003 1/2"889003"762002 1/2"635002"5080081.9777.9767.831 1/2"3810072.1064.1463.561"2540062.0052.1259.033/4"1905052.1042.4554.611/2"1270047.2334.5050.253/8"952531.1328.0646.061/4"635022.9022.8442.086M336017.7018.5738.308M238014.3015.1134.7710M168011.5712.2931.4620M8409.9310.0828.52-20M-840
Gaudin SchumannRosin Rammler
F80=1232.14220067413170.2115072056F50=559.491228428293.9989500518F25=174.63953144124.5616239078
