Atv 1 - Tópicos III

Prévia do material em texto

Planilha1
		#	automóvel	quantidade	preço	participação de mercado	participação relativa de mercado	 índice de Herfindahl	Receita	participação de mercado por receita	preço premium em receita	preço médio
		1	onix	188,654	R$ 39,400	23.10%	1.79	0.053	R$ 7,432,967,600	21.06%	0.912	43,202.57
		2	hb20	105,539	R$ 37,450	12.92%	0.56	0.017	R$ 3,952,435,550	11.20%	0.867	43,202.57
		3	ka	94,893	R$ 36,140	11.62%	0.50	0.013	R$ 3,429,433,020	9.72%	0.837	43,202.57
		4	gol	73,919	R$ 28,640	9.05%	0.39	0.008	R$ 2,117,040,160	6.00%	0.663	43,202.57
		5	prisma	68,988	R$ 38,910	8.45%	0.37	0.007	R$ 2,684,323,080	7.61%	0.901	43,202.57
		6	sandero	67,344	R$ 34,470	8.25%	0.36	0.007	R$ 2,321,347,680	6.58%	0.798	43,202.57
		7	corolla	66,188	R$ 62,400	8.10%	0.35	0.007	R$ 4,130,131,200	11.70%	1.444	43,202.57
		8	mobi	54,270	R$ 27,680	6.64%	0.29	0.004	R$ 1,502,193,600	4.26%	0.641	43,202.57
		9	compass	49,187	R$ 88,640	6.02%	0.26	0.004	R$ 4,359,935,680	12.36%	2.052	43,202.57
		10	hrv	47,775	R$ 70,250	5.85%	0.25	0.003	R$ 3,356,193,750	9.51%	1.626	43,202.57
		SOMA		816,757	R$ 463,980	100.00%	5.12		R$ 35,286,001,320	100%