GRANULOMETRIA TAPIOCA

Prévia do material em texto

Planilha1
	m1+m2+...	21.48	125.63	23.97	28.2	0.48	0.14
	mt	199.9
										Xi
	4			0.1074537269		4	0.8925462731	0.1074537269	0.2231365683	0.8925462731
	1.7			0.6284642321		5.7	0.264082041	0.735917959	0.0463301826	0.264082041
	1			0.119909955		1.35	0.144172086	0.855827914	0.1067941378	0.144172086
	0.25			0.1410705353		0.625	0.0031015508	0.9968984492	0.0049624812	0.0031015508
	0.053			0.0024012006		0.1515	0.0007003502	0.9992996498	0.0046227734	0.0007003502
	-			0.0007003502		-	1.24249568966839E-16	1	ERROR:#VALUE!	0
					xi/Dpi
					0.2231365683
					0.0463301826
					0.1067941378
					0.0049624812
					0.0046227734
					ERROR:#VALUE!
														Ds=	2.5917066092
	diametro	massa retida
	4	21.48
	5.7	125.63
	1.35	23.97
	0.625	28.2
	0.1515	0.48
	-	0.14
		Xi	yi	diametro
		89.25%	10.75%	4
		26.41%	73.59%	5.7
		14.42%	85.58%	1.35
		0.31%	99.69%	0.625
		0.07%	99.93%	0.1515
		0.00%	100.00%	-
			GGS
			ln(Xi)	ln(Dpi)
			-0.11367692	1.3862943611
			-1.3314954627	1.7404661748
			-1.9367476509	0.3001045925
			-5.7758530424	-0.4700036292
			-7.2639300979	-1.887169654
			ERROR:#NUM!	ERROR:#VALUE!
				y = 0,1697x + 0,2246
		m=	0.1697
			-1.3235120801
		K=	0.266198747
			RRB
	1/1-Xi		ln(ln(1/1-Xi)	ln(Dpi)
	9.3063314711		0.8023131835	1.3862943611
	1.3588471212		-1.182091831	1.7404661748
	1.1684592004		-1.8599143895	0.3001045925
	1.0031112003		-5.7743002592	-0.4700036292
	1.000700841		-7.2635798206	-1.887169654
	1		ERROR:#NUM!	ERROR:#VALUE!
			y = 2,1161x - 3,5082
		n=	2.1161
			1.6578611597
		D'=	5.2480740395
			GGS
					Xi
					1.5838429695
					1.6819555089
					1.3172256564
					1.1558550627
					0.9087795892
					ERROR:#VALUE!
			RRB
			Xi
			0.4304420882	0.5628948124	-0.5628948124
			0.6960854048	1.191008554	-1.191008554
			0.0549530602	0.056520681	-0.056520681
			0.0110170779	0.0110782154	-0.0110782154
			0.0005520258	0.0005521782	-0.0005521782
			ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Experimental	4	5,7	1,35	0,625	0,1515	-	0.89254627313656831	0.26408204102051036	0.14417208604302156	3.1015507753877625E-3	7.0035017508762731E-4	0	GGS	4	5,7	1,35	0,625	0,1515	-	1.5838429695328142	1.6819555088621325	1.3172256564327227	1.1558550627167885	0.90877958924090307	0	RRB	4	5,7	1,35	0,625	0,1515	-	0.43044208818085916	0.69608540	484585546	5.4953060248904673E-2	1.1017077898336836E-2	5.5202579577451338E-4	0	Dpi
Xi
4	5,7	1,35	0,625	0,1515	-	21.48	125.63	23.97	28.2	0.48	0.14000000000000001	Diâmetro (mm)
Massa retida (g)
Xi	4	5,7	1,35	0,625	0,1515	-	0.89254627313656831	0.26408204102051036	0.14417208604302156	3.1015507753877625E-3	7.0035017508762731E-4	0	Yi	4	5,7	1,35	0,625	0,1515	-	0.10745372686343169	0.73591795897948964	0.85582791395697844	0.99689844922461224	0.99929964982491237	0.99999999999999989	Diâmetro (mm) 
Xi, zi
y = 0,1697x + 0,2246
R² = 0,4526
1.3862943611198906	1.7404661748405046	0.30010459245033816	-0.47000362924573558	-1.8871696540327132	-0.11367692002071694	-1.3314954626708291	-1.9367476509349779	-5.7758530424493317	-7.2639300978790677	ln(Dpi)
ln (Xi)
y = 2,1161x - 3,5082
R² = 0,8567
1.3862943611198906	1.7404661748405046	0.30010459245033816	-0.47000362924573558	-1.8871696540327132	0.80231318349686309	-1.1820918309538846	-1.8599143895164674	-5.7743002592371813	-7.2635798205631463	ln(Dpi)
ln[ln(1/1-Xi)]