GRANULOMETRIA FLOCOS DE ARROZ

Prévia do material em texto

Planilha1
	m1+m2+...
	mt	209.8
	Dpi			mi/mt		dpi medio	xi	yi	xi/Dpi médio		Xi
	4			0.0021925643		4	0.9978074357	0.0021925643	0.2494518589		0.9978074357
	1.7			0.2268827455		5.7	0.7709246902	0.2290753098	0.1352499456		0.7709246902
	1			0.3000953289		1.35	0.4708293613	0.5291706387	0.3487624898		0.4708293613
	0.25			0.4492850334		0.625	0.0215443279	0.9784556721	0.0344709247		0.0215443279
	0.053			0.0187797903		0.1515	0.0027645377	0.9972354623	0.0182477733		0.0027645377
	-			0.0027645377		-	3.77302356024956E-17	1	ERROR:#VALUE!		0
					xi/Dpi
					0.2494518589
					0.1352499456
					0.3487624898
					0.0344709247
					0.0182477733
					ERROR:#VALUE!
														Ds=	1.271968498
	diametro	massa retida
	4	0.46
	5.7	47.6
	1.35	62.96
	0.625	94.26
	0.1515	3.94
	-	0.58
		Xi	yi	diametro
		99.78%	0.22%	4
		77.09%	22.91%	5.7
		47.08%	52.92%	1.35
		2.15%	97.85%	0.625
		0.28%	99.72%	0.1515
		0.00%	100.00%	-
			GGS
		ln(Xi)	ln(Dpi)
		0.9978074357	1.3862943611
		0.7709246902	1.7404661748
		0.4708293613	0.3001045925
		0.0215443279	-0.4700036292
		0.0027645377	-1.887169654
		0	ERROR:#VALUE!
	m=	3.0069		y = 3,0069x - 1,1475
				0.3816222688
			K=	1.4646587333
			RRB
		ln(ln(1/1-Xi)	lnDpi	n=	2.0558
		1.8120004784	1.3862943611		y = 2,0558x - 2,0335
		0.3877792755	1.7404661748		0.9891526413
		-0.4518583264	0.3001045925	D'=	2.6889549973
		-3.8267725695	-0.4700036292
		-5.8894980077	-1.887169654
		ERROR:#NUM!	ERROR:#VALUE!
			GGS
					Xi
					20.5107371912
					59.4959201402
					0.7826141403
					0.0772464814
					0.0010895065
					ERROR:#VALUE!
			RRB
			Xi
			0.8959038367	2.2624401599	-2.2624401599
			0.990775241	4.6858642118	-4.6858642118
			0.2153759462	0.2425505883	-0.2425505883
			0.0485806344	0.0498003403	-0.0498003403
			0.0027000232	0.0027036749	-0.0027036749
			ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
y = 2,0558x - 2,0335
R² = 0,902
1.3862943611198906	1.7404661748405046	0.30010459245033816	-0.47000362924573558	-1.8871696540327132	1.8120004784373784	0.38777927546515095	-0.45185832639618079	-3.8267725694705899	-5.8894980077076342	ln(Dpi)
ln[ln(1/1-Xi)]
Experimental	4	5,7	1,35	0,625	0,1515	-	0.99780743565300289	0.77092469018112486	0.4708293612964729	2.1544327931363183E-2	2.7645376549094713E-3	0	GGS	4	5,7	1,35	0,625	0,1515	-	20.510737191197538	59.495920140174043	0.7826141403360839	7.7246481375	489409E-2	1.0895065052807977E-3	0	RRB	4	5,7	1,35	0,625	0,1515	-	0.89590383669759355	0.99077524097888769	0.2153759462173569	4.8580634386830912E-2	2.7000232156781934E-3	0	Dpi
Xi
4	5,7	1,35	0,625	0,1515	-	0.46	47.6	62.96	94.26	3.94	0.57999999999999996	Diâmetro (mm)
Massa retida (g)
Xi	4	5,7	1,35	0,625	0,1515	-	0.99780743565300301	0.77092469018112486	0.4708293612964729	2.1544327931363183E-2	2.7645376549094713E-3	0	Yi	4	5,7	1,35	0,625	0,1515	-	2.19256434699711E-3	0.	22907530981887514	0.5291706387035271	0.97845567206863682	0.99723546234509053	1	Diâmetro (mm) 
Xi, zi
y = 3,0069x - 1,1475
R² = 0,828
1.3862943611198906	1.7404661748405046	0.30010459245033816	-0.47000362924573558	-1.8871696540327132	0.99780743565300301	0.77092469018112486	0.4708293612964729	2.1544327931363183E-2	2.7645376549094713E-3	ln(Dpi)
ln (Xi)