FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

IS 253 ZA / ZB - Spring 2022 - Assignment 4 - Module 2 Assigned: 03/06/2022 Due: 03/13/2022 Total = 100 Points Problem 1. [Ref:

IS 253 ZA / ZB - Spring 2022 - Assignment 4 - Module 2 Assigned: 03/06/2022 Due: 03/13/2022 Total = 100 Points Problem 1. [Ref: Lecture 2.5 and 2.6] The data collected with respect to various cars and make (and models) is tabulated in the Worksheet named, 'Cars'. Use appropriate excel functions to compute the following:

a) Count the number of cars in each region - Asia, Europe, and USA. - 15 Points

b) What is the maximum and minimum price paid for a car, among the ones listed? - 10 Points

c) What is the average price of all cars listed in the data sheet as Type, 'Luxury Sedans'? -15 Points

d) What is the average MPG of cars, that are of type,' Midsized sport-utility vehicles'? - 10 Points

e) What is the average time to go from 0-60, for all cars with a 'turbo' engine? - 10 Points

f) What is the minimum and maximum time taken by any car to go from 0-60, among the cars listed in the worksheet? - 10 Points

g) Select any car of your choice from the list of cars given (Dream car :D) and note down the price of the car. Now use the 'Loans' work sheet to calculate your monthly payment using the PMT function ONLY. -15 Points h) Use the sort (and filter) functionality of Excel to sort cars from low to high of their HP (Horse Power). -15 Point

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Constitutional Law Governmental Powers and Individual Freedoms

Constitutional Law Governmental Powers and Individual Freedoms

Authors: Daniel Hall, John Feldmeier

2nd edition

135109507, 978-0135109502

Students also viewed these Mathematics questions

Question

★★★★★
Broussard Skateboard's sales are expected to increase by 15% from $8 million in 2013 to $9.2 million in 2014. Its assets totaled $5 million at the end of 2013. Broussard is already at full capacity,...

Answered: 1 week ago

Question

★★★★★
What criteria do you think should be used to measure team performance? What sources should be used for the appraisal? Should individual performance still be measured? Why or why not?

Answered: 1 week ago

Question

★★★★★
Was Marisol right to assume that if one therapist wasnt helping her much, she should try another? Why or why not?

Answered: 1 week ago

Question

★★★★★
It takes a force of 80.0N to compress the spring of a toy popgun 0.200m to load a 0.180-kg ball. With what speed will the ball leave the gun?

Answered: 1 week ago

Question

★★★★★
2. The 2016 income statement of Salem Company follows: SALEM COMPANY Consolidated Statements of Operations In thousands For the Years Ended December 31 Sales 20162015 $472,145$393,218 42,130 10,002...

Answered: 1 week ago

Question

★★★★★
The law of contract acts as a golden thread throughout all business transactions. It governs the foundational agreements in such business transactions, thereby providing a legal framework for rights,...

Answered: 1 week ago

Question

★★★★★
An automobile assembly line operates for two shifts aday.Thefirst shiftaccountsfortwo-thirds oftheover-all production. The task of quality control engineers is to monitor the number of...

Answered: 1 week ago

Question

★★★★★
Safe or not, he made it up the tower; since he is, after all, a warrior. The ransom note read: "If you wish to see Princess Eva alive, bring all the diamonds from the royal treasury to the Kingdom of...

Answered: 1 week ago

Question

★★★★★
There are 7 Code-A-Pillar command blocks; 3 left, 2 straight, 1 right, and 1 sound. 3 blocks were chosen at random for the Code-A-Pillar. What is the probability that the 2 straights were chosen for...

Answered: 1 week ago

Question

★★★★★
1) An organisation has the following contribution function: Contribution = 5X + 10Y where X = the number of units of product X produced, and Y = the number of units of product Y produced. A graph has...

Answered: 1 week ago

Question

★★★★★
Case Study: If Only I Had Known A few months ago, Maria Turks, manager of client care at Willowpark Retirement Centre, was asked to review a job description for caregiver as 25 people in this job...

Answered: 1 week ago

Question

★★★★★
Using the following information select the appropriate interpretation for the correlation coefficient: Variables being compared are number of years of experience at a job and annual salary. r= +0.89...

Answered: 1 week ago

Previous Question Next Question
Model ID Model Type Price HP Eng size Cyl Eng type MPG Time0-60 Weight Date Region Eng type01
1 Acura MDX Midsized sport-utility vehicles $46,365 300 3.7 6 normal 17 8 4595 2007-07 ASIA 0
2 Acura RDX Midsized sport-utility vehicles $37,165 240 2.3 4 turbo 18 7.4 4015 2007-01 ASIA 1
3 Acura RL Luxury sedans $49,670 300 3.5 6 normal 18 6.9 4035 2005-09 ASIA 0
4 Acura TL Upscale sedans $33,150 270 3.2 6 normal 23 6.7 3565 2004-02 ASIA 0
5 Acura TSX Upscale sedans $29,035 200 2.4 4 normal 23 9.2 3315 2004-11 ASIA 0
6 Audi A3 Wagons and hatchbacks $27,390 200 2 4 turbo 25 7.3 3305 2006-09 EUROPE 1
7 Audi A4 Upscale sedans $36,455 200 2 4 turbo 23 8.3 3750 2006-05 EUROPE 1
8 Audi A6 Luxury sedans $50,820 255 3.2 6 normal 21 7.7 4115 2005-09 EUROPE 0
9 Audi A8 Luxury sedans $74,640 330 4.2 8 normal 17 7.6 4505 2003-11 EUROPE 0
10 Audi Q7 Midsized sport-utility vehicles $57,920 350 4.2 8 normal 15 8.2 5465 2006-11 EUROPE 0
11 Audi S4 Ultra performance/luxury sports cars $45,260 340 4.2 8 normal 20 5.3 3920 2004-09 EUROPE 0
12 BMW 3 Series sedan 328i 6-cyl Upscale sedans $39,175 230 3 6 normal 23 6.9 3485 2008-03 EUROPE 0
13 BMW 3 Series wagon 325xi 6-cyl Wagons and hatchbacks $40,520 215 3 6 normal 22 9.2 3775 2006-11 EUROPE 0
14 BMW 5 Series Luxury sedans $55,520 300 3 6 turbo 22 5.8 3785 2007-11 EUROPE 1
15 BMW 6 Series Ultra performance/luxury sports cars $77,440 360 4.8 8 normal 19 5.6 3885 2006-10 EUROPE 0
16 BMW 7 Series Luxury sedans $81,545 325 4.4 8 normal 18 6.9 4505 2003-11 EUROPE 0
17 BMW X3 Midsized sport-utility vehicles $43,120 260 3 6 normal 19 7.9 4065 2007-01 EUROPE 0
18 BMW X5 Midsized sport-utility vehicles $56,745 260 3 6 normal 17 8.6 5025 2007-07 EUROPE 0
19 BMW Z4 Roadsters $46,070 225 3 6 normal 26 6 3170 2005-10 EUROPE 0
20 Buick Enclave Large sport-utility vehicles $39,240 275 3.6 6 normal 15 8.9 5100 2008-01 USA 0
21 Buick LaCrosse Family sedans $31,450 200 3.8 6 normal 18 9 3565 2005-03 USA 0
22 Buick Lucerne CXL V6 Large sedans $30,680 197 3.8 6 normal 19 9.2 3845 2006-08 USA 0
23 Buick Lucerne CXS V8 Large sedans $38,935 275 4.6 8 normal 17 7.5 4095 2007-06 USA 0
24 Cadillac CTS Upscale sedans $40,835 263 3.6 6 normal 19 6.8 3940 2008-03 USA 0
25 Cadillac DTS Luxury sedans $48,050 275 4.6 8 normal 17 7.6 4085 2008-03 USA 0
26 Cadillac Escalade Large sport-utility vehicles $64,905 403 6.2 8 normal 13 7.5 5810 2006-11 USA 0
27 Cadillac SRX V6 Midsized sport-utility vehicles $48,240 255 3.6 6 normal 16 8.3 4730 2007-07 USA 0
28 Cadillac SRX V8 Midsized sport-utility vehicles $50,190 320 4.6 8 normal 16 6.4 4685 2004-03 USA 0
29 Cadillac STS Luxury sedans $50,325 302 3.6 6 normal 18 6.4 4000 2008-03 USA 0
30 Cadillac XLR Ultra performance/luxury sports cars $77,295 320 4.6 8 normal 17 6.4 3680 2006-10 USA 0
31 Chevrolet Avalanche Full-sized pickup trucks $46,560 310 5.3 8 normal 13 10.1 6010 2007-02 USA 0
32 Chevrolet Aveo hatchback LS 4-cyl Budget cars (Automatic transmission) $14,435 103 1.6 4 normal 28 11.7 2530 2004-08 USA 0
33 Chevrolet Aveo hatchback LS 4-cyl MT Budget cars (Manual transmission) $13,585 103 1.6 4 normal 27 11.2 2515 2004-08 USA 0
34 Chevrolet Cobalt Small cars (Automatic transmission) $17,350 145 2.2 4 normal 23 8.8 2850 2005-05 USA 0
35 Chevrolet Colorado Compact pickup trucks $30,300 220 3.5 5 normal 16 9.6 4270 2005-07 USA 0
36 Chevrolet Corvette convertible Base V8 MT Roadsters $57,520 400 6 8 normal 21 5 3280 2005-10 USA 0
37 Chevrolet Corvette hatchback Z06 V8 MT Ultra performance/luxury sports cars $73,945 505 7 8 normal 19 4.3 3195 2006-10 USA 0
38 Chevrolet Equinox Small sport-utility vehicles $27,740 185 3.4 6 normal 18 9.1 3880 2007-02 USA 0
39 Chevrolet HHR Wagons and hatchbacks $22,055 172 2.4 4 normal 23 9.2 3265 2006-01 USA 0
40 Chevrolet Impala Family sedans $26,840 242 3.9 6 normal 20 7.8 3710 2006-03 USA 0
41 Chevrolet Malibu LT 4-cyl Family sedans $21,620 169 2.4 4 normal 23 9.5 3460 2008-03 USA 0
42 Chevrolet Malibu Maxx Wagons and hatchbacks $22,456 217 3.5 6 normal 21 8.2 3535 2005-02 USA 0
43 Chevrolet Malibu LTZ V6 Family sedans $28,045 252 3.6 6 normal 20 6.5 3600 2008-03 USA 0
44 Chevrolet Monte Carlo Sporty cars $30,300 303 5.3 8 normal 17 6.3 3625 2006-03 USA 0
45 Chevrolet Silverado 1500 Full-sized pickup trucks $22,456 315 5.3 8 normal 14 8.5 5435 2007-09 USA 0
46 Chevrolet Silverado 2500HD Full-sized pickup trucks $43,209 365 6.6 8 turbodiesel 13 8.4 6920 2007-09 USA 1
47 Chevrolet Suburban Large sport-utility vehicles $51,940 320 5.3 8 normal 14 9.1 5935 2007-08 USA 0
48 Chevrolet Tahoe Large sport-utility vehicles $42,849 320 5.3 8 normal 14 9 5715 2006-07 USA 0
49 Chevrolet TrailBlazer Midsized sport-utility vehicles $35,625 291 4.2 6 normal 15 9.1 4830 2006-07 USA 0
50 Chevrolet Uplander Minivans $31,044 240 3.9 6 normal 18 8.8 4420 2007-05 USA 0
51 Chrysler 300 Touring V6 Large sedans $30,255 250 3.5 6 normal 19 8.1 3850 2005-01 USA 0
52 Chrysler 300 C V8 Large sedans $37,480 340 5.7 8 normal 16 6.4 4105 2005-01 USA 0
53 Chrysler Aspen Large sport-utility vehicles $32,456 303 4.7 8 normal 12 7.6 5320 2004-03 USA 0
54 Chrysler Crossfire Sporty cars $34,495 215 3.2 6 normal 22 7.2 3075 2003-12 USA 0
55 Chrysler PT Cruiser Wagons and hatchbacks $23,485 180 2.4 4 turbo 20 8.1 3350 2006-01 USA 1
56 Chrysler Pacifica Midsized sport-utility vehicles $33,515 253 4 6 normal 16 8.6 4720 2007-08 USA 0
57 Chrysler Sebring sedan Touring 4-cyl Family sedans $20,870 173 2.4 4 normal 23 10.2 3335 2007-03 USA 0
58 Chrysler Sebring sedan Touring V6 Family sedans $25,465 189 2.7 6 normal 21 8.9 3480 2007-03 USA 0
59 Chrysler Town & Country Minivans $38,390 251 4 6 normal 17 8.8 4755 2008-01 USA 0
60 Dodge Avenger Family sedans $27,350 235 3.5 6 normal 20 7.7 3550 2008-02 USA 0
61 Dodge Caliber R/T 4-cyl CVT Wagons and hatchbacks $23,860 172 2.4 4 normal 22 10.3 3405 2006-09 USA 0
62 Dodge Caliber SXT 4-cyl CVT Wagons and hatchbacks $19,015 158 2 4 normal 24 10.5 3185 2006-09 USA 0
63 Dodge Charger SXT V6 Large sedans $28,860 250 3.5 6 normal 19 8.2 3895 2006-03 USA 0
64 Dodge Charger R/T V8 Large sedans $36,295 340 5.7 8 normal 17 6 4170 2006-03 USA 0
65 Dodge Dakota Compact pickup trucks $29,970 230 4.7 8 normal 14 9 4790 2005-07 USA 0
66 Dodge Durango Large sport-utility vehicles $39,020 335 5.7 8 normal 12 7.6 5150 2004-03 USA 0
67 Dodge Grand Caravan Minivans $33,950 197 3.8 6 normal 16 10.3 4600 2008-01 USA 0
68 Dodge Magnum Wagons and hatchbacks $29,275 250 3.5 6 normal 19 8.8 3950 2004-12 USA 0
69 Dodge Nitro Small sport-utility vehicles $28,875 210 3.7 6 normal 16 9.1 4340 2007-05 USA 0
70 Dodge Ram 1500 Full-sized pickup trucks $38,370 345 5.7 8 normal 13 7.9 5655 2007-09 USA 0
71 Dodge Ram 2500 Full-sized pickup trucks $50,070 350 6.7 6 turbodiesel 13 9.1 7130 2007-09 USA 1
72 Dodge Viper Ultra performance/luxury sports cars $91,990 510 8.3 10 normal 15 4.2 3480 2006-10 USA 0
73 Ford Crown Victoria Large sedans $45,672 239 4.6 8 normal 16 8 4180 2003-02 USA 0
74 Ford Edge Midsized sport-utility vehicles $33,590 265 3.5 6 normal 16 8.3 4540 2007-08 USA 0
75 Ford Escape Small sport-utility vehicles $26,525 200 3 6 normal 19 10.5 3605 2007-12 USA 0
76 Ford Expedition Large sport-utility vehicles $48,730 300 5.4 8 normal 13 9.1 6325 2007-08 USA 0
77 Ford Explorer Sport Trac Compact pickup trucks $30,395 210 4 6 normal 14 10.6 4985 2007-02 USA 0
78 Ford Explorer XLT V6 Midsized sport-utility vehicles $35,520 210 4 6 normal 15 9.7 4905 2006-07 USA 0
79 Ford Explorer Eddie Bauer V8 Midsized sport-utility vehicles $39,025 292 4.6 8 normal 14 8.3 5055 2006-07 USA 0
80 Ford F-150 Full-sized pickup trucks $36,705 300 5.4 8 normal 13 8.8 5620 2007-09 USA 0
81 Ford F-250 Full-sized pickup trucks $50,735 350 6.4 8 turbodiesel 10 9.8 8025 2007-09 USA 1
82 Ford Freestar Minivans $33,480 201 4.2 6 normal 17 9.2 4425 2004-03 USA 0
83 Ford Fusion Base 4-cyl Family sedans $45,673 160 2.3 4 normal 23 9.5 3320 2006-03 USA 0
84 Ford Fusion SEL V6 Family sedans $26,025 221 3 6 normal 20 8 3480 2006-03 USA 0
85 Ford Mustang convertible Premium V6 Convertibles $28,070 210 4 6 normal 20 7.5 3590 2005-06 USA 0
86 Ford Mustang coupe GT Premium V8 MT Sporty cars $29,020 300 4.6 8 normal 20 5.5 3585 2005-04 USA 0
87 Ford Taurus Large sedans $28,985 263 3.5 6 normal 18 7.9 3900 2008-02 USA 0
88 Ford Taurus X Midsized sport-utility vehicles $36,105 263 3.5 6 normal 16 8.5 4420 2008-01 USA 0
89 GMC Acadia Large sport-utility vehicles $45,673 275 3.6 6 normal 16 8.8 5015 2007-08 USA 0
90 GMC Canyon Compact pickup trucks $45,673 242 3.7 5 normal 16 9.6 4270 2005-07 USA 0
91 GMC Envoy Midsized sport-utility vehicles $45,673 285 4.2 6 normal 15 9.1 4830 2006-07 USA 0
92 GMC Sierra 1500 Full-sized pickup trucks $45,673 315 5.3 8 normal 14 8.5 5435 2007-09 USA 0
93 GMC Sierra 2500HD Full-sized pickup trucks $45,673 365 6.6 6 turbodiesel 13 8.4 6920 2007-09 USA 1
94 GMC Yukon Large sport-utility vehicles $45,673 320 5.3 8 normal 14 9 5715 2006-07 USA 0
95 GMC Yukon XL Large sport-utility vehicles $45,673 320 5.3 8 normal 14 9.1 5935 2007-08 USA 0
96 Honda Accord sedan LX-P 4-cyl Family sedans $22,795 177 2.4 4 normal 23 9.8 3270 2008-02 ASIA 0
97 Honda Accord sedan EX-L V6 Family sedans $28,695 268 3.5 6 normal 21 7.4 3570 2008-02 ASIA 0
98 Honda CR-V Small sport-utility vehicles $24,645 166 2.4 4 normal 21 10.6 3505 2007-02 ASIA 0
99 Honda Civic sedan EX 4-cyl Small cars (Automatic transmission) $19,610 140 1.8 4 normal 28 10.1 2810 2006-02 ASIA 0
100 Honda Civic sedan Hybrid 4-cyl CVT Small cars (Automatic transmission) $22,400 110 1.3 4 hybrid 37 11.7 2890 2006-02 ASIA 1
101 Honda Civic sedan EX 4-cyl MT Small cars (Manual transmission) $18,810 140 1.8 4 normal 31 8.6 2740 2006-02 ASIA 0
102 Honda Civic coupe Si 4-cyl MT Sporty cars $20,540 197 2 4 normal 27 7 2885 2006-06 ASIA 0
103 Honda Element Small sport-utility vehicles $23,705 166 2.4 4 normal 21 10.4 3650 2007-02 ASIA 0
104 Honda Fit Base 4-cyl Budget cars (Automatic transmission) $15,245 109 1.5 4 normal 32 12.4 2535 2006-12 ASIA 0
105 Honda Fit Sport 4-cyl MT Budget cars (Manual transmission) $15,765 109 1.5 4 normal 34 9.9 2495 2006-12 ASIA 0
106 Honda Odyssey Minivans $32,410 255 3.5 6 normal 19 8.6 4615 2005-03 ASIA 0
107 Honda Pilot Midsized sport-utility vehicles $34,635 255 3.5 6 normal 17 8.2 4535 2005-04 ASIA 0
108 Honda Ridgeline Compact pickup trucks $30,590 247 3.5 6 normal 15 8.6 4540 2005-07 ASIA 0
109 Honda S2000 Roadsters $33,665 240 2.2 4 normal 25 5.8 2855 2005-10 ASIA 0
110 Hummer H3 Midsized sport-utility vehicles $36,915 220 3.5 5 normal 14 11.5 4940 2005-11 USA 0
111 Hyundai Accent hatchback GS 4-cyl MT Budget cars (Manual transmission) $12,745 110 1.6 4 normal 30 9.5 2595 2006-12 ASIA 0
112 Hyundai Accent GLS 4-cyl Budget cars (Automatic transmission) $14,230 110 1.6 4 normal 28 12.5 2590 2006-12 ASIA 0
113 Hyundai Azera Large sedans $30,075 263 3.8 6 normal 19 7.1 3835 2006-08 ASIA 0
114 Hyundai Elantra Small cars (Automatic transmission) $17,555 138 2 4 normal 27 10.4 2945 2007-10 ASIA 0
115 Hyundai Entourage Minivans $45,673 250 3.8 6 normal 17 9 4725 2006-09 ASIA 0
116 Hyundai Santa Fe Small sport-utility vehicles $30,745 242 3.3 6 normal 18 8.5 4345 2007-05 ASIA 0
117 Hyundai Sonata GLS 4-cyl Family sedans $21,345 162 2.4 4 normal 23 10.5 3380 2006-03 ASIA 0
118 Hyundai Sonata GLS V6 Family sedans $22,995 235 3.3 6 normal 21 7.5 3605 2006-03 ASIA 0
119 Hyundai Tucson Small sport-utility vehicles $22,154 173 2.7 6 normal 18 10.1 3800 2005-08 ASIA 0
120 Hyundai Veracruz Midsized sport-utility vehicles $33,870 260 3.8 6 normal 17 8.6 4610 2007-08 ASIA 0
121 Infiniti FX Midsized sport-utility vehicles $39,215 280 3.5 6 normal 18 7.4 4295 2003-09 ASIA 0
122 Infiniti G sedan X V6 Upscale sedans $39,400 306 3.5 6 normal 18 5.6 3820 2007-06 ASIA 0
123 Infiniti G sedan Journey V6 Upscale sedans $35,140 306 3.5 6 normal 19 5.4 3635 2007-06 ASIA 0
124 Infiniti M M35 X V6 Luxury sedans $50,240 280 3.5 6 normal 18 7 4095 2005-09 ASIA 0
125 Infiniti M M35 V6 Luxury sedans $47,650 275 3.5 6 normal 19 6.9 3890 2007-11 ASIA 0
126 Jaguar S-Type Luxury sedans $52,770 294 4.2 8 normal 19 6.3 3880 2004-06 EUROPE 0
127 Jaguar XJ Luxury sedans $71,545 294 4.2 8 normal 19 7.1 3860 2003-11 EUROPE 0
128 Jaguar XK Ultra performance/luxury sports cars $85,635 300 4.2 8 normal 19 7 3890 2006-10 EUROPE 0
129 Jeep Commander Midsized sport-utility vehicles $42,325 330 5.7 8 normal 13 7.3 5245 2006-07 USA 0
130 Jeep Compass Small sport-utility vehicles $21,660 172 2.4 4 normal 22 10.1 3380 2007-02 USA 0
131 Jeep Grand Cherokee Midsized sport-utility vehicles $35,300 235 4.7 8 normal 14 8.8 4690 2005-11 USA 0
132 Jeep Patriot Small sport-utility vehicles $26,045 172 2.4 4 normal 20 10.8 3575 2007-12 USA 0
133 Jeep Wrangler Small sport-utility vehicles $30,735 205 3.8 6 normal 15 10.7 4550 2007-01 USA 0
134 Kia Amanti Large sedans $30,130 264 3.8 6 normal 18 7.3 3870 2008-02 ASIA 0
135 Kia Optima EX 4-cyl Family sedans $22,795 162 2.4 4 normal 23 9.2 3345 2007-03 ASIA 0
136 Kia Optima EX V6 Family sedans $23,900 185 2.7 6 normal 21 8.6 3430 2007-03 ASIA 0
137 Kia Rio hatchback Rio5 SX 4-cyl MT Budget cars (Manual transmission) $14,110 110 1.6 4 normal 30 10 2555 2006-12 ASIA 0
138 Kia Rio sedan LX 4-cyl Budget cars (Automatic transmission) $14,905 110 1.6 4 normal 28 12.8 2615 2006-12 ASIA 0
139 Kia Rondo Wagons and hatchbacks $20,655 182 2.7 6 normal 21 9.6 3660 2007-12 ASIA 0
140 Kia Sedona Minivans $31,365 244 3.8 6 normal 17 9 4725 2006-09 ASIA 0
141 Kia Sorento Small sport-utility vehicles $24,035 192 3.5 6 normal 15 9.5 4500 2004-06 ASIA 0
142 Kia Spectra EX 4-cyl Small cars (Automatic transmission) $15,905 138 2 4 normal 25 11.4 2875 2004-08 ASIA 0
143 Kia Spectra EX 4-cyl MT Small cars (Manual transmission) $14,930 138 2 4 normal 28 9.5 2815 2004-08 ASIA 0
144 Kia Sportage Small sport-utility vehicles $23,565 173 2.7 6 normal 18 11.3 3750 2007-12 ASIA 0
145 Land Rover LR3 Midsized sport-utility vehicles $50,150 300 4.4 8 normal 13 9.1 5705 2005-11 EUROPE 0
146 Lexus ES Upscale sedans $41,289 272 3.5 6 normal 23 6.4 3670 2007-06 ASIA 0
147 Lexus GS 300 V6 Luxury sedans $51,859 245 3 6 normal 20 7.4 3915 2005-09 ASIA 0
148 Lexus GS 450h V6 CVT Luxury sedans $60,172 340 3.5 6 hybrid 23 5.9 4205 2007-11 ASIA 1
149 Lexus GX Midsized sport-utility vehicles $48,563 235 4.7 8 normal 15 8 4825 2004-03 ASIA 0
150 Lexus IS Upscale sedans $33,734 204 2.5 6 normal 24 7.7 3510 2006-05 ASIA 0
151 Lexus LS Luxury sedans $76,572 380 4.6 8 normal 21 6.2 4515 2007-11 ASIA 0
152 Lexus RX 350 V6 Midsized sport-utility vehicles $45,706 270 3.5 6 normal 19 7.3 4235 2007-07 ASIA 0
153 Lexus RX 400h V6 CVT Midsized sport-utility vehicles $49,883 268 3.3 6 hybrid 23 7.4 4540 2005-11 ASIA 1
154 Lexus SC Ultra performance/luxury sports cars $67,084 288 4.3 8 normal 21 6.5 3870 2006-10 ASIA 0
155 Lincoln MKX Midsized sport-utility vehicles $43,595 265 3.5 6 normal 16 8.2 4620 2007-07 USA 0
156 Lincoln MKZ Upscale sedans $32,675 263 3.5 6 normal 20 6.9 3625 2007-06 USA 0
157 Lincoln Navigator Large sport-utility vehicles $59,015 300 5.4 8 normal 13 8.8 6245 2007-07 USA 0
158 Lincoln Town Car Luxury sedans $45,025 239 4.6 8 normal 17 8.7 4415 2003-02 USA 0
159 Lotus Elise Roadsters $45,545 190 1.8 4 normal 29 4.6 2000 2005-10 EUROPE 0
160 Mazda CX-7 Midsized sport-utility vehicles $32,915 244 2.3 4 turbo 18 9.1 4025 2007-01 ASIA 1
161 Mazda CX-9 Midsized sport-utility vehicles $35,372 263 3.5 6 normal 16 8.7 4600 2007-08 ASIA 0
162 Mazda MX-5 Miata Roadsters $27,095 170 2 4 normal 27 6.7 2510 2006-06 ASIA 0
163 Mazda RX-8 Sporty cars $31,100 238 1.3 rotary 18 6.7 3085 2003-12 ASIA 1
164 Mazda Tribute Small sport-utility vehicles $45,673 200 3 6 normal 19 10.5 3605 2007-12 ASIA 0
165 Mazda Mazda3 sedan i 4-cyl Small cars (Automatic transmission) $17,940 148 2 4 normal 27 9.6 2815 2004-08 ASIA 0
166 Mazda Mazda3 hatchback s Grand Touring 4-cyl Wagons and hatchbacks $22,095 160 2.3 4 normal 25 9.5 3060 2006-09 ASIA 0
167 Mazda Mazda3 sedan i 4-cyl MT Small cars (Manual transmission) $17,960 148 2 4 normal 30 8.6 2830 2004-08 ASIA 0
168 Mazda Mazda3 hatchback Mazdaspeed GrTr 4cyl Sporty cars $25,195 263 2.3 4 turbo 24 6.8 3205 2007-10 ASIA 1
169 Mazda Mazda5 Wagons and hatchbacks $22,615 157 2.3 4 normal 23 10.3 3480 2006-01 ASIA 0
170 Mazda Mazda6 sedan i 4-cyl Family sedans $21,650 160 2.3 4 normal 23 9.6 3150 2003-05 ASIA 0
171 Mazda Mazda6 sedan s V6 Family sedans $25,925 220 3 6 normal 20 8.1 3355 2003-05 ASIA 0
172 Mercedes-Benz B-Class Wagons and hatchbacks $34,339 134 2 4 normal 26 9.8 3130 2007-10 EUROPE 0
173 Mercedes-Benz C-Class Upscale sedans $37,325 228 3 6 normal 21 6.8 3565 2008-03 EUROPE 0
174 Mercedes-Benz CLS Luxury sedans $76,784 302 5 8 normal 18 6.1 4060 2006-10 EUROPE 0
175 Mercedes-Benz E-Class sedan E320 BLUETEC V6 Luxury sedans $55,415 208 3 6 turbodiesel 29 8 4005 2007-11 EUROPE 1
176 Mercedes-Benz E-Class sedan E350 V6 Luxury sedans $54,415 268 3.5 6 normal 21 6.5 3845 2007-11 EUROPE 0
177 Mercedes-Benz GL-Class Large sport-utility vehicles $67,820 335 4.6 8 normal 15 7.4 5575 2006-11 EUROPE 0
178 Mercedes-Benz M-Class Midsized sport-utility vehicles $48,880 268 3.5 6 normal 16 7.8 4845 2005-11 EUROPE 0
179 Mercedes-Benz S-Class Luxury sedans $90,200 382 5.5 8 normal 17 6 4490 2007-11 EUROPE 0
180 Mercedes-Benz SL Ultra performance/luxury sports cars $105,855 382 5.5 8 normal 17 5.3 4235 2006-10 EUROPE 0
181 Mercedes-Benz SLK Roadsters $53,950 268 3.5 6 normal 21 6.2 3315 2005-10 EUROPE 0
182 Mercury Grand Marquis Large sedans $30,130 239 4.6 8 normal 16 8 4180 2003-02 USA 0
183 Mercury Mariner Small sport-utility vehicles $45,673 200 3 6 normal 19 10.5 3605 2007-12 USA 0
184 Mercury Milan Base 4-cyl Family sedans $20,415 160 2.3 4 normal 23 9.5 3320 2006-03 USA 0
185 Mercury Milan SEL V6 Family sedans $45,673 221 3 6 normal 20 8 3480 2006-03 USA 0
186 Mercury Monterey Minivans $45,673 201 4.2 6 normal 17 9.2 4425 2004-03 USA 0
187 Mercury Mountaineer XLT V6 Midsized sport-utility vehicles $45,673 210 4 6 normal 15 9.7 4905 2006-07 USA 0
188 Mercury Mountaineer Eddie Bauer V8 Midsized sport-utility vehicles $45,673 292 4.6 8 normal 14 8.3 5055 2006-07 USA 0
189 Mercury Sable Large sedans $45,673 263 3.5 6 normal 18 7.9 3900 2008-02 USA 0
190 Mini Cooper Sporty cars $26,400 172 1.6 4 turbo 30 7.2 2690 2007-10 EUROPE 1
191 Mitsubishi Eclipse Sporty cars $21,764 162 2.4 4 normal 23 9.3 3345 2005-12 ASIA 0
192 Mitsubishi Endeavor Midsized sport-utility vehicles $30,792 215 3.8 6 normal 17 8.2 4195 2003-08 ASIA 0
193 Mitsubishi Galant ES 4-cyl Family sedans $20,342 160 2.4 4 normal 23 9.1 3430 2004-05 ASIA 0
194 Mitsubishi Galant GTS V6 Family sedans $27,094 230 3.8 6 normal 20 7.2 3715 2005-02 ASIA 0
195 Mitsubishi Lancer Small cars (Automatic transmission) $17,515 152 2 4 normal 25 9.8 3015 2007-10 ASIA 0
196 Mitsubishi Outlander Small sport-utility vehicles $30,615 220 3 6 normal 19 8.3 3925 2007-05 ASIA 0
197 Nissan 350Z Roadsters $42,800 287 3.5 6 normal 20 6.2 3640 2005-10 ASIA 0
198 Nissan Altima sedan 2.5 S 4-cyl CVT Family sedans $22,705 175 2.5 4 normal 25 8.1 3215 2007-03 ASIA 0
199 Nissan Altima sedan Hybrid 4-cyl CVT Family sedans $28,225 198 2.5 4 hybrid 32 7.6 3525 2008-03 ASIA 1
200 Nissan Altima sedan 3.5 SE V6 CVT Family sedans $31,995 270 3.5 6 normal 23 6.4 3435 2007-03 ASIA 0
201 Nissan Armada Large sport-utility vehicles $42,170 317 5.6 8 normal 13 7.2 5715 2004-03 ASIA 0
202 Nissan Frontier Compact pickup trucks $30,010 261 4 6 normal 15 7.9 4655 2005-07 ASIA 0
203 Nissan Maxima Upscale sedans $33,715 255 3.5 6 normal 21 6.8 3590 2007-06 ASIA 0
204 Nissan Murano Midsized sport-utility vehicles $36,240 245 3.5 6 normal 19 8 4090 2005-04 ASIA 0
205 Nissan Pathfinder Midsized sport-utility vehicles $36,160 270 4 6 normal 15 8 4875 2005-11 ASIA 0
206 Nissan Quest Minivans $37,565 235 3.5 6 normal 18 8.4 4550 2007-05 ASIA 0
207 Nissan Sentra Small cars (Automatic transmission) $18,855 140 2 4 normal 26 9.6 3010 2007-10 ASIA 0
208 Nissan Titan Full-sized pickup trucks $33,540 317 5.6 8 normal 13 7.3 5380 2004-07 ASIA 0
209 Nissan Versa hatchback 1.8 S 4-cyl MT Budget cars (Manual transmission) $14,015 122 1.8 4 normal 29 9.5 2780 2006-12 ASIA 0
210 Nissan Versa hatchback 1.8 SL 4-cyl CVT Budget cars (Automatic transmission) $16,675 122 1.8 4 normal 28 10.1 2805 2006-12 ASIA 0
211 Nissan Xterra Small sport-utility vehicles $27,900 261 4 6 normal 17 7.7 4480 2005-08 ASIA 0
212 Pontiac G6 sedan Base 4-cyl Family sedans $20,785 169 2.4 4 normal 22 9.4 3365 2007-03 USA 0
213 Pontiac G6 sedan GT V6 Family sedans $25,989 224 3.5 6 normal 20 7.7 3540 2007-03 USA 0
214 Pontiac Grand Prix Family sedans $26,225 200 3.8 6 normal 20 8.3 3630 2004-01 USA 0
215 Pontiac Solstice Roadsters $25,895 177 2.4 4 normal 23 7.2 2925 2006-06 USA 0
216 Pontiac Torrent Small sport-utility vehicles $45,673 185 3.4 6 normal 18 9.1 3880 2007-02 USA 0
217 Pontiac Vibe Wagons and hatchbacks $19,960 126 1.8 4 normal 27 10.7 2840 2006-01 USA 0
218 Porsche 911 Ultra performance/luxury sports cars $87,520 355 3.8 6 normal 20 4.4 3305 2006-10 EUROPE 0
219 Porsche Boxster Roadsters $49,075 240 2.7 6 normal 22 6.5 3015 2005-10 EUROPE 0
220 Saab 9-3 sedan 2.0T 4-cyl Upscale sedans $31,615 210 2 4 turbo 23 8 3370 2006-05 EUROPE 1
221 Saab 9-3 sedan Aero V6 Upscale sedans $37,815 255 2.8 6 turbo 20 6.4 3570 2008-03 EUROPE 1
222 Saab 9-5 Upscale sedans $38,310 260 2.3 4 turbo 21 7.2 3545 2007-06 EUROPE 1
223 Saturn Aura XE V6 Family sedans $21,070 224 3.5 6 normal 20 8.1 3570 2007-03 USA 0
224 Saturn Aura XR V6 Family sedans $26,820 252 3.6 6 normal 20 6.6 3670 2007-03 USA 0
225 Saturn Ion Small cars (Automatic transmission) $18,415 140 2.2 4 normal 25 9.2 2865 2005-05 USA 0
226 Saturn Outlook Large sport-utility vehicles $36,799 275 3.6 6 normal 16 8.8 5015 2007-08 USA 0
227 Saturn Relay Minivans $45,673 240 3.9 6 normal 18 8.8 4420 2007-05 USA 0
228 Saturn Sky Roadsters $30,289 260 2 4 turbo 24 6.2 3065 2007-10 USA 1
229 Saturn Vue Small sport-utility vehicles $27,970 257 3.6 6 normal 17 8.2 3915 2007-12 USA 0
230 Scion tC 4-cyl MT Sporty cars $17,365 160 2.4 4 normal 26 8.8 2890 2005-12 ASIA 0
231 Scion tC TRD 4-cyl MT Sporty cars $20,665 200 2.4 4 turbo 26 7.2 2960 2006-06 ASIA 1
232 Scion xB Wagons and hatchbacks $18,360 158 2.4 4 normal 23 9.4 3120 2007-10 ASIA 0
233 Subaru Forester 2.5 X 4-cyl Small sport-utility vehicles $23,220 173 2.5 4 normal 22 10 3260 2006-07 ASIA 0
234 Subaru Forester Sports 2.5 XT 4-cyl Small sport-utility vehicles $27,662 224 2.5 4 turbo 20 7.4 3365 2007-05 ASIA 1
235 Subaru Legacy 2.5i Special Edition 4-cyl Family sedans $22,835 170 2.5 4 normal 23 10.8 3340 2008-02 ASIA 0
236 Subaru Legacy sedan 2.5 GT Limited 4-cyl Family sedans $30,797 250 2.5 4 turbo 18 7.5 3540 2004-11 ASIA 1
237 Subaru Outback wagon 2.5i 4-cyl Wagons and hatchbacks $28,790 168 2.5 4 normal 21 11.8 3545 2004-12 ASIA 0
238 Subaru Outback wagon 3.0 R VDC Limited 6-cyl Wagons and hatchbacks $36,538 250 3 6 normal 19 8.8 3705 2006-11 ASIA 0
239 Subaru Tribeca Midsized sport-utility vehicles $34,720 256 3.6 6 normal 16 8.6 4280 2008-01 ASIA 0
240 Suzuki Forenza S 4-cyl Small cars (Automatic transmission) $14,499 126 2 4 normal 24 11.3 2840 2004-08 ASIA 0
241 Suzuki Forenza S 4-cyl MT Small cars (Manual transmission) $13,699 126 2 4 normal 27 9.5 2815 2004-08 ASIA 0
242 Suzuki Grand Vitara Small sport-utility vehicles $22,894 185 2.7 6 normal 18 9.5 3650 2006-07 ASIA 0
243 Suzuki SX4 Wagons and hatchbacks $17,994 143 2 4 normal 22 12.2 2995 2007-12 ASIA 0
244 Suzuki XL-7 Small sport-utility vehicles $29,284 252 3.6 6 normal 17 7.7 4190 2007-05 ASIA 0
245 Toyota 4Runner Midsized sport-utility vehicles $32,418 239 4 6 normal 16 8.2 4345 2003-08 ASIA 0
246 Toyota Avalon Large sedans $33,070 280 3.5 6 normal 22 6.7 3600 2005-09 ASIA 0
247 Toyota Camry LE 4-cyl Family sedans $21,080 158 2.4 4 normal 24 9.6 3280 2006-08 ASIA 0
248 Toyota Camry Hybrid 4-cyl CVT Family sedans $30,667 187 2.4 4 hybrid 34 8.5 3650 2006-08 ASIA 1
249 Toyota Camry Solara Convertibles $31,147 225 3.3 6 normal 21 7.5 3620 2005-06 ASIA 0
250 Toyota Camry XLE V6 Family sedans $29,839 268 3.5 6 normal 23 7.1 3530 2006-08 ASIA 0
251 Toyota Corolla Small cars (Automatic transmission) $16,585 130 1.8 4 normal 29 9.8 2595 2002-07 ASIA 0
252 Toyota FJ Cruiser Small sport-utility vehicles $30,881 239 4 6 normal 17 8 4350 2007-01 ASIA 0
253 Toyota Highlander Hybrid Limited V6 CVT Midsized sport-utility vehicles $43,770 270 3.3 6 hybrid 24 8.2 4640 2008-03 ASIA 1
254 Toyota Highlander Limited V6 Midsized sport-utility vehicles $38,575 270 3.5 6 normal 18 8 4490 2008-01 ASIA 0
255 Toyota Matrix Wagons and hatchbacks $45,673 126 1.8 4 normal 27 10.7 2840 2006-01 ASIA 0
256 Toyota Prius Family sedans $22,052 110 1.5 4 hybrid 44 10.5 2950 2004-05 ASIA 1
257 Toyota RAV4 Base 4-cyl Small sport-utility vehicles $23,163 166 2.4 4 normal 23 9.8 3485 2006-07 ASIA 0
258 Toyota RAV4 Limited V6 Small sport-utility vehicles $30,328 269 3.5 6 normal 22 6.7 3750 2006-07 ASIA 0
259 Toyota Sienna XLE AWD V6 Minivans $38,088 266 3.5 6 normal 18 7.7 4550 2007-05 ASIA 0
260 Toyota Sienna XLE V6 Minivans $36,989 266 3.5 6 normal 19 7.8 4415 2007-05 ASIA 0
261 Toyota Tacoma Compact pickup trucks $29,210 239 4 6 normal 17 7.6 4115 2005-07 ASIA 0
262 Toyota Tundra Full-sized pickup trucks $34,738 381 5.7 8 normal 15 6.7 5740 2007-09 ASIA 0
263 Toyota Yaris hatchback Base 4-cyl MT Budget cars (Manual transmission) $12,569 106 1.5 4 normal 34 9.3 2370 2006-12 ASIA 0
264 Toyota Yaris sedan Base 4-cyl Budget cars (Automatic transmission) $15,543 106 1.5 4 normal 33 11.4 2430 2006-12 ASIA 0
265 Volkswagen GTI Sporty cars $23,975 200 2 4 turbo 25 6.7 3155 2006-06 EUROPE 1
266 Volkswagen Jetta Small cars (Automatic transmission) $23,580 150 2.5 5 normal 24 9.4 3330 2006-02 EUROPE 0
267 Volkswagen Passat sedan 2.0T 4-cyl Family sedans $27,440 200 2 4 turbo 24 7.7 3465 2006-03 EUROPE 1
268 Volkswagen Passat sedan 3.6 V6 Family sedans $33,315 280 3.6 6 normal 22 6.8 3615 2006-03 EUROPE 0
269 Volkswagen Passat wagon 3.6 V6 Wagons and hatchbacks $36,480 280 3.6 6 normal 20 7 3960 2006-11 EUROPE 0
270 Volvo S40 Family sedans $28,605 168 the 2.4 5 normal 23 9.4 3245 2004-11 EUROPE 0
271 Volvo S60 Upscale sedans $33,890 208 2.5 5 turbo 22 7.9 3465 2004-02 EUROPE 1
272 Volvo S80 Luxury sedans $45,305 235 3.2 6 normal 20 8.6 3850 2007-11 EUROPE 0
273 Volvo V50 Wagons and hatchbacks $45,673 227 2.5 5 turbo 20 8.5 3555 2004-12 EUROPE 1
274 Volvo V70/XC70 Wagons and hatchbacks $42,560