Buscar

513_aula_4_execicios

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

procv_proch
	
		Os valores abaixo referem-se aos custos de aquisição, transporte e montagem de diferentes modelos de móveis.
	
	
	
	
	
		Modelo	$ aquisição	$ transporte	$ montagem
		M2	153.13	29.35	24.32
		M1	158.36	121.06	114.15
		M3	245.59	102.01	91.99
		M7	288.41	156.51	97.37					a) custo de transporte do Modelo M4 (comando procv)
		M9	349.03	90.74	59.85					217.77
		M11	373.25	267.73	158.60
		M4	412.03	217.77	107.24					b) custo de montagem do Modelo M7 (comando procv)
		M12	422.07	140.44	116.82					97.37
		M10	490.54	224.61	89.48
		M22	530.45	496.36	294.58					c) custo de aquisição do Modelo M10 (comando procv)
		M8	631.17	520.35	41.66					490.54
		M15	677.75	677.25	568.86
		M24	705.79	77.48	40.33					d) custo total (trans+aquis.+Montag) dos modelos M22 e M24 (comando procv)
		M25	779.35	723.23	564.65					2144.99		M22	1321.39
		M17	812.40	311.34	189.67							M24	823.60
		M14	976.69	333.13	97.06					e) ordene os modelos por $ de aquisição crescente e então pelo $ de montagem crescente
		M19	1349.57	352.75	310.68
		M18	1376.74	1019.14	201.80
		M16	1439.29	1173.87	549.09
		M5	3427.46	3390.80	181.94
		M23	3784.49	3522.36	1483.62
		M21	5737.56	2157.82	1828.60
		M20	10138.05	5277.28	966.26
		M13	12124.89	2873.71	237.34
		M6	20221.58	6870.15	5449.01
ordem localizar substituir
	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Faturamento	%F	%F Acumulado	ABC
	Vancomicina	Salvador	Marina	123	R$1,214.00	R$149,322.00	3.738%	3.738%	A
	Vancomicina	Salvador	Marina	123	R$1,214.00	R$149,322.00	3.738%	7.476%
	Vancomicina	Curitiba	Sandra	120	R$1,214.00	R$145,680.00	3.647%	11.122%
	Vancomicina	Ribeirão Preto	Sandra	118	R$1,214.00	R$143,252.00	3.586%	14.708%
	Vancomicina	Curitiba	João	117	R$1,214.00	R$142,038.00	3.555%	18.264%
	Vancomicina	Salvador	João	114	R$1,214.00	R$138,396.00	3.464%	21.728%
	Vancomicina	Salvador	João	114	R$1,214.00	R$138,396.00	3.464%	25.192%
	Vancomicina	Barretos	Marcos	113	R$1,214.00	R$137,182.00	3.434%	28.626%
	Vancomicina	Curitiba	João	111	R$1,214.00	R$134,754.00	3.373%	31.999%
	Vancomicina	Curitiba	João	111	R$1,214.00	R$134,754.00	3.373%	35.372%
	Vancomicina	Salvador	João	110	R$1,214.00	R$133,540.00	3.343%	38.715%
	Vancomicina	Brasilia	Sandra	108	R$1,214.00	R$131,112.00	3.282%	41.997%			a) dispor vendas em ordem crescente
	Vancomicina	Ribeirão Preto	Marcos	107	R$1,214.00	R$129,898.00	3.252%	45.249%
	Vancomicina	Ribeirão Preto	Marcos	104	R$1,214.00	R$126,256.00	3.160%	48.409%
	Vancomicina	Campinas	João	103	R$1,214.00	R$125,042.00	3.130%	51.539%			b) dispor vendas em ordem crescente e então vendedores por ordem alfabética
	Vancomicina	Ribeirão Preto	Marina	101	R$1,214.00	R$122,614.00	3.069%	54.609%
	Vancomicina	Ribeirão Preto	Marcos	98	R$1,214.00	R$118,972.00	2.978%	57.587%
	Vancomicina	Campinas	Sandra	98	R$1,214.00	R$118,972.00	2.978%	60.565%			c) Fazer uma classificação ABC dos produtos de acordo com seu Total faturado
	Vancomicina	Salvador	Marina	95	R$1,214.00	R$115,330.00	2.887%	63.452%
	Vancomicina	Santos	João	93	R$1,214.00	R$112,902.00	2.826%	66.278%				Qtd.	%Qtd
	Vancomicina	Brasilia	Sandra	92	R$1,214.00	R$111,688.00	2.796%	69.074%			A	2619	21%
	Vancomicina	Barretos	Sandra	89	R$1,214.00	R$108,046.00	2.705%	71.778%			B	4114	34%
	Vancomicina	Santos	Marina	88	R$1,214.00	R$106,832.00	2.674%	74.452%			C	5528	45%
	Vancomicina	Ribeirão Preto	João	86	R$1,214.00	R$104,404.00	2.613%	77.066%				12261
	Vancomicina	Ribeirão Preto	Marina	83	R$1,214.00	R$100,762.00	2.522%	79.588%
	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00	0.574%	80.163%	B
	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00	0.574%	80.737%
	Cloranfenicol	Santos	Marina	124	R$150.00	R$18,600.00	0.466%	81.203%
	Cloranfenicol	Brasilia	João	106	R$150.00	R$15,900.00	0.398%	81.601%
	Cloranfenicol	Brasilia	João	106	R$150.00	R$15,900.00	0.398%	81.999%
	Cloranfenicol	Rio de Janeiro	Sandra	102	R$150.00	R$15,300.00	0.383%	82.382%
	Cloranfenicol	Rio de Janeiro	Sandra	102	R$150.00	R$15,300.00	0.383%	82.765%
	Cloranfenicol	Brasilia	João	98	R$150.00	R$14,700.00	0.368%	83.133%
	Cloranfenicol	Rio de Janeiro	Marcos	98	R$150.00	R$14,700.00	0.368%	83.501%
	Cloranfenicol	Curitiba	João	94	R$150.00	R$14,100.00	0.353%	83.853%
	Hidantal	Ribeirão Preto	João	126	R$110.00	R$13,860.00	0.347%	84.200%
	Hidantal	Barretos	Marcos	124	R$110.00	R$13,640.00	0.341%	84.542%
	Cloranfenicol	Barretos	Sandra	90	R$150.00	R$13,500.00	0.338%	84.880%
	Cloranfenicol	Campinas	Sandra	90	R$150.00	R$13,500.00	0.338%	85.218%
	Hidantal	Franca	Marcos	122	R$110.00	R$13,420.00	0.336%	85.554%
	Hidantal	Barretos	Marina	121	R$110.00	R$13,310.00	0.333%	85.887%
	Hidantal	Brasilia	João	120	R$110.00	R$13,200.00	0.330%	86.217%
	Hidantal	Brasilia	João	120	R$110.00	R$13,200.00	0.330%	86.548%
	Hidantal	Campinas	Marina	118	R$110.00	R$12,980.00	0.325%	86.873%
	Hidantal	Campinas	Marina	118	R$110.00	R$12,980.00	0.325%	87.197%
	Cloranfenicol	Salvador	Marcos	86	R$150.00	R$12,900.00	0.323%	87.520%
	Cloranfenicol	Salvador	Marcos	86	R$150.00	R$12,900.00	0.323%	87.843%
	Cloranfenicol	Santos	Sandra	86	R$150.00	R$12,900.00	0.323%	88.166%
	Cloranfenicol	Santos	Sandra	86	R$150.00	R$12,900.00	0.323%	88.489%
	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00	0.319%	88.809%
	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00	0.319%	89.128%
	Hidantal	Ribeirão Preto	Sandra	116	R$110.00	R$12,760.00	0.319%	89.447%
	Cloranfenicol	Salvador	Marcos	82	R$150.00	R$12,300.00	0.308%	89.755%
	Cloranfenicol	Salvador	Marcos	82	R$150.00	R$12,300.00	0.308%	90.063%
	Hidantal	Curitiba	Sandra	111	R$110.00	R$12,210.00	0.306%	90.369%
	Cloranfenicol	Curitiba	Sandra	78	R$150.00	R$11,700.00	0.293%	90.662%
	Cloranfenicol	Curitiba	Sandra	78	R$150.00	R$11,700.00	0.293%	90.955%
	Hidantal	Salvador	Marcos	106	R$110.00	R$11,660.00	0.292%	91.246%
	Hidantal	Salvador	Marina	101	R$110.00	R$11,110.00	0.278%	91.524%
	Hidantal	Franca	Marina	96	R$110.00	R$10,560.00	0.264%	91.789%
	Hidantal	Barretos	Sandra	91	R$110.00	R$10,010.00	0.251%	92.039%
	Fenobarbital	Ribeirão Preto	João	114	R$86.00	R$9,804.00	0.245%	92.285%
	Fenobarbital	Curitiba	Marina	112	R$86.00	R$9,632.00	0.241%	92.526%
	Hidantal	Brasilia	João	86	R$110.00	R$9,460.00	0.237%	92.763%
	Fenobarbital	Franca	Marina	110	R$86.00	R$9,460.00	0.237%	93.000%	C
	Fenobarbital	Franca	Marina	110	R$86.00	R$9,460.00	0.237%	93.236%
	Fenobarbital	Santos	Sandra	108	R$86.00	R$9,288.00	0.232%	93.469%
	Fenobarbital	Rio de Janeiro	Marcos	106	R$86.00	R$9,116.00	0.228%	93.697%
	Fenobarbital	Ribeirão Preto	João	104	R$86.00	R$8,944.00	0.224%	93.921%
	Fenobarbital	Santos	Marcos	102	R$86.00	R$8,772.00	0.220%	94.140%
	Dipirona	Brasilia	Marina	134	R$65.00	R$8,710.00	0.218%	94.358%
	Fenobarbital	Curitiba	Marcos	100	R$86.00	R$8,600.00	0.215%	94.574%
	Dipirona	Rio de Janeiro	João	131	R$65.00	R$8,515.00	0.213%	94.787%
	Dipirona	Salvador	João	130	R$65.00	R$8,450.00	0.212%	94.998%
	Fenobarbital	Rio de Janeiro	Marina	98	R$86.00	R$8,428.00	0.211%	95.209%
	Dipirona	Franca	Marcos	128	R$65.00	R$8,320.00	0.208%	95.418%
	Fenobarbital	Franca	Sandra	96	R$86.00	R$8,256.00	0.207%	95.624%
	Dipirona	Ribeirão Preto	Marcos	126	R$65.00	R$8,190.00	0.205%	95.829%
	Dipirona	Curitiba	Marcos	125	R$65.00	R$8,125.00	0.203%	96.033%
	Dipirona	Ribeirão Preto	João	122	R$65.00	R$7,930.00	0.199%	96.231%
	Dipirona	Curitiba	Marina	122	R$65.00	R$7,930.00	0.199%	96.430%
	Dipirona	Brasilia	Sandra	119	R$65.00	R$7,735.00	0.194%	96.623%
	Dipirona	Brasilia	Sandra	119	R$65.00	R$7,735.00	0.194%	96.817%
	Dipirona	Campinas	Marcos	118	R$65.00	R$7,670.00	0.192%	97.009%
	Dipirona	Santos	João	116	R$65.00	R$7,540.00	0.189%	97.198%
	Dipirona	Barretos	Marina	114	R$65.00	R$7,410.00	0.185%	97.383%
	Dipirona	Rio de Janeiro	Sandra	113	R$65.00	R$7,345.00	0.184%	97.567%
	Dipirona	Ribeirão Preto	João	110	R$65.00	R$7,150.00	0.179%	97.746%
	Dipirona	Ribeirão Preto	João	110	R$65.00	R$7,150.00	0.179%	97.925%
	Dipirona	Campinas	Marina	110	R$65.00	R$7,150.00	0.179%	98.104%
	Dipirona	Curitiba	Marina	107	R$65.00	R$6,955.00	0.174%	98.278%
	Dipirona
Santos	João	104	R$65.00	R$6,760.00	0.169%	98.447%
	Dipirona	Franca	Marcos	101	R$65.00	R$6,565.00	0.164%	98.612%
	Dipirona	Salvador	João	98	R$65.00	R$6,370.00	0.159%	98.771%
	Dipirona	Barretos	Marcos	95	R$65.00	R$6,175.00	0.155%	98.926%
	Dipirona	Barretos	Marcos	95	R$65.00	R$6,175.00	0.155%	99.080%
	Dipirona	Curitiba	Sandra	94	R$65.00	R$6,110.00	0.153%	99.233%
	Dipirona	Ribeirão Preto	Marcos	92	R$65.00	R$5,980.00	0.150%	99.383%
	Omeprazol	Campinas	Marina	108	R$14.00	R$1,512.00	0.038%	99.421%
	Omeprazol	Ribeirão Preto	Marina	105	R$14.00	R$1,470.00	0.037%	99.458%
	Omeprazol	Ribeirão Preto	Marina	102	R$14.00	R$1,428.00	0.036%	99.493%
	Omeprazol	Franca	Sandra	99	R$14.00	R$1,386.00	0.035%	99.528%
	Omeprazol	Rio de Janeiro	Marcos	96	R$14.00	R$1,344.00	0.034%	99.562%
	Omeprazol	Brasilia	Sandra	93	R$14.00	R$1,302.00	0.033%	99.594%
	Omeprazol	Santos	João	90	R$14.00	R$1,260.00	0.032%	99.626%
	Omeprazol	Santos	João	87	R$14.00	R$1,218.00	0.030%	99.656%
	Omeprazol	Curitiba	João	84	R$14.00	R$1,176.00	0.029%	99.686%
	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00	0.028%	99.714%
	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00	0.028%	99.742%
	Omeprazol	Franca	Marina	81	R$14.00	R$1,134.00	0.028%	99.771%
	Omeprazol	Brasilia	Sandra	78	R$14.00	R$1,092.00	0.027%	99.798%
	Omeprazol	Rio de Janeiro	Sandra	76	R$14.00	R$1,064.00	0.027%	99.825%
	Omeprazol	Rio de Janeiro	Sandra	76	R$14.00	R$1,064.00	0.027%	99.851%
	Omeprazol	Ribeirão Preto	Marina	75	R$14.00	R$1,050.00	0.026%	99.878%
	Omeprazol	Ribeirão Preto	João	72	R$14.00	R$1,008.00	0.025%	99.903%
	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00	0.025%	99.928%
	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00	0.025%	99.953%
	Omeprazol	Campinas	João	69	R$14.00	R$966.00	0.024%	99.977%
	Omeprazol	Curitiba	Marina	66	R$14.00	R$924.00	0.023%	100.000%
					TOTAL	R$3,994,905.00
geral
	
	a) filtrar no mesmo local carros fabricados por audi e bmw
	
	b) formatar condicionalmente todos os veículos com preço > 15000
	
	c) ordenar os carros por preço (decrescente), então por potência (crescente), e então por consumo (decrescente)
	
	d) substituir audi por Audi
	
	e) calcular o consumo médio dos veículos peugeot				24.5
	
	f) filtrar em outro local veículos volvo com preço > $20000				No final da planilha
	
	make:	fuel-type:	aspiration:	num-of-doors:	body-style:	drive-wheels:	engine-location:	curb-weight:	engine-type:	num-of-cylinders:	engine-size:	fuel-system:	horsepower:	peak-rpm:	city-mpg:	highway-mpg:	price:
	volvo																>20000
	
	make:	fuel-type:	aspiration:	num-of-doors:	body-style:	drive-wheels:	engine-location:	curb-weight:	engine-type:	num-of-cylinders:	engine-size:	fuel-system:	horsepower:	peak-rpm:	city-mpg:	highway-mpg:	price:
	mercedes-benz	gas	std	two	hardtop	rwd	front	3715	ohcv	eight	304	mpfi	184	4500	14	16	45400
	bmw	gas	std	two	sedan	rwd	front	3380	ohc	six	209	mpfi	182	5400	16	22	41315
	mercedes-benz	gas	std	four	sedan	rwd	front	3900	ohcv	eight	308	mpfi	184	4500	14	16	40960
	porsche	gas	std	two	convertible	rwd	rear	2800	ohcf	six	194	mpfi	207	5900	17	25	37028
	porsche	gas	std	two	hatchback	rwd	front	3366	dohcv	eight	203	mpfi	288	5750	17	28	37028
	bmw	gas	std	four	sedan	rwd	front	3505	ohc	six	209	mpfi	182	5400	15	20	36880
	jaguar	gas	std	two	sedan	rwd	front	3950	ohcv	twelve	326	mpfi	262	5000	13	17	36000
	jaguar	gas	std	four	sedan	rwd	front	4066	dohc	six	258	mpfi	176	4750	15	19	35550
	mercedes-benz	gas	std	two	convertible	rwd	front	3685	ohcv	eight	234	mpfi	155	4750	16	18	35056
	mercedes-benz	gas	std	four	sedan	rwd	front	3740	ohcv	eight	234	mpfi	155	4750	16	18	34184
	porsche	gas	std	two	hardtop	rwd	rear	2756	ohcf	six	194	mpfi	207	5900	17	25	34028
	porsche	gas	std	two	hardtop	rwd	rear	2756	ohcf	six	194	mpfi	207	5900	17	25	32528
	jaguar	gas	std	four	sedan	rwd	front	4066	dohc	six	258	mpfi	176	4750	15	19	32250
	mercedes-benz	diesel	turbo	four	sedan	rwd	front	3770	ohc	five	183	idi	123	4350	22	25	31600
	bmw	gas	std	four	sedan	rwd	front	3230	ohc	six	209	mpfi	182	5400	16	22	30760
	mercedes-benz	diesel	turbo	four	wagon	rwd	front	3750	ohc	five	183	idi	123	4350	22	25	28248
	mercedes-benz	diesel	turbo	two	hardtop	rwd	front	3495	ohc	five	183	idi	123	4350	22	25	28176
	mercedes-benz	diesel	turbo	four	sedan	rwd	front	3515	ohc	five	183	idi	123	4350	22	25	25552
	bmw	gas	std	four	sedan	rwd	front	3055	ohc	six	164	mpfi	121	4250	20	25	24565
	audi	gas	turbo	four	sedan	fwd	front	3086	ohc	five	131	mpfi	140	5500	17	20	23875
	audi	gas	turbo	two	hatchback	4wd	front	3053	ohc	five	131	mpfi	160	5500	16	22	23875
	volvo	gas	turbo	four	sedan	rwd	front	3062	ohc	four	141	mpfi	114	5400	19	25	22625
	volvo	diesel	turbo	four	sedan	rwd	front	3217	ohc	six	145	idi	106	4800	26	27	22470
	porsche	gas	std	two	hatchback	rwd	front	2778	ohc	four	151	mpfi	143	5500	19	27	22018
	volvo	gas	std	four	sedan	rwd	front	3012	ohcv	six	173	mpfi	134	5500	18	23	21485
	bmw	gas	std	four	sedan	rwd	front	2765	ohc	six	164	mpfi	121	4250	21	28	21105
	bmw	gas	std	two	sedan	rwd	front	2710	ohc	six	164	mpfi	121	4250	21	28	20970
	nissan	gas	turbo	two	hatchback	rwd	front	3139	ohcv	six	181	mpfi	200	5200	17	23	19699
	volvo	gas	turbo	four	sedan	rwd	front	3049	ohc	four	141	mpfi	160	5300	19	25	19045
	volvo	gas	turbo	four	wagon	rwd	front	3157	ohc	four	130	mpfi	162	5100	17	22	18950
	audi	gas	std	four	wagon	fwd	front	2954	ohc	five	136	mpfi	110	5500	19	25	18920
	saab	gas	turbo	four	sedan	fwd	front	2847	dohc	four	121	mpfi	160	5500	19	26	18620
	volvo	gas	turbo	four	sedan	rwd	front	3045	ohc	four	130	mpfi	162	5100	17	22	18420
	nissan	gas	std	two	hatchback	rwd	front	3139	ohcv	six	181	mpfi	160	5200	19	25	18399
	mazda	diesel	std	four	sedan	rwd	front	2700	ohc	four	134	idi	72	4200	31	39	18344
	mazda	gas	std	four	sedan	rwd	front	2670	ohc	four	140	mpfi	120	5000	19	27	18280
	peugot	gas	turbo	four	sedan	rwd	front	3130	l	four	134	mpfi	142	5600	18	24	18150
	saab	gas	turbo	two	hatchback	fwd	front	2808	dohc	four	121	mpfi	160	5500	19	26	18150
	peugot	diesel	turbo	four	sedan	rwd	front	3252	l	four	152	idi	95	4150	28	33	17950
	audi	gas	std	four	sedan	fwd	front	2844	ohc	five	136	mpfi	110	5500	19	25	17710
	toyota	gas	std	two	convertible	rwd	front	2975	ohc	four	146	mpfi	116	4800	24	30	17669
	audi	gas	std	four	sedan	4wd	front	2824	ohc	five	136	mpfi	115	5500	18	22	17450
	nissan	gas	std	two	hatchback	rwd	front	3071	ohcv	six	181	mpfi	160	5200	19	25	17199
	peugot	diesel	turbo	four	wagon	rwd	front	3485	l	four	152	idi	95	4150	25	25	17075
	bmw	gas	std	four	sedan	rwd	front	2395	ohc	four	108	mpfi	101	5800	23	29	16925
	peugot	diesel	turbo	four	sedan	rwd	front	3252	l	four	152	idi	95	4150	28	33	16900
	volvo	gas	std	four	sedan	rwd	front	2952	ohc	four	141	mpfi	114	5400	23	28	16845
	peugot	gas	std	four	wagon	rwd	front	3285	l	four	120	mpfi	95	5000	19	24	16695
	peugot	gas	std	four	sedan	rwd	front	3075	l	four	120	mpfi	97	5000	19	24	16630
	toyota	gas	std	two	hatchback	rwd	front	2976	dohc	six	171	mpfi	161	5200	20	24	16558
	volvo	gas	std	four	wagon	rwd	front	3042	ohc	four	141	mpfi	114	5400	24	28	16515
	mercury	gas	turbo	two	hatchback	rwd	front	2910	ohc	four	140	mpfi	175	5000	19	24	16503
	alfa-romero	gas	std	two	convertible	rwd	front	2548	dohc	four	130	mpfi	111	5000	21	27	16500
	alfa-romero	gas	std	two	hatchback	rwd	front	2823	ohcv	six	152	mpfi	154	5000	19	26	16500
	bmw	gas	std	two	sedan	rwd	front	2395	ohc	four	108	mpfi	101	5800	23	29	16430
	toyota	gas	std	two	hatchback	rwd	front	3016	dohc	six	171	mpfi	161	5200	19	24	15998
	volvo	gas	std	four	sedan	rwd	front	2935	ohc	four	141	mpfi	114	5400	24	28	15985
	toyota	gas	std	four	wagon	rwd	front	3151	dohc	six	161	mpfi	156	5200	19	24	15750
	toyota	gas	std	four	sedan	rwd	front	3131	dohc	six	171	mpfi	156	5200	20	24	15690
	mazda	gas	std	two	hatchback	rwd	front	2500	rotor	two	80	mpfi	135	6000	16	23	15645
	peugot	gas	std	four	sedan	rwd	front	3075	l	four	120	mpfi	95	5000	19	24	15580
	saab	gas	std	four	sedan	fwd	front	2758	ohc	four	121	mpfi	110	5250	21	28	15510
	audi	gas	std	two	sedan	fwd	front	2507	ohc	five	136	mpfi	110	5500	19	25	15250
	saab	gas	std
two	hatchback	fwd	front	2707	ohc	four	121	mpfi	110	5250	21	28	15040
	mitsubishi	gas	turbo	two	hatchback	fwd	front	2921	ohc	four	156	spdi	145	5000	19	24	14869
	mitsubishi	gas	turbo	two	hatchback	fwd	front	2926	ohc	four	156	spdi	145	5000	19	24	14489
	nissan	gas	std	four	wagon	fwd	front	3296	ohcv	six	181	mpfi	152	5200	17	22	14399
	audi	gas	std	four	sedan	fwd	front	2337	ohc	four	109	mpfi	102	5500	24	30	13950
	peugot	diesel	turbo	four	wagon	rwd	front	3430	l	four	152	idi	95	4150	25	25	13860
	volkswagen	diesel	turbo	four	sedan	fwd	front	2579	ohc	four	97	idi	68	4500	33	38	13845
	mazda	gas	std	two	hatchback	rwd	front	2385	rotor	two	70	4bbl	101	6000	17	23	13645
	nissan	gas	std	four	sedan	fwd	front	3095	ohcv	six	181	mpfi	152	5200	17	22	13499
	nissan	gas	std	four	sedan	fwd	front	3060	ohcv	six	181	mpfi	152	5200	19	25	13499
	alfa-romero	gas	std	two	convertible	rwd	front	2548	dohc	four	130	mpfi	111	5000	21	27	13495
	volvo	gas	std	four	wagon	rwd	front	3034	ohc	four	141	mpfi	114	5400	23	28	13415
	volkswagen	gas	std	four	sedan	fwd	front	2661	ohc	five	136	mpfi	110	5500	19	24	13295
	peugot	diesel	turbo	four	sedan	rwd	front	3197	l	four	152	idi	95	4150	28	33	13200
	dodge	gas	turbo	two	hatchback	fwd	front	2811	ohc	four	156	mfi	145	5000	19	24	12964
	honda	gas	std	four	sedan	fwd	front	2465	ohc	four	110	mpfi	101	5800	24	28	12945
	volvo	gas	std	four	sedan	rwd	front	2912	ohc	four	141	mpfi	114	5400	23	28	12940
	plymouth	gas	turbo	two	hatchback	rwd	front	2818	ohc	four	156	spdi	145	5000	19	24	12764
	mitsubishi	gas	turbo	two	hatchback	fwd	front	2833	ohc	four	156	spdi	145	5000	19	24	12629
	peugot	gas	std	four	wagon	rwd	front	3230	l	four	120	mpfi	97	5000	19	24	12440
	volkswagen	gas	std	four	wagon	fwd	front	2563	ohc	four	109	mpfi	88	5500	25	31	12290
	saab	gas	std	four	sedan	fwd	front	2695	ohc	four	121	mpfi	110	5250	21	28	12170
	peugot	gas	std	four	sedan	rwd	front	3020	l	four	120	mpfi	97	5000	19	24	11900
	saab	gas	std	two	hatchback	fwd	front	2658	ohc	four	121	mpfi	110	5250	21	28	11850
	mazda	gas	std	two	hatchback	rwd	front	2380	rotor	two	70	4bbl	101	6000	17	23	11845
	subaru	gas	turbo	four	wagon	4wd	front	2650	ohcf	four	108	mpfi	111	4800	23	23	11694
	volkswagen	gas	std	two	convertible	fwd	front	2254	ohc	four	109	mpfi	90	5500	24	29	11595
	toyota	gas	std	two	hatchback	rwd	front	2714	ohc	four	146	mpfi	116	4800	24	30	11549
	subaru	gas	turbo	four	sedan	4wd	front	2510	ohcf	four	108	mpfi	111	4800	24	29	11259
	toyota	gas	std	four	hatchback	fwd	front	2458	ohc	four	122	mpfi	92	4200	27	32	11248
	mazda	gas	std	four	hatchback	fwd	front	2425	ohc	four	122	2bbl	84	4800	26	32	11245
	toyota	gas	std	two	hardtop	rwd	front	2679	ohc	four	146	mpfi	116	4800	24	30	11199
	isuzu	gas	std	two	hatchback	rwd	front	2734	ohc	four	119	spfi	90	5000	24	29	11048
	mazda	gas	std	two	hatchback	rwd	front	2380	rotor	two	70	4bbl	101	6000	17	23	10945
	toyota	gas	std	four	sedan	fwd	front	2414	ohc	four	122	mpfi	92	4200	27	32	10898
	mazda	diesel	std	?	sedan	fwd	front	2443	ohc	four	122	idi	64	4650	36	42	10795
	toyota	diesel	turbo	four	sedan	fwd	front	2480	ohc	four	110	idi	73	4500	30	33	10698
	mazda	gas	std	two	hatchback	fwd	front	2385	ohc	four	122	2bbl	84	4800	26	32	10595
	isuzu	gas	std	four	sedan	fwd	front	1909	ohc	four	90	2bbl	70	5400	38	43	10345
	isuzu	gas	std	two	sedan	fwd	front	1874	ohc	four	90	2bbl	70	5400	38	43	10345
	isuzu	gas	std	four	sedan	rwd	front	2337	ohc	four	111	2bbl	78	4800	24	29	10345
	honda	gas	std	two	sedan	fwd	front	2293	ohc	four	110	2bbl	100	5500	25	31	10345
	honda	gas	std	four	sedan	fwd	front	2372	ohc	four	110	1bbl	86	5800	27	33	10295
	mazda	gas	std	four	sedan	fwd	front	2410	ohc	four	122	2bbl	84	4800	26	32	10245
	subaru	gas	std	four	wagon	fwd	front	2455	ohcf	four	108	mpfi	94	5200	25	31	10198
	volkswagen	gas	std	four	sedan	fwd	front	2300	ohc	four	109	mpfi	100	5500	26	32	9995
	toyota	gas	std	two	hatchback	rwd	front	2551	ohc	four	146	mpfi	116	4800	24	30	9989
	toyota	gas	std	four	hatchback	fwd	front	2414	ohc	four	122	mpfi	92	4200	27	32	9988
	volkswagen	gas	std	two	hatchback	fwd	front	2221	ohc	four	109	mpfi	90	5500	24	29	9980
	subaru	gas	std	four	sedan	fwd	front	2340	ohcf	four	108	mpfi	94	5200	26	32	9960
	mitsubishi	gas	turbo	two	hatchback	fwd	front	2370	ohc	four	110	spdi	116	5500	23	30	9959
	renault	gas	std	two	hatchback	fwd	front	2460	ohc	four	132	mpfi	288	5750	23	31	9895
	toyota	gas	std	two	hardtop	rwd	front	2536	ohc	four	146	mpfi	116	4800	24	30	9639
	nissan	gas	std	four	sedan	fwd	front	2302	ohc	four	120	2bbl	97	5200	27	34	9549
	toyota	gas	std	two	hatchback	rwd	front	2300	dohc	four	98	mpfi	112	6600	26	29	9538
	volkswagen	diesel	turbo	four	sedan	fwd	front	2319	ohc	four	97	idi	68	4500	37	42	9495
	toyota	gas	std	two	sedan	rwd	front	2265	dohc	four	98	mpfi	112	6600	26	29	9298
	renault	gas	std	four	wagon	fwd	front	2579	ohc	four	132	mpfi	288	5750	23	31	9295
	mitsubishi	gas	std	four	sedan	fwd	front	2403	ohc	four	110	spdi	116	5500	23	30	9279
	mitsubishi	gas	turbo	four	sedan	fwd	front	2403	ohc	four	110	spdi	116	5500	23	30	9279
	toyota	gas	std	four	sedan	fwd	front	2140	ohc	four	98	2bbl	70	4800	28	34	9258
	subaru	gas	std	four	sedan	4wd	front	2385	ohcf	four	108	2bbl	82	4800	24	25	9233
	honda	gas	std	two	hatchback	fwd	front	2289	ohc	four	110	1bbl	86	5800	27	33	9095
	nissan	gas	std	four	hatchback	fwd	front	2324	ohc	four	120	2bbl	97	5200	27	34	8949
	toyota	gas	std	four	sedan	fwd	front	2326	ohc	four	122	mpfi	92	4200	29	34	8948
	plymouth	gas	std	four	wagon	fwd	front	2535	ohc	four	122	2bbl	88	5000	24	30	8921
	dodge	gas	std	four	wagon	fwd	front	2535	ohc	four	122	2bbl	88	5000	24	30	8921
	mazda	gas	std	two	hatchback	fwd	front	2385	ohc	four	122	2bbl	84	4800	26	32	8845
	honda	gas	std	four	sedan	fwd	front	2304	ohc	four	110	1bbl	86	5800	27	33	8845
	toyota	gas	std	four	wagon	4wd	front	3110	ohc	four	92	2bbl	62	4800	27	32	8778
	dodge	gas	turbo	four	sedan	fwd	front	2191	ohc	four	98	mpfi	102	5500	24	30	8558
	mitsubishi	gas	std	two	hatchback	fwd	front	2328	ohc	four	122	2bbl	88	5000	25	32	8499
	mazda	gas	std	four	sedan	fwd	front	2410	ohc	four	122	2bbl	84	4800	26	32	8495
	volkswagen	gas	std	four	sedan	fwd	front	2275	ohc	four	109	mpfi	85	5250	27	34	8495
	toyota	gas	std	two	hardtop	rwd	front	2540	ohc	four	146	mpfi	116	4800	24	30	8449
	toyota	gas	std	four	hatchback	fwd	front	2122	ohc	four	98	2bbl	70	4800	28	34	8358
	nissan	gas	std	two	hardtop	fwd	front	2008	ohc	four	97	2bbl	69	5200	31	37	8249
	toyota	gas	std	two	hatchback	rwd	front	2204	ohc	four	98	2bbl	70	4800	29	34	8238
	volkswagen	gas	std	four	sedan	fwd	front	2212	ohc	four	109	mpfi	85	5250	27	34	8195
	mitsubishi	gas	std	four	sedan	fwd	front	2405	ohc	four	122	2bbl	88	5000	25	32	8189
	toyota	gas	std	two	sedan	rwd	front	2169	ohc	four	98	2bbl	70	4800	29	34	8058
	subaru	gas	std	four	wagon	4wd	front	2420	ohcf	four	108	2bbl	82	4800	23	29	8013
	nissan	gas	std	four	wagon	fwd	front	2037	ohc	four	97	2bbl	69	5200	31	37	7999
	volkswagen	diesel	std	four	sedan	fwd	front	2264	ohc	four	97	idi	52	4800	37	46	7995
	volkswagen	gas	std	two	sedan	fwd	front	2209	ohc	four	109	mpfi	85	5250	27	34	7975
	plymouth	gas	turbo	two	hatchback	fwd	front	2128	ohc	four	98	spdi	102	5500	24	30	7957
	dodge	gas	turbo	two	hatchback	fwd	front	2128	ohc	four	98	mpfi	102	5500	24	30	7957
	toyota	diesel	std	four	sedan	fwd	front	2275	ohc	four	110	idi	56	4500	34	36	7898
	toyota	gas	std	four	wagon	4wd	front	2290	ohc	four	92	2bbl	62	4800	27	32	7898
	honda	gas	std	two	hatchback	fwd	front	2236	ohc	four	110	1bbl	86	5800	27	33	7895
	nissan	gas	std	two	hatchback	fwd	front	2028	ohc	four	97	2bbl	69	5200	31	37	7799
	toyota	diesel	std	four	hatchback	fwd	front	2275	ohc	four	110	idi	56	4500	38	47	7788
	volkswagen	diesel	std	two	sedan	fwd	front	2261	ohc	four	97	idi	52	4800	37	46	7775
	subaru	gas	std	four	sedan	fwd	front	2190	ohcf	four	108	2bbl	82	4400	28	33	7775
	toyota	gas	std	four	sedan	fwd	front	2094	ohc	four	98	2bbl	70	4800	38	47	7738
	mitsubishi	gas	turbo	two	hatchback	fwd	front	2145	ohc	four	98	spdi	102	5500	24	30	7689
	dodge	gas	std	four	sedan	fwd	front	1989	ohc	four	90	2bbl	68	5500	31	38	7609
	plymouth
gas	std	four	sedan	fwd	front	2191	ohc	four	98	2bbl	68	5500	31	38	7609
	subaru	gas	std	two	hatchback	4wd	front	2240	ohcf	four	108	2bbl	73	4400	26	31	7603
	nissan	gas	std	four	sedan	fwd	front	1971	ohc	four	97	2bbl	69	5200	31	37	7499
	subaru	gas	std	four	wagon	fwd	front	2290	ohcf	four	108	2bbl	82	4800	28	32	7463
	mazda	gas	std	four	sedan	fwd	front	1950	ohc	four	91	2bbl	68	5000	31	38	7395
	nissan	gas	std	four	wagon	fwd	front	2024	ohc	four	97	2bbl	69	5200	31	37	7349
	nissan	gas	std	two	sedan	fwd	front	1951	ohc	four	97	2bbl	69	5200	31	37	7299
	honda	gas	std	four	wagon	fwd	front	2024	ohc	four	92	1bbl	76	6000	30	34	7295
	honda	gas	std	four	sedan	fwd	front	2010	ohc	four	92	1bbl	76	6000	30	34	7295
	toyota	gas	std	four	hatchback	fwd	front	2109	ohc	four	98	2bbl	70	4800	30	37	7198
	honda	gas	std	two	hatchback	fwd	front	1956	ohc	four	92	1bbl	76	6000	30	34	7129
	subaru	gas	std	four	sedan	fwd	front	2145	ohcf	four	108	2bbl	82	4800	32	37	7126
	nissan	diesel	std	two	sedan	fwd	front	2017	ohc	four	103	idi	55	4800	45	50	7099
	subaru	gas	std	two	hatchback	fwd	front	2120	ohcf	four	108	2bbl	73	4400	26	31	7053
	mitsubishi	gas	std	four	sedan	fwd	front	2365	ohc	four	122	2bbl	88	5000	25	32	6989
	toyota	gas	std	four	sedan	fwd	front	2081	ohc	four	98	2bbl	70	4800	30	37	6938
	toyota	gas	std	four	wagon	fwd	front	2280	ohc	four	92	2bbl	62	4800	31	37	6918
	honda	gas	std	two	hatchback	fwd	front	1819	ohc	four	92	1bbl	76	6000	31	38	6855
	nissan	gas	std	four	sedan	fwd	front	1938	ohc	four	97	2bbl	69	5200	31	37	6849
	mazda	gas	std	two	hatchback	fwd	front	1905	ohc	four	91	2bbl	68	5000	31	38	6795
	mazda	gas	std	four	sedan	fwd	front	1945	ohc	four	91	2bbl	68	5000	31	38	6695
	dodge	gas	std	four	sedan	fwd	front	1989	ohc	four	90	2bbl	68	5500	31	38	6692
	plymouth	gas	std	four	sedan	fwd	front	1989	ohc	four	90	2bbl	68	5500	31	38	6692
	mitsubishi	gas	std	two	hatchback	fwd	front	2004	ohc	four	92	2bbl	68	5500	31	38	6669
	nissan	gas	std	two	sedan	fwd	front	1918	ohc	four	97	2bbl	69	5200	31	37	6649
	chevrolet	gas	std	four	sedan	fwd	front	1909	ohc	four	90	2bbl	70	5400	38	43	6575
	honda	gas	std	two	hatchback	fwd	front	1940	ohc	four	92	1bbl	76	6000	30	34	6529
	toyota	gas	std	four	hatchback	fwd	front	2015	ohc	four	92	2bbl	62	4800	31	38	6488
	honda	gas	std	two	hatchback	fwd	front	1713	ohc	four	92	1bbl	58	4800	49	54	6479
	dodge	gas	std	two	hatchback	fwd	front	1876	ohc	four	90	2bbl	68	5500	31	38	6377
	toyota	gas	std	two	hatchback	fwd	front	2040	ohc	four	92	2bbl	62	4800	31	38	6338
	chevrolet	gas	std	two	hatchback	fwd	front	1874	ohc	four	90	2bbl	70	5400	38	43	6295
	plymouth	gas	std	four	hatchback	fwd	front	1967	ohc	four	90	2bbl	68	5500	31	38	6229
	dodge	gas	std	four	hatchback	fwd	front	1967	ohc	four	90	2bbl	68	5500	31	38	6229
	mitsubishi	gas	std	two	hatchback	fwd	front	1944	ohc	four	92	2bbl	68	5500	31	38	6189
	mazda	gas	std	two	hatchback	fwd	front	1900	ohc	four	91	2bbl	68	5000	31	38	6095
	dodge	gas	std	two	hatchback	fwd	front	1876	ohc	four	90	2bbl	68	5500	37	41	5572
	plymouth	gas	std	two	hatchback	fwd	front	1918	ohc	four	90	2bbl	68	5500	37	41	5572
	nissan	gas	std	two	sedan	fwd	front	1889	ohc	four	97	2bbl	69	5200	31	37	5499
	honda	gas	std	two	hatchback	fwd	front	1837	ohc	four	79	1bbl	60	5500	38	42	5399
	mitsubishi	gas	std	two	hatchback	fwd	front	1918	ohc	four	92	2bbl	68	5500	37	41	5389
	toyota	gas	std	two	hatchback	fwd	front	1985	ohc	four	92	2bbl	62	4800	35	39	5348
	mazda	gas	std	two	hatchback	fwd	front	1890	ohc	four	91	2bbl	68	5000	30	31	5195
	chevrolet	gas	std	two	hatchback	fwd	front	1488	l	three	61	2bbl	48	5100	47	53	5151
	subaru	gas	std	two	hatchback	fwd	front	2050	ohcf	four	97	2bbl	69	4900	31	36	5118
	
	
	make:	fuel-type:	aspiration:	num-of-doors:	body-style:	drive-wheels:	engine-location:	curb-weight:	engine-type:	num-of-cylinders:	engine-size:	fuel-system:	horsepower:	peak-rpm:	city-mpg:	highway-mpg:	price:
	volvo	gas	turbo	four	sedan	rwd	front	3062	ohc	four	141	mpfi	114	5400	19	25	22625
	volvo	diesel	turbo	four	sedan	rwd	front	3217	ohc	six	145	idi	106	4800	26	27	22470
	volvo	gas	std	four	sedan	rwd	front	3012	ohcv	six	173	mpfi	134	5500	18	23	21485
Na média está sendo avaliada também a diferença do consumo na cidade e na estrada.

Teste o Premium para desbloquear

Aproveite todos os benefícios por 3 dias sem pagar! 😉
Já tem cadastro?

Continue navegando