Resolucao do Exercício 5

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Sheet1
	a)	b)	c)
	Producao	Preco	PIB Nominal	PIB Real (2011)	PIB Real (2013)
	2010	FARINHA	* 1,350,000.00	* 0.40	* 540,000.00	* 2,250,000.00	* 675,000.00	* 2,128,500.00	* 1,066,162.50	* 2,174,601.60
	PEIXE	* 2,850,000.00	* 0.60	* 1,710,000.00	* 1,453,500.00	* 1,108,439.10
	2011	FARINHA	* 1,215,000.00	* 0.50	* 607,500.00	* 2,133,675.00	* 607,500.00	* 2,133,675.00	* 959,546.25	* 2,123,407.31
	PEIXE	* 2,992,500.00	* 0.51	* 1,526,175.00	* 1,526,175.00	* 1,163,861.05
	2012	FARINHA	* 1,360,800.00	* 0.68	* 918,540.00	* 2,437,236.74	* 680,400.00	* 2,313,407.25	* 1,074,691.80	* 2,320,023.13
	PEIXE	* 3,201,975.00	* 0.47	* 1,518,696.74	* 1,633,007.25	* 1,245,331.33
	2013	FARINHA	* 1,415,232.00	* 0.79	* 1,117,679.47	* 2,574,717.13	* 707,616.00	* 2,618,234.48	* 1,117,679.47	* 2,574,717.13
	PEIXE	* 3,746,310.75	* 0.39	* 1,457,037.65	* 1,910,618.48	* 1,457,037.65
	2014	FARINHA	* 1,754,887.68	* 1.08	* 1,898,713.89	* 3,413,450.23	* 877,443.84	* 3,036,442.73	* 1,385,922.55	* 3,032,375.10
	PEIXE	* 4,233,331.15	* 0.36	* 1,514,736.35	* 2,158,998.89	* 1,646,452.55
	d)	e)
	Producao	Preco	PIB Nominal	PIB Real (2011)	PIB Real (2013)
	2010
	2011	* (5.17)	* 0.24
	2012	* 14.23	* 8.42
	2013	* 5.64	* 13.18
	2014	* 32.58	* 15.97
Sheet2
Sheet3