United States International University Challenge Yourself Excel Paper Challenge Yourself 8.4 In this project, you will use scenarios and a scenario summary

United States International University Challenge Yourself Excel Paper Challenge Yourself 8.4 In this project, you will use scenarios and a scenario summary to analyze car purchasing options. The data for this project were downloaded from: https://www.fueleconomy.gov/feg/download.shtml You will use custom filtering to find the data you are interested in and copy it from this very large data set to another worksheet. You will then use Advanced Filter, conditional formatting, sorting, and subtotals to further analyze this subset of data. You will manipulate a PivotTable created from the main vehicle data set. Finally, you will use Solver to solve a business problem New Car Loan
Sticker price
Trade in
Cash back offer
Loan amount
Loan Inputs
$
24,595
$
3,500
$
$
21,095
Loan term (months)
Loan interest (APR)
Loan payment
24
1.90%
896.46
$
Total cost of the car
$ 21,515.04
Student Name
Cyl
Trans
Drive
Fuel
Cert
Region
ACURA ILX
ACURA ILX
2.4
2.4
4 AMS-8
4 AMS-8
2WD
2WD
Gasoline
Gasoline
CA
FA
ACURA MDX
3.5
6 SemiAuto-9
2WD
Gasoline
CA
ACURA MDX
ACURA MDX
ACURA MDX
3.5
3.5
3.5
6 SemiAuto-9
6 SemiAuto-9
6 SemiAuto-9
2WD
2WD
2WD
Gasoline
Gasoline
Gasoline
CA
FA
FA
ACURA MDX
3.5
6 SemiAuto-9
4WD
Gasoline
CA
ACURA MDX
ACURA MDX
ACURA MDX
3.5
3.5
3.5
6 SemiAuto-9
6 SemiAuto-9
6 SemiAuto-9
4WD
4WD
4WD
Gasoline
Gasoline
Gasoline
CA
FA
FA
ACURA NSX
ACURA NSX
ACURA RDX
ACURA RDX
ACURA RDX
ACURA RDX
3.5
3.5
3.5
3.5
3.5
3.5
6
6
6
6
6
6
AMS-9
AMS-9
SemiAuto-6
SemiAuto-6
SemiAuto-6
SemiAuto-6
4WD
4WD
2WD
2WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
CA
FA
FA
CA
FA
CA
ACURA RLX
ACURA RLX
ACURA RLX
ACURA RLX
ACURA TLX
ACURA TLX
ACURA TLX
ACURA TLX
ACURA TLX
ACURA TLX
ALFA ROMEO 4C
ALFA ROMEO 4C
ALFA ROMEO Giulia
ALFA ROMEO Giulia
3.5
3.5
3.5
3.5
2.4
2.4
3.5
3.5
3.5
3.5
1.8
1.8
2
2
6
6
6
6
4
4
6
6
6
6
4
4
4
4
AMS-7
AMS-7
SemiAuto-6
SemiAuto-6
AMS-8
AMS-8
SemiAuto-9
SemiAuto-9
SemiAuto-9
SemiAuto-9
AutoMan-6
AutoMan-6
Auto-8
Auto-8
4WD
4WD
2WD
2WD
2WD
2WD
2WD
2WD
4WD
4WD
2WD
2WD
2WD
2WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
CA
FA
FA
CA
FA
CA
FA
CA
FA
CA
CA
FA
CA
FA
ALFA ROMEO Giulia
ALFA ROMEO Giulia
ALFA ROMEO Giulia AWD
2.9
2.9
2
6 Auto-8
6 Auto-8
4 Auto-8
2WD
2WD
4WD
Gasoline
Gasoline
Gasoline
CA
FA
CA
MPG Data
Stnd
L3ULEV
125
T3B125
L3ULEV
125
L3ULEV
125
T3B125
T3B125
L3ULEV
125
L3ULEV
125
T3B125
T3B125
L3ULEV
125
T3B125
T3B125
U2
T3B125
U2
L3SULE
V30
T3B30
T3B125
U2
T3B125
U2
T3B125
U2
T3B125
U2
L2
T3B160
T3B110
T3B110
L3ULEV
125
T3B125
T3B110
Veh Class
small car
small car
6
6
25
25
35
35
29
29
7 Yes
7 Yes
309
309
small SUV
6
19
27
22
5 No
404
small SUV
small SUV
small SUV
6
6
6
20
19
20
27
27
27
23
22
23
5 No
5 No
5 No
391
404
391
small SUV
6
18
26
21
4 No
424
small SUV
small SUV
small SUV
6
6
6
19
18
19
26
26
26
22
21
22
5 No
4 No
5 No
404
424
404
small car
small car
small SUV
small SUV
small SUV
small SUV
6
6
6
6
6
6
21
21
20
20
19
19
22
22
28
28
27
27
21
21
23
23
22
22
4
4
5
5
5
5
No
No
No
No
No
No
420
420
386
386
402
402
midsize car
midsize car
midsize car
midsize car
small car
small car
small car
small car
small car
small car
small car
small car
midsize car
midsize car
8
8
6
6
6
6
6
6
6
6
5
5
6
6
29
29
20
20
24
24
21
21
21
21
24
24
24
24
30
30
30
30
35
35
34
34
31
31
34
34
33
33
29
29
23
23
28
28
25
25
25
25
28
28
27
27
7
7
5
5
6
6
5
5
5
5
6
6
6
6
Yes
Yes
No
No
No
No
No
No
No
No
No
No
No
No
306
306
380
380
321
321
358
358
358
358
317
317
330
330
midsize car
midsize car
midsize car
6
6
6
17
17
23
24
24
31
20
20
26
4 No
4 No
6 No
451
451
348
City
MPG
Hwy
MPG
Cmb
MPG
SmartWay
Displ
Air Pollution
Score
Model
Greenhouse Gas
Score
All Models
Comb CO2
Student Name
ALFA ROMEO Giulia AWD
ASTON MARTIN Rapide S
ASTON MARTIN Rapide S
ASTON MARTIN V12 Vantage S
ASTON MARTIN V12 Vantage S
ASTON MARTIN V12 Vantage S
ASTON MARTIN V12 Vantage S
ASTON MARTIN Vanquish, S and Zagato
ASTON MARTIN Vanquish, S and Zagato
AUDI A3
AUDI A3
2
6
6
6
6
6
6
6
6
2
2
4
12
12
12
12
12
12
12
12
4
4
Auto-8
SemiAuto-8
SemiAuto-8
AutoMan-7
AutoMan-7
Man-7
Man-7
SemiAuto-8
SemiAuto-8
AMS-6
AMS-6
4WD
2WD
2WD
2WD
2WD
2WD
2WD
2WD
2WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
FA
FA
CA
FA
CA
FA
CA
FA
CA
CA
FA
AUDI A3
AUDI A3
AUDI A3 Cabriolet
AUDI A3 Cabriolet
2
2
2
2
4
4
4
4
AMS-7
AMS-7
AMS-6
AMS-6
2WD
2WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
CA
FA
CA
FA
AUDI A3 Cabriolet
AUDI A3 Cabriolet
2
2
4 AMS-7
4 AMS-7
2WD
2WD
Gasoline
Gasoline
CA
FA
AUDI A4
AUDI A4
2
2
4 AMS-7
4 AMS-7
2WD
2WD
Gasoline
Gasoline
CA
FA
AUDI A4
AUDI A4
2
2
4 AMS-7
4 AMS-7
4WD
4WD
Gasoline
Gasoline
CA
FA
AUDI A4
AUDI A4
2
2
4 Man-6
4 Man-6
4WD
4WD
Gasoline
Gasoline
CA
FA
AUDI A4 Ultra
AUDI A4 Ultra
2
2
4 AMS-7
4 AMS-7
2WD
2WD
Gasoline
Gasoline
CA
FA
AUDI A4 allroad quattro
AUDI A4 allroad quattro
AUDI A5
AUDI A5
2
2
2
2
4
4
4
4
AMS-7
AMS-7
Man-6
Man-6
4WD
4WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
CA
FA
FA
CA
AUDI A6
AUDI A6
2
2
4 AMS-7
4 AMS-7
2WD
2WD
Gasoline
Gasoline
CA
FA
AUDI A6
AUDI A6
AUDI A6
AUDI A6
AUDI A7
AUDI A7
AUDI A8 L
AUDI A8 L
2
2
3
3
3
3
3
3
4
4
6
6
6
6
6
6
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
CA
FA
FA
CA
FA
CA
FA
CA
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
MPG Data
T3B110
T3B125
U2
T3B125
U2
T3B125
U2
T3B125
U2
S2
T3B30
L3SULE
V30
T3B30
S2
T3B30
L3SULE
V30
T3B30
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
T3B125
U2
L3ULEV
70
T3B70
L3ULEV
70
T3B70
T3B125
U2
T3B125
U2
T3B125
U2
midsize car
small car
small car
small car
small car
small car
small car
small car
small car
small car
small car
6
6
6
6
6
6
6
6
6
9
8
23
14
14
12
12
10
10
13
13
24
24
31
21
21
18
18
16
16
21
21
31
31
26
17
17
14
14
12
12
16
16
27
27
6
3
3
1
1
1
1
2
2
6
6
No
No
No
No
No
No
No
No
No
No
No
348
533
533
624
624
724
724
555
555
330
330
small car
small car
small car
small car
8
8
9
8
26
26
22
22
35
35
30
30
29
29
25
25
7
7
5
5
Yes
Yes
No
No
303
303
359
359
small car
small car
8
8
25
25
34
34
28
28
6 No
6 No
316
316
small car
small car
6
6
25
25
33
33
28
28
6 No
6 No
315
315
small car
small car
6
6
24
24
31
31
27
27
6 No
6 No
330
330
small car
small car
6
6
24
24
33
33
27
27
6 No
6 No
329
329
small car
small car
6
6
27
27
37
37
31
31
7 Yes
7 Yes
284
284
station wagon
station wagon
small car
small car
6
6
6
6
23
23
23
23
28
28
32
32
25
25
26
26
5
5
6
6
No
No
No
No
349
349
338
338
midsize car
midsize car
7
7
24
24
34
34
28
28
6 No
6 No
317
317
midsize car
midsize car
midsize car
midsize car
midsize car
midsize car
large car
large car
7
7
6
6
6
6
6
6
22
22
21
21
21
21
19
19
31
31
29
29
29
29
29
29
25
25
24
24
24
24
22
22
5
5
5
5
5
5
5
5
353
353
376
376
376
376
397
397
No
No
No
No
No
No
No
No
Student Name
AUDI A8 L
AUDI A8 L
AUDI Q3
AUDI Q3
AUDI Q3
AUDI Q3
AUDI Q5
AUDI Q5
AUDI Q7
AUDI Q7
AUDI Q7
AUDI Q7
AUDI R8
AUDI R8
AUDI R8 Spyder
AUDI R8 Spyder
AUDI RS7
AUDI RS7
AUDI S3
AUDI S3
AUDI S5
AUDI S5
AUDI S5
AUDI S5
AUDI S5 Cabriolet
AUDI S5 Cabriolet
AUDI S6
AUDI S6
AUDI S7
AUDI S7
AUDI S8
AUDI S8
AUDI SQ5
AUDI SQ5
AUDI TT Coupe
AUDI TT Coupe
AUDI TT Roadster
AUDI TT Roadster
AUDI TTS Coupe
AUDI TTS Coupe
BENTLEY Bentayga
BENTLEY Bentayga
BENTLEY Continental GT
BENTLEY Continental GT
BENTLEY Continental GT
4
4
2
2
2
2
3
3
8
8
4
4
4
4
6
6
SemiAuto-8
SemiAuto-8
SemiAuto-6
SemiAuto-6
SemiAuto-6
SemiAuto-6
SemiAuto-8
SemiAuto-8
4WD
4WD
2WD
2WD
4WD
4WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
FA
CA
FA
CA
FA
CA
FA
CA
2
2
3
3
5.2
5.2
5.2
5.2
4
4
2
2
3
3
3
3
3
3
4
4
4
4
4
4
3
3
2
2
2
2
2
2
4
4
6
6
10
10
10
10
8
8
4
4
6
6
6
6
6
6
8
8
8
8
8
8
6
6
4
4
4
4
4
4
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
AMS-7
AMS-7
AMS-7
AMS-7
SemiAuto-8
SemiAuto-8
AMS-6
AMS-6
AMS-7
AMS-7
Man-6
Man-6
AMS-7
AMS-7
AMS-7
AMS-7
AMS-7
AMS-7
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
AMS-6
AMS-6
AMS-6
AMS-6
AMS-6
AMS-6
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
CA
FA
FA
CA
CA
FA
CA
FA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
CA
FA
CA
FA
FA
CA
6
6
4
4
6
12
12
8
8
12
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
4WD
4WD
4WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
CA
FA
FA
CA
CA
MPG Data
T3B125
U2
T3B125
U2
T3B125
U2
T3B125
U2
L3ULEV
125
T3B125
B5
U2
L2
T3B160
L2
T3B160
T3B125
U2
T3B125
U2
T3B125
U2
T3B125
U2
T3B125
U2
T3B125
U2
T3B125
U2
T3B125
U2
T3B125
U2
S2
T3B30
S2
T3B30
T3B125
U2
L3ULEV
125
T3B125
T3B125
U2
L2
large car
large car
small car
small car
small car
small car
small SUV
small SUV
6
6
6
6
6
6
6
6
18
18
20
20
20
20
18
18
29
29
28
28
28
28
26
26
22
22
23
23
23
23
21
21
5
5
5
5
5
5
4
4
No
No
No
No
No
No
No
No
410
410
391
391
387
387
429
429
standard SUV
standard SUV
standard SUV
standard SUV
small car
small car
small car
small car
midsize car
midsize car
small car
small car
small car
small car
small car
small car
small car
small car
midsize car
midsize car
midsize car
midsize car
midsize car
midsize car
small SUV
small SUV
small car
small car
small car
small car
small car
small car
6
6
5
6
5
5
5
5
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
9
8
9
8
6
6
20
20
19
19
14
14
14
14
15
15
21
21
18
18
17
17
18
18
18
18
17
17
15
15
17
17
23
23
23
23
23
23
25
25
25
25
22
22
22
22
25
25
28
28
28
28
26
26
26
26
27
27
27
27
24
24
24
24
30
30
30
30
27
27
22
22
21
21
17
17
17
17
18
18
24
24
21
21
20
20
21
21
21
21
21
21
18
18
19
19
26
26
26
26
25
25
5
5
4
4
3
3
3
3
3
3
5
5
4
4
4
4
4
4
4
4
4
4
3
3
4
4
6
6
6
6
5
5
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
406
406
419
419
519
519
519
519
497
497
373
373
413
413
439
439
428
428
423
423
427
427
501
501
458
458
336
336
336
336
358
358
standard SUV
standard SUV
small car
small car
small car
6
6
6
6
5
12
12
15
15
12
19
19
25
25
21
15
15
19
19
15
2
2
4
4
2
No
No
No
No
No
596
596
475
475
580
Student Name
BENTLEY Continental GT
BENTLEY Continental GT Convertible
BENTLEY Continental GT Convertible
BENTLEY Continental GT Convertible
BENTLEY Continental GT Convertible
BENTLEY Flying Spur
BENTLEY Flying Spur
BENTLEY Flying Spur
BENTLEY Flying Spur
BENTLEY Mulsanne
BENTLEY Mulsanne
BENTLEY Mulsanne EWB
BENTLEY Mulsanne EWB
6
4
4
6
6
4
4
6
6
6.8
6.8
6.8
6.8
12
8
8
12
12
8
8
12
12
8
8
8
8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
4WD
2WD
2WD
2WD
2WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
FA
FA
CA
CA
FA
FA
CA
CA
FA
CA
FA
CA
FA
BMW 230i Convertible
BMW 230i Convertible
2
2
4 SemiAuto-8
4 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 230i Coupe
BMW 230i Coupe
2
2
4 Man-6
4 Man-6
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 230i Coupe
BMW 230i Coupe
2
2
4 SemiAuto-8
4 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 230i xDrive Convertible
BMW 230i xDrive Convertible
2
2
4 SemiAuto-8
4 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 230i xDrive Coupe
BMW 230i xDrive Coupe
2
2
4 SemiAuto-8
4 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 320i
BMW 320i
2
2
4 Man-6
4 Man-6
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 320i
BMW 320i
2
2
4 SemiAuto-8
4 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 320i
BMW 320i
BMW 328d
BMW 328d
BMW 328d
BMW 328d
BMW 328d Sports Wagon
BMW 328d Sports Wagon
2
2
2
2
2
2
2
2
4
4
4
4
4
4
4
4
4WD
4WD
2WD
2WD
4WD
4WD
4WD
4WD
Gasoline
Gasoline
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
CA
FA
FA
CA
FA
CA
FA
CA
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
MPG Data
T3B160
T3B125
U2
L2
T3B160
T3B125
U2
L2
T3B160
L2
T3B160
L2
T3B160
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L2ULE
V125
T3B125
L2ULE
V125
T3B125
L2ULE
V125
T3B125
T3B125
U2
T3B125
U2
T3B125
U2
small car
small car
small car
small car
small car
midsize car
midsize car
midsize car
midsize car
midsize car
midsize car
midsize car
midsize car
5
6
6
5
5
6
6
5
5
5
5
5
5
12
14
14
12
12
14
14
12
12
11
11
11
11
21
24
24
20
20
24
24
20
20
18
18
17
17
15
17
17
15
15
17
17
15
15
14
14
13
13
2
3
3
2
2
3
3
2
2
1
1
1
1
No
No
No
No
No
No
No
No
No
No
No
No
No
580
517
517
604
604
517
517
604
604
652
652
692
692
small car
small car
9
8
23
23
34
34
27
27
6 No
6 No
324
324
small car
small car
9
8
21
21
32
32
25
25
5 No
5 No
360
360
small car
small car
9
8
24
24
35
35
28
28
6 No
6 No
318
318
small car
small car
9
8
23
23
33
33
26
26
6 No
6 No
335
335
small car
small car
9
8
24
24
33
33
27
27
6 No
6 No
325
325
small car
small car
6
6
23
23
35
35
27
27
6 No
6 No
325
325
small car
small car
6
6
23
23
35
35
28
28
6 No
6 No
323
323
small car
small car
small car
small car
small car
small car
station wagon
station wagon
6
6
6
6
6
6
6
6
23
23
31
31
30
30
30
30
34
34
43
43
40
40
40
40
27
27
36
36
34
34
34
34
6
6
7
7
7
7
7
7
332
332
285
285
303
303
303
303
No
No
Yes
Yes
Yes
Yes
Yes
Yes
Student Name
BMW 330i
BMW 330i
2
2
4 Man-6
4 Man-6
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 330i
BMW 330i
2
2
4 SemiAuto-8
4 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 330i
BMW 330i
2
2
4 SemiAuto-8
4 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 330i Gran Turismo
BMW 330i Gran Turismo
2
2
4 SemiAuto-8
4 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 330i Sports Wagon
BMW 330i Sports Wagon
2
2
4 SemiAuto-8
4 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 340i
BMW 340i
3
3
6 Man-6
6 Man-6
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 340i
BMW 340i
3
3
6 Man-6
6 Man-6
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 340i
BMW 340i
3
3
6 SemiAuto-8
6 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 340i
BMW 340i
3
3
6 SemiAuto-8
6 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 340i Gran Turismo
BMW 340i Gran Turismo
3
3
6 SemiAuto-8
6 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 430i Convertible
BMW 430i Convertible
2
2
4 SemiAuto-8
4 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 430i Convertible
BMW 430i Convertible
2
2
4 SemiAuto-8
4 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 430i Coupe
BMW 430i Coupe
2
2
4 Man-6
4 Man-6
2WD
2WD
Gasoline
Gasoline
CA
FA
MPG Data
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
small car
small car
9
8
21
21
32
32
25
25
5 No
5 No
360
360
small car
small car
9
8
23
23
34
34
27
27
6 No
6 No
324
324
small car
small car
9
8
23
23
33
33
26
26
6 No
6 No
335
335
large car
large car
9
8
23
23
33
33
26
26
6 No
6 No
335
335
station wagon
station wagon
9
8
23
23
33
33
26
26
6 No
6 No
335
335
small car
small car
6
6
19
19
29
29
23
23
5 No
5 No
395
395
small car
small car
6
6
19
19
29
29
23
23
5 No
5 No
391
391
small car
small car
6
6
21
21
32
32
25
25
5 No
5 No
358
358
small car
small car
6
6
21
21
31
31
25
25
5 No
5 No
357
357
large car
large car
6
6
20
20
30
30
24
24
5 No
5 No
374
374
small car
small car
9
8
23
23
34
34
27
27
6 No
6 No
324
324
small car
small car
9
8
22
22
32
32
26
26
6 No
6 No
343
343
small car
small car
9
8
21
21
33
33
25
25
5 No
5 No
351
351
Student Name
BMW 430i Coupe
BMW 430i Coupe
2
2
4 SemiAuto-8
4 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 430i Coupe
BMW 430i Coupe
2
2
4 SemiAuto-8
4 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 430i Gran Coupe
BMW 430i Gran Coupe
2
2
4 SemiAuto-8
4 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 430i Gran Coupe
BMW 430i Gran Coupe
2
2
4 SemiAuto-8
4 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 440i Convertible
BMW 440i Convertible
3
3
6 SemiAuto-8
6 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 440i Convertible
BMW 440i Convertible
3
3
6 SemiAuto-8
6 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 440i Coupe
BMW 440i Coupe
3
3
6 Man-6
6 Man-6
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 440i Coupe
BMW 440i Coupe
3
3
6 Man-6
6 Man-6
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 440i Coupe
BMW 440i Coupe
3
3
6 SemiAuto-8
6 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 440i Coupe
BMW 440i Coupe
3
3
6 SemiAuto-8
6 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 440i Gran Coupe
BMW 440i Gran Coupe
3
3
6 SemiAuto-8
6 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 440i Gran Coupe
BMW 440i Gran Coupe
3
3
6 SemiAuto-8
6 SemiAuto-8
4WD
4WD
Gasoline
Gasoline
CA
FA
BMW 530i
BMW 530i
2
2
4 SemiAuto-8
4 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
BMW 530i
BMW 530i
BMW 535i Gran Turismo
2
2
3
4 SemiAuto-8
4 SemiAuto-8
6 SemiAuto-8
4WD
4WD
2WD
Gasoline
Gasoline
Gasoline
CA
FA
FA
MPG Data
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3ULEV
125
T3B125
L3SULE
V30/PZ
EV
T3B30
L3SULE
V30/PZ
EV
T3B30
T3B125
small car
small car
9
8
23
23
34
34
27
27
6 No
6 No
324
324
small car
small car
9
8
23
23
33
33
26
26
6 No
6 No
335
335
small car
small car
9
8
23
23
34
34
27
27
6 No
6 No
324
324
small car
small car
9
8
23
23
33
33
26
26
6 No
6 No
335
335
small car
small car
6
6
21
21
29
29
24
24
5 No
5 No
372
372
small car
small car
6
6
20
20
30
30
24
24
5 No
5 No
374
374
small car
small car
6
6
19
19
29
29
23
23
5 No
5 No
395
395
small car
small car
6
6
19
19
29
29
23
23
5 No
5 No
391
391
small car
small car
6
6
21
21
32
32
25
25
5 No
5 No
358
358
small car
small car
6
6
21
21
31
31
25
25
5 No
5 No
357
357
small car
small car
6
6
21
21
32
32
25
25
5 No
5 No
358
358
small car
small car
6
6
21
21
31
31
25
25
5 No
5 No
357
357
midsize car
midsize car
9
8
24
24
34
34
27
27
6 No
6 No
326
326
midsize car
midsize car
large car
9
8
6
23
23
19
33
33
27
27
27
22
6 No
6 No
5 No
335
335
405
Student Name
BMW 535i Gran Turismo
BMW 535i Gran Turismo
BMW 535i Gran Turismo
3
3
3
6 SemiAuto-8
6 SemiAuto-8
6 SemiAuto-8
2WD
4WD
4WD
Gasoline
Gasoline
Gasoline
CA
FA
CA
BMW 540i
BMW 540i
3
3
6 SemiAuto-8
6 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
6
6
8
8
6
6
6
6
6
6
6
6
6
6
6
6
8
8
8
8
8
8
8
8
8
8
8
8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
SemiAuto-8
4WD
4WD
4WD
4WD
2WD
2WD
4WD
4WD
2WD
2WD
4WD
4WD
2WD
2WD
4WD
4WD
2WD
2WD
4WD
4WD
2WD
2WD
4WD
4WD
2WD
2WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
CA
FA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
FA
CA
6 SemiAuto-8
6 SemiAuto-8
2WD
2WD
Gasoline
Gasoline
CA
FA
6
6
8
8
8
8
8
8
8
4WD
4WD
2WD
2WD
4WD
4WD
4WD
4WD
4WD
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
Gasoline
CA
FA
FA
CA
FA
CA
FA
CA
FA
BMW 540i
BMW 540i
BMW 550i Gran Turismo
BMW 550i Gran Turismo
BMW 640i
BMW 640i
BMW 640i
BMW 640i
BMW 640i Convertible
BMW 640i Convertible
BMW 640i Convertible
BMW 640i Convertible
BMW 640i Gran Coupe
BMW 640i Gran Coupe
BMW 640i Gran Coupe
BMW 640i Gran Coupe
BMW 650i
BMW 650i
BMW 650i
BMW 650i
BMW 650i Convertible
BMW 650i Convertible
BMW 650i Convertible
BMW 650i Convertible
BMW 650i Gran…
Purchase answer to see full
attachment