Visualizing and communicating in Excel

profiledemmyemi
DYS543_course_project1.xlsx
Home>Business & Finance homework help>Visualizing and communicating in Excel

Instructions

DYS543: Visualizing and Communicating Insights in Excel
Course Project
Instructions:
This is your course project. Make sure to save all progress often, as you will be submitting this project for review later. Working through this project, you will have the opportunity to sort and organize data into new, visually appealing charts and graphs. In Part One of the project, you will create a more refined way to view and sort through data in order to making a car buying decision. In Part Two of the project, you will create an action plan to help guide your efforts in visualizing and communicating insights using data in your own workplace. In Part Three of the project, you will assist the a Census Bureau in examining population trends between different regions.

Part 1 Instructions

Recently your car has begun to have some maintenance issues, so you decide to do some initial research into buying a replacement car. You find a great website that has pricing and efficiency data for a large variety of used vehicles made in the years 2013-2017. You are wondering which auto manufacturer offers the lowest maintenance costs for 2017 vehicles. Follow the steps to create a more refined way to view and sort through the data you found on a car-pricing website in order to make a buying decision.
1 Once your data is formatted in a uniform manner and is easy to read, turn the data into a table in a new tab.
2 Add a new column named Lowest to the right of the 2017 column that calculates the lowest price for each model across the five years.
3 In a new worksheet PivotTable, create a PivotTable report to analyze the lowest prices of each manufacturer and model by year.
4 Properly format values and column headings if they require adjustment.
5 You recently read an article that said cars with an efficiency rating of 3 are the most cost efficient (have the lowest maintenance costs) in the long run. Adjust your report so that you are only shown totals for cars with this rating. (Hint: add a report filter)
6 Sort the most recent data to determine which model/manufacturer is the best to start with in order to keep maintenance costs low. Highlight your answer.
7 Now that you know which manufacturer to start with, go back to the Data tab and copy the data from the best manufacturer into a new tab.
8 Create a new pivot table with the most recent cost data and determine which model of car you should consider buying to meet your objective.
9 Highlight your result.
Chosen Model

Part 1 Project Data

Manufacturer Model Efficiency Rating 2013 2014 2015 2016 2017
BMW Z8 3 32,078 44,753 41,148 42,427 48,662
BMW Z4 1 37,984 39,927 27,424 34,806 42,258
BMW Z3 2 28,713 35,302 37,756 36,747 53,120
BMW Z1 3 28,088 39,328 47,298 26,371 31,942
BMW X6 4 27,139 30,627 45,644 30,284 31,308
BMW X5 4.8is SAV 5 18,004 43,238 35,558 38,952 50,168
BMW X5 4.4i SAV 3 30,468 27,142 24,890 43,456 37,461
BMW X5 3.0i SAV 1 28,335 39,778 37,496 49,184 38,744
BMW X5 5 35,265 41,656 26,552 30,337 35,704
BMW X3 3.0i SAV 1 38,342 21,405 33,028 26,079 31,321
BMW X3 4 38,282 39,754 29,425 41,998 30,517
BMW X1 4 23,678 23,154 46,805 26,192 39,228
BMW V7 2 36,792 29,177 42,772 39,592 53,225
BMW New Six 5 38,200 24,082 33,811 27,288 40,677
BMW New Class 1 35,269 44,534 40,267 36,513 53,354
BMW Mini E 4 33,169 27,944 32,327 29,763 45,764
BMW M6 2 27,360 20,205 43,082 49,824 34,171
BMW M5 E28 1 35,168 30,652 42,099 31,110 36,860
BMW M5 5 34,130 27,690 43,257 26,688 34,127
BMW M3 5 27,314 20,624 35,300 45,695 53,187
BMW M1 3 21,890 40,226 23,760 37,516 31,331
BMW M Roadster 3 39,784 24,051 38,615 45,389 35,386
BMW M Coupe 2 21,815 26,505 31,572 33,857 39,684
BMW Isetta 4 32,837 44,911 43,070 30,494 36,704
BMW Hydrogen 7 2 25,540 33,482 27,505 30,836 37,788
BMW H2R 2 29,873 26,514 41,178 42,941 51,340
BMW F3 4 37,690 42,143 38,619 25,405 47,393
BMW F07 1 25,436 22,305 44,803 29,892 39,623
BMW E9 5 18,687 34,882 36,091 28,717 48,542
BMW Concept X6 ActiveHybrid 4 23,597 27,533 38,814 45,245 44,607
BMW Compact 4 36,109 35,422 47,541 46,540 52,297
BMW Brilliance BS6 5 36,465 20,726 39,202 34,877 31,558
BMW 8 Series 3 31,086 23,666 42,184 35,931 41,300
BMW 760 1 33,789 27,639 39,975 34,096 36,223
BMW 750 5 29,488 28,970 35,455 30,269 34,020
BMW 745i E23 1 24,515 20,057 24,825 46,320 33,536
BMW 745 5 33,896 39,662 27,004 28,272 43,248
BMW 700 3 22,966 32,466 33,127 35,649 50,532
BMW 7 Series 1 20,423 31,589 26,504 29,345 43,742
BMW 650 2 33,150 41,793 27,459 43,521 33,794
BMW 645 1 26,793 22,092 24,441 38,481 49,721
BMW 600 4 28,176 42,925 25,139 27,806 36,025
BMW 6 Series 5 24,314 35,902 47,589 35,076 33,485
BMW 550i 3 24,416 20,066 30,879 36,120 40,951
BMW 550 3 27,618 41,815 25,989 26,004 51,007
BMW 545 2 20,384 27,291 47,346 35,354 44,729
BMW 535 5 38,445 23,962 46,746 36,897 48,869
BMW 530 MLE 4 36,407 28,819 46,004 45,099 54,996
BMW 530 5 39,335 23,508 32,656 39,932 40,297
BMW 528 3 28,263 29,611 33,807 36,295 45,139
BMW 525 3 37,068 43,724 35,206 26,430 45,019
BMW 507 4 39,570 39,965 23,466 38,044 47,594
BMW 503 2 19,862 43,858 40,829 49,025 50,736
BMW 501 3 35,354 33,649 30,150 34,200 45,507
BMW 5 Series 2 37,838 20,459 30,550 44,791 35,407
BMW 41718 4 21,495 27,341 25,397 25,483 34,986
BMW 340 3 21,671 32,891 46,033 41,149 50,596
BMW 335 1 27,385 44,914 45,286 38,928 40,431
BMW 333i E30 5 34,139 33,811 26,759 38,335 53,881
BMW 330 2 32,409 34,810 31,822 26,359 48,909
BMW 328 5 27,970 23,202 37,589 41,305 37,679
BMW 327 3 23,686 30,475 33,694 25,466 36,223
BMW 326 5 31,882 26,842 35,551 32,029 37,680
BMW 325is E30 2 25,033 40,548 47,936 36,804 45,342
BMW 325 1 39,142 28,015 24,962 46,673 44,760
BMW 321 5 33,480 41,343 31,598 25,338 32,807
BMW 320i 4 18,980 43,773 44,125 46,435 39,011
BMW 3200 CS 2 22,208 29,606 24,067 33,980 31,054
BMW 320 4 22,718 20,690 41,805 26,717 40,610
BMW 315 2 22,942 44,471 25,416 47,217 45,033
BMW 3 Series Gran Turismo 2 20,760 41,514 37,562 33,787 38,908
BMW 3 Series 2 25,915 38,824 27,191 38,737 40,793
BMW 2002tii 2 28,716 32,393 32,407 47,999 31,199
BMW 2002ti 3 20,823 32,624 39,581 45,854 53,980
BMW 2002 5 24,522 27,507 38,884 36,458 48,152
BMW 1600 4 21,267 33,073 39,364 48,044 34,177
BMW 135 5 25,934 34,404 27,907 44,666 34,714
BMW 128 3 28,501 21,417 31,473 34,325 47,033
BMW 1 Series 5 29,034 21,230 35,236 49,061 48,878
Chevrolet Yeoman 5 28,194 31,085 33,167 34,664 52,203
Chevrolet Yenko Camaro 3 26,646 36,833 25,739 40,981 37,839
Chevrolet Volt 5 27,231 21,985 34,490 26,815 37,284
Chevrolet Venture 4 30,571 36,080 31,417 37,002 38,059
Chevrolet Vega 3 23,790 34,566 27,672 46,432 34,098
Chevrolet Uplander 4 39,526 27,690 24,523 45,659 37,310
Chevrolet Traverse 4 25,606 40,932 32,636 27,843 45,772
Chevrolet Trailblazer 3 20,674 32,811 37,911 40,240 34,401
Chevrolet Tracker 2 21,600 40,265 45,726 48,011 43,647
Chevrolet Townsman 4 34,636 41,156 26,933 31,736 41,644
Chevrolet Titan 4 26,581 39,948 34,772 43,631 42,282
Chevrolet Third-generation Chevrolet Camaro 4 22,502 24,197 33,704 38,150 34,707
Chevrolet Task Force 5 25,482 35,511 41,584 27,019 33,393
Chevrolet Tahoe 3 28,087 38,143 42,992 37,236 48,655
Chevrolet Superior 2 39,648 20,162 23,181 49,261 48,134
Chevrolet Suburban 5 21,448 38,132 29,726 25,635 44,339
Chevrolet Styleline 1 26,490 27,593 29,761 25,534 51,672
Chevrolet SSR 5 20,313 39,897 29,817 37,209 47,299
Chevrolet SS 4 30,986 32,354 32,551 33,772 52,386
Chevrolet Sprint 4 35,120 23,976 37,255 44,952 30,127
Chevrolet Spark 3 28,137 42,405 39,626 37,552 44,584
Chevrolet Sonic 1 31,373 40,922 27,744 41,189 40,208
Chevrolet Silverado 2 36,691 44,562 23,170 45,310 48,543
Chevrolet Sequel 4 28,397 21,296 27,395 33,638 39,278
Chevrolet Second-generation Chevrolet Camaro 2 27,233 30,889 33,805 29,503 51,132
Chevrolet Saturn Astra 5 21,415 43,985 34,710 49,989 38,026
Chevrolet S-10 EV 2 24,055 24,974 36,059 41,370 38,735
Chevrolet S-10 Blazer 4 23,233 34,632 35,136 26,472 43,551
Chevrolet S-10 4 31,135 41,650 31,662 35,487 37,979
Chevrolet Parkwood 5 23,803 42,326 24,380 37,688 41,051
Chevrolet Orlando 5 37,775 25,540 30,329 41,844 46,746
Chevrolet Opala 3 31,049 27,763 33,592 40,386 43,833
Chevrolet Omega 1 29,598 27,846 43,328 27,187 46,992
Chevrolet Nova SS 4 27,316 38,670 37,049 43,952 39,013
Chevrolet Nomad 3 30,253 27,390 43,795 40,076 32,974
Chevrolet Monza 2 24,234 36,592 38,729 38,667 44,507
Chevrolet Monte Carlo 2 39,486 21,062 26,830 29,469 48,082
Chevrolet Montana 3 21,150 40,249 28,232 46,246 44,670
Chevrolet Maruti Versa 3 31,049 23,348 44,270 44,165 51,030
Chevrolet Maruti Esteem 1 39,566 24,134 41,940 28,242 52,128
Chevrolet Marajó 2 24,150 22,717 29,841 25,150 47,015
Chevrolet Malibu 1 35,819 20,456 29,909 30,224 52,467
Chevrolet LUV 3 24,385 30,524 28,336 26,363 38,199
Chevrolet Lumina Z34 2 28,619 34,558 35,881 37,014 48,013
Chevrolet Lumina APV 4 29,025 22,843 40,617 44,805 51,173
Chevrolet Lumina 4 32,316 44,767 28,712 35,287 49,014
Chevrolet Lakewood 2 38,563 33,346 26,965 44,786 54,702
Chevrolet Kodiak 3 26,376 22,802 31,705 39,367 50,030
Chevrolet Kingswood 3 21,002 20,442 31,991 47,609 48,116
Chevrolet Kadett 5 31,380 40,787 25,427 49,897 43,040
Chevrolet K5 Blazer 2 25,681 24,919 33,837 33,446 42,668
Chevrolet Impala SS 4 20,551 35,170 40,911 44,412 30,793
Chevrolet Impala 5 24,585 21,994 28,620 45,554 33,948
Chevrolet Holden Caprice 5 32,104 23,687 24,818 39,742 38,750
Chevrolet HHR 3 21,367 37,283 45,473 36,937 54,976
Chevrolet Greenbrier 1 23,548 42,191 39,039 46,189 39,712
Chevrolet Geo Sprint 4 21,247 20,952 44,451 33,474 32,549
Chevrolet Geo Spectrum 1 19,686 37,846 46,454 28,945 38,102
Chevrolet Geo Prizm 2 26,500 39,426 29,552 31,216 47,510
Chevrolet Geo Metro 3 22,461 34,969 47,057 47,477 48,503
Chevrolet Fourth-generation Chevrolet Camaro 2 24,599 43,574 47,382 34,214 44,533
Chevrolet Fleetline 4 22,189 30,501 35,627 26,485 30,999
Chevrolet First-generation Chevrolet Camaro 3 29,357 44,403 43,969 34,154 49,605
Chevrolet Firenza CanAm 3 23,853 38,275 29,710 36,218 32,733
Chevrolet Express 1 36,320 30,185 35,360 29,793 36,222
Chevrolet Equinox 5 27,870 29,779 41,910 43,434 53,193
Chevrolet El Camino 2 21,905 38,809 38,179 34,400 38,915
Chevrolet Delray 5 32,465 28,415 44,386 39,015 44,147
Chevrolet Cruze 1 18,412 33,198 47,997 34,109 40,445
Chevrolet Cosworth Vega 2 36,346 40,368 39,553 28,213 43,730
Chevrolet Corvette Stingray 3 30,253 29,941 46,205 38,144 43,225
Chevrolet Corvette Mako Shark 5 30,355 35,396 25,794 45,016 37,546
Chevrolet Corvette Convertible 2 35,406 41,738 24,225 48,177 43,814
Chevrolet Corvette C6 ZR1 2 32,045 44,342 25,940 44,676 40,885
Chevrolet Corvette C6 4 30,275 22,390 44,553 44,302 52,754
Chevrolet Corvette C4 5 29,058 21,464 41,741 44,109 44,804
Chevrolet Corvette C1 4 22,757 25,729 38,735 28,260 45,435
Chevrolet Corvette 5 36,990 26,786 42,268 47,127 47,823
Chevrolet Corvair Monza GT 4 30,607 36,473 39,992 49,742 38,137
Chevrolet Corvair 900 Monza 5 24,434 23,943 33,034 26,438 30,946
Chevrolet Corvair 500 1 26,957 28,330 29,202 38,826 41,476
Chevrolet Corvair 5 30,654 42,897 26,987 26,959 34,314
Chevrolet Corsica 3 31,998 23,643 35,442 29,652 53,778
Chevrolet Constantia 1 35,016 21,541 38,019 40,523 45,393
Chevrolet Colorado 1 29,552 44,545 46,637 38,126 53,717
Chevrolet Cobalt SS 1 32,556 26,748 45,774 43,516 30,858
Chevrolet Cobalt 5 33,193 41,035 41,010 38,913 37,186
Chevrolet Citation 1 32,241 36,750 38,947 26,252 35,057
Chevrolet Chevy II / Nova 4 27,864 21,911 35,599 34,965 37,896
Chevrolet Chevette 2 33,851 23,332 45,962 39,264 49,649
Chevrolet Chevelle SS 454 3 25,448 24,196 34,127 40,719 48,395
Chevrolet Chevelle Laguna 1 34,534 20,150 27,319 43,115 41,039
Chevrolet Chevelle COPO 427 2 33,079 25,045 44,739 37,872 42,413
Chevrolet Chevelle 3 25,124 28,750 39,960 47,698 40,165
Chevrolet Cerv 1 5 25,625 34,867 35,095 48,382 49,223
Chevrolet Celta 1 37,779 23,539 42,845 48,953 46,267
Chevrolet Celebrity 5 31,340 23,589 31,787 25,389 33,212
Chevrolet Cavalier 3 34,317 24,118 29,672 26,269 31,279
Chevrolet Captiva 4 21,342 41,058 37,962 30,068 50,833
Chevrolet Caprice LS 5 26,301 22,083 44,214 42,162 43,176
Chevrolet Caprice 3 21,859 41,002 24,835 33,524 40,127
Chevrolet Camaro 5 29,791 23,962 43,763 26,260 52,745
Chevrolet C/K 2 35,590 30,311 38,655 43,204 35,342
Chevrolet Bruin 1 31,740 41,693 32,548 38,309 53,929
Chevrolet Bison 2 24,538 40,626 30,858 40,634 54,845
Chevrolet Biscayne 2 27,601 34,767 40,215 30,678 50,301
Chevrolet Beretta 1 36,584 36,551 36,366 32,523 51,534
Chevrolet Bel Air 5 32,633 32,974 25,768 44,111 38,211
Chevrolet Beauville 4 34,995 40,494 47,957 28,448 46,145
Chevrolet Aveo 5 31,216 44,732 35,663 38,963 34,287
Chevrolet Avalanche 5 21,020 35,994 31,708 48,443 51,578
Chevrolet Astro 1 26,894 24,545 33,562 37,800 37,618
Chevrolet Apache 3 32,226 39,561 35,769 42,059 33,917
Chevrolet Agile 4 38,274 40,184 36,161 25,284 37,791
Chevrolet Aerovette 4 19,740 40,520 47,874 37,014 54,701
Chevrolet Advance Design 5 32,734 26,866 26,229 41,191 30,460
Chevrolet 400 1 25,372 32,685 25,822 37,834 34,279
Chevrolet 210 1 22,846 34,700 23,372 42,840 43,564
Chevrolet 1957 Chevrolet 5 23,851 30,694 33,508 33,966 53,074
Chevrolet 150 5 18,393 24,896 26,855 38,056 31,768
Chrysler Windsor 4 19,781 38,983 26,004 30,530 39,873
Chrysler Voyager 4 38,251 33,081 41,717 46,716 51,094
Chrysler Viper GTS-R 2 20,761 38,970 25,818 33,880 40,662
Chrysler Valiant Charger 5 21,825 40,582 47,023 25,964 30,058
Chrysler Valiant 4 23,967 33,990 31,371 46,475 38,377
Chrysler Turbine Car 1 30,314 29,865 27,650 28,323 32,272
Chrysler Town and Country 2 28,983 33,465 42,552 33,322 45,252
Chrysler TEVan 2 18,690 28,033 30,315 35,787 52,933
Chrysler TC by Maserati 4 34,908 21,779 28,763 35,752 46,916
Chrysler Sunbeam 5 19,712 29,030 27,753 30,889 40,234
Chrysler SRT Viper 5 28,467 24,002 32,748 47,984 49,778
Chrysler Sigma 1 37,555 23,292 44,235 27,248 54,535
Chrysler Shelby Lancer 5 37,682 43,590 31,574 47,314 43,545
Chrysler Shelby GLHS 3 18,648 37,169 33,328 37,271 45,585
Chrysler Shelby CSX 4 28,020 29,565 41,598 45,067 54,352
Chrysler Shelby Charger 4 22,661 38,090 34,518 30,546 41,937
Chrysler Sebring 1 30,441 33,886 46,108 46,286 53,226
Chrysler Saratoga 3 38,837 36,174 31,844 25,306 41,986
Chrysler Royal 5 21,065 42,466 34,925 27,748 37,174
Chrysler PT Cruiser 2 34,175 25,317 41,917 36,122 54,149
Chrysler Pronto Cruizer 5 33,524 40,212 39,854 45,505 40,135
Chrysler Plymouth Voyager 4 23,970 33,407 24,995 47,739 49,557
Chrysler Plymouth Valiant 4 24,921 41,320 32,866 41,611 48,892
Chrysler Plymouth Sundance 2 36,261 34,043 38,611 26,223 51,583
Chrysler Plymouth Savoy 2 30,135 41,874 44,439 35,906 53,107
Chrysler Plymouth Satellite 3 26,324 38,771 33,189 38,448 51,481
Chrysler Plymouth Reliant 3 30,653 36,101 29,316 27,572 31,210
Chrysler Plymouth Prowler 1 35,846 37,001 41,310 43,726 32,627
Chrysler Plymouth Gran Fury 1 33,684 34,637 40,041 43,089 52,062
Chrysler Plymouth Breeze 3 21,489 27,209 29,335 44,577 49,928
Chrysler Pacifica 5 30,670 44,208 30,749 43,366 42,931
Chrysler Newport 5 30,201 32,769 43,558 34,227 40,650
Chrysler New Yorker 5 23,567 31,707 25,069 41,865 54,044
Chrysler Neon 5 19,612 23,879 36,251 44,343 36,519
Chrysler Natrium 2 35,775 28,615 27,693 43,923 51,494
Chrysler Nassau 3 33,698 43,770 29,480 40,802 35,385
Chrysler Mitsubishi Raider 1 25,793 36,041 26,432 48,558 31,904
Chrysler LHS 3 22,604 44,638 26,558 27,174 44,280
Chrysler LeBaron 4 28,025 42,984 45,616 47,863 54,734
Chrysler Jeep Wrangler 4 37,177 34,701 23,973 26,722 34,951
Chrysler Jeep Patriot 4 33,056 32,320 35,533 43,309 43,527
Chrysler Jeep Liberty 1 38,829 21,969 33,117 48,266 34,173
Chrysler Jeep Grand Cherokee 3 33,822 29,119 45,626 44,374 38,699
Chrysler Jeep Compass 2 26,218 37,898 30,737 47,102 51,754
Chrysler Jeep Commander 1 37,971 22,386 37,054 37,694 54,208
Chrysler Jeep Comanche 1 36,672 20,411 46,457 38,760 46,545
Chrysler Jeep Cherokee (XJ) 1 27,205 38,226 28,904 47,659 30,074
Chrysler Jeep 3 19,646 25,819 40,964 26,819 35,083
Chrysler Java 2 27,567 42,851 45,644 33,342 42,702
Chrysler Imperial 2 28,968 41,338 24,330 42,886 48,027
Chrysler Horizon 3 39,325 25,070 28,312 39,093 34,917
Chrysler Fifth Avenue 2 22,706 27,898 39,201 38,392 36,132
Chrysler Executive 2 19,239 28,360 38,866 32,278 54,194
Chrysler Eagle Vision 4 34,766 28,591 27,547 27,624 41,516
Chrysler Eagle Premier 3 21,032 34,925 37,924 41,238 39,667
Chrysler E-Class 2 25,971 31,579 27,971 27,251 44,338
Chrysler Drifter 1 18,381 33,915 29,930 29,968 32,679
Chrysler Dodge Stratus 4 32,136 44,393 38,161 29,301 33,135
Chrysler Dodge St. Regis 3 39,006 42,458 37,053 32,026 54,092
Chrysler Dodge Spirit 2 22,996 37,709 42,747 36,804 32,445
Chrysler Dodge Shadow 2 39,936 27,886 36,138 35,151 50,936
Chrysler Dodge Ramcharger 4 39,783 20,826 26,641 25,465 49,781
Chrysler Dodge Ram Van 1 28,986 36,099 46,397 44,014 45,947
Chrysler Dodge Ram 2 22,233 43,804 45,127 32,778 52,263
Chrysler Dodge Omni 24 3 27,662 35,518 34,608 26,390 45,923
Chrysler Dodge Omni 5 20,830 31,137 36,113 46,911 44,110
Chrysler Dodge Nitro 4 34,250 26,803 44,156 42,710 54,537
Chrysler Dodge Monaco 5 32,507 31,363 33,295 44,997 42,610
Chrysler Dodge Mirada 3 19,115 39,336 27,009 42,366 42,633
Chrysler Dodge Magnum 4 30,406 32,114 40,575 27,793 36,854
Chrysler Dodge Lancer 1 22,439 20,274 41,645 47,208 44,242
Chrysler Dodge Intrepid 2 30,552 38,012 23,961 28,147 45,400
Chrysler Dodge Dynasty 1 37,128 32,839 32,853 34,095 40,598
Chrysler Dodge Daytona 4 24,251 28,584 27,941 27,479 46,265
Chrysler Dodge Coronet 5 19,041 40,500 23,992 41,154 42,151
Chrysler Dodge Charger 3 19,229 36,491 29,930 32,238 44,678
Chrysler Dodge Caravan 4 34,119 33,030 23,061 47,503 35,532
Chrysler Dodge Caliber 4 21,794 22,910 32,830 36,167 53,073
Chrysler Dodge Avenger 3 32,209 41,183 35,369 47,486 34,635
Chrysler Dodge Aspen 2 26,741 26,949 23,404 28,037 39,957
Chrysler Dodge Aries 1 30,966 22,550 46,186 40,631 45,535
Chrysler Dodge A100 4 23,312 30,717 47,140 28,630 38,655
Chrysler Crossfire 2 31,249 36,478 27,622 47,627 40,742
Chrysler Cordoba 5 33,132 38,170 41,934 32,128 36,749
Chrysler Concorde 4 27,370 38,595 31,744 34,606 34,876
Chrysler Cirrus 2 21,249 25,804 28,268 40,221 41,964
Chrysler Centura 2 31,443 31,973 35,769 32,364 30,793
Chrysler Atlantic 3 31,619 32,406 43,284 45,914 38,242
Chrysler Aspen 2 30,064 21,507 35,504 43,789 50,189
Chrysler AP3 Hearse Built by R.F.Weber 4 26,068 25,528 30,088 28,747 43,881
Chrysler AMC Eagle 4 29,424 39,393 42,733 29,161 53,167
Chrysler Airstream 4 24,844 29,547 37,242 39,494 36,496
Chrysler Airflow 2 38,399 40,426 29,194 30,750 36,391
Chrysler 300M 3 39,501 31,037 29,868 43,789 32,307
Chrysler 300L 5 31,546 21,188 32,029 44,105 51,801
Chrysler 300C 4 38,421 24,279 34,599 40,062 36,566
Chrysler 300 non-letter series 3 24,795 24,011 36,963 49,427 35,114
Chrysler 300 letter series 4 28,737 42,487 44,928 34,449 40,680
Chrysler 200C EV 2 39,622 33,751 38,669 28,892 45,950
Chrysler 200 1 21,565 25,624 23,240 30,492 35,876
Chrysler 180 3 28,087 28,954 45,603 41,952 35,162
Chrysler 300 3 37,337 44,538 33,047 35,250 48,666
Dodge Warlock 4 38,692 39,079 40,605 33,896 32,740
Dodge Viscount 2 21,586 30,783 38,004 34,151 44,890
Dodge Viper E85 2 34,324 28,389 38,715 40,828 38,158
Dodge Town Wagon 4 20,856 36,042 35,439 25,279 49,224
Dodge Super Bee 5 23,969 21,458 37,033 45,516 43,774
Dodge Stratus 1 24,254 35,538 31,826 46,716 34,762
Dodge SRT Viper 5 33,830 25,358 36,537 40,393 50,282
Dodge Regent 4 36,023 33,997 44,005 44,575 48,311
Dodge Rampage 1 26,384 35,519 40,349 44,158 49,342
Dodge Ram SRT-10 5 26,693 23,556 39,418 42,631 45,670
Dodge Ram Rumble Bee 5 18,354 20,539 23,869 41,088 38,447
Dodge Ram Daytona 5 38,062 35,002 24,068 46,307 48,952
Dodge Raider 5 25,989 30,472 34,386 37,501 43,355
Dodge Power Wagon 4 31,036 40,310 46,937 43,938 54,277
Dodge Polara 500 1 21,632 21,642 29,199 30,068 32,844
Dodge Polara 1 27,153 39,963 37,646 46,960 33,282
Dodge Phoenix 5 23,632 24,257 37,101 33,827 46,353
Dodge Neon SRT-4 4 38,131 33,300 33,251 43,425 47,611
Dodge Mitsubishi Triton 2 33,150 24,553 26,060 27,137 52,881
Dodge Mercedes-Benz Sprinter 2 21,379 22,388 28,450 37,942 42,850
Dodge Meadowbrook 1 22,895 22,573 37,778 32,830 46,072
Dodge Mayfair 1 21,222 42,752 41,142 42,001 31,983
Dodge Matador 5 24,646 31,601 31,593 39,524 47,618
Dodge M37 3 24,854 23,896 35,083 29,826 51,506
Dodge La Femme 1 24,276 37,828 41,606 26,746 45,338
Dodge Kingsway 1 19,260 26,463 44,104 48,914 49,052
Dodge Journey 4 27,484 24,622 46,121 26,349 30,134
Dodge Hennessey Viper Venom 1000 Twin Turbo 1 39,208 36,113 42,910 42,467 32,535
Dodge Ford Model T 4 25,041 37,559 46,715 30,014 54,516
Dodge EV 4 22,263 39,778 31,586 42,940 50,541
Dodge Durango 4 25,644 34,289 31,121 40,302 35,197
Dodge Diplomat 3 24,120 26,079 31,805 49,035 31,719
Dodge Dart Swinger 2 33,477 35,021 45,276 30,572 35,824
Dodge Dart GTS 3 34,739 32,156 36,895 36,635 47,543
Dodge Dart GT 2 38,374 44,708 47,918 35,801 41,995
Dodge Dart Demon 4 19,297 44,437 46,476 25,024 40,738
Dodge Dart 413 3 32,097 44,914 38,019 42,707 54,217
Dodge Dart 4 35,157 22,406 40,354 28,956 53,880
Dodge Dakota 5 31,269 43,140 42,560 43,202 44,773
Dodge D Series 5 34,297 36,337 41,902 47,409 46,122
Dodge Custom 880 5 25,770 24,854 30,760 49,789 44,635
Dodge Crusader 3 26,027 40,324 30,909 30,599 30,094
Dodge Coronet R/T 2 26,565 29,660 42,728 39,141 44,504
Dodge Colt 2 19,562 42,670 36,126 33,542 46,900
Dodge Charger Daytona 4 26,563 43,554 41,607 31,677 46,695
Dodge Charger 500 2 37,786 38,181 23,653 32,127 49,100
Dodge Charger 5 36,408 30,908 30,348 38,123 39,357
Dodge Challenger 2 22,530 29,067 36,387 49,555 48,122
Dodge Caravan 3 38,967 33,833 28,185 46,608 41,507
Dodge C Series 2 31,511 39,166 27,804 42,622 36,922
Dodge B Series 5 22,381 44,902 47,408 36,590 35,263
Dodge Adventurer 2 31,333 39,720 24,118 41,078 49,778
Dodge 600 2 26,369 31,677 26,481 39,972 54,146
Dodge 500 2 27,089 26,275 45,549 41,885 33,743
Dodge 50 Series 2 20,702 26,275 31,088 25,236 54,644
Dodge 440 2 35,061 37,237 46,324 47,639 37,041
Dodge 400 1 29,097 28,436 35,298 28,061 51,814
Dodge 330 5 28,635 25,807 38,519 28,432 54,303
Ford Zephyr 2 20,595 32,440 46,292 38,567 34,737
Ford XY Falcon 1 26,323 24,022 41,547 33,688 44,457
Ford XW Falcon 2 27,677 21,655 46,956 34,915 52,426
Ford XT Falcon 5 35,983 42,138 47,303 33,810 31,857
Ford XP Falcon 2 39,006 32,862 36,068 25,664 40,564
Ford XM Falcon 1 22,997 27,746 46,008 39,697 46,835
Ford XL Falcon 1 26,906 40,392 24,190 27,140 46,026
Ford XK Falcon 3 37,335 41,574 30,544 26,926 48,897
Ford XF Falcon 4 22,619 37,313 45,495 40,807 41,280
Ford XE Falcon 5 31,262 22,166 38,953 26,078 31,642
Ford XC Falcon 1 23,128 35,190 41,848 48,061 33,346
Ford XB Falcon 1 31,598 23,992 42,948 45,337 51,221
Ford XA Falcon 2 27,024 36,340 39,404 49,085 40,658
Ford Windstar 1 29,687 21,765 27,768 43,408 43,560
Ford Versailles 5 21,113 26,113 24,796 45,344 50,878
Ford Vedette 5 38,118 24,925 33,754 42,356 39,441
Ford Transit Connect 3 30,382 43,568 40,045 49,794 53,176
Ford Transit 3 39,049 28,894 37,367 37,413 36,336
Ford Tourneo Connect 1 29,939 20,594 42,087 33,824 33,547
Ford Torino Talladega 4 18,615 23,820 25,735 44,794 31,572
Ford Torino GT 2 35,460 35,610 33,497 44,671 33,917
Ford Torino Cobra 2 19,534 31,714 28,579 43,316 36,821
Ford Torino 3 34,801 27,561 28,663 31,363 48,886
Ford Thunderbolt 5 37,227 34,299 34,384 26,338 51,585
Ford Thunderbird 3 31,306 36,098 24,183 47,253 40,652
Ford Thames Trader 4 18,101 39,344 32,050 45,448 42,719
Ford Thames 307E 1 24,830 44,406 34,379 42,629 51,243
Ford Thames 300E 5 18,326 44,814 26,236 26,460 34,174
Ford Territory 5 27,309 42,993 33,937 39,173 40,942
Ford Tempo 5 34,460 26,802 30,787 32,073 48,119
Ford Telstar 2 39,212 29,157 45,821 44,468 40,157
Ford Taurus X 1 23,492 23,725 46,281 38,570 51,283
Ford Taurus SHO 1 30,883 24,507 36,100 49,243 39,757
Ford Taurus 2 24,423 31,044 25,588 47,263 33,901
Ford SYNus 5 19,893 21,375 40,685 33,584 35,315
Ford SVT Focus 5 32,292 20,381 45,988 25,821 38,904
Ford Starliner 3 23,409 34,677 36,215 44,066 43,389
Ford Sierra XR8 3 23,656 25,820 31,695 38,828 46,775
Ford Sierra RS Cosworth 2 38,325 28,311 30,084 30,404 30,395
Ford Sierra 3 30,567 25,037 29,814 25,647 34,626
Ford Shelby Mustang 5 25,794 23,291 38,583 39,330 53,428
Ford Shelby Cobra Concept 3 33,460 21,076 24,764 32,837 49,260
Ford Scorpio 4 32,032 38,730 37,493 29,019 30,603
Ford Sapphire Cosworth 1 18,909 40,611 42,889 37,662 51,156
Ford S-Max 3 22,486 35,756 47,797 30,664 36,488
Ford RS200 3 30,409 26,891 29,890 45,482 52,037
Ford Ranger EV 4 28,469 27,539 41,565 31,444 35,323
Ford Ranger 5 20,968 32,536 25,858 34,176 37,458
Ford Ranchero 3 31,112 43,170 23,195 29,180 37,366
Ford Ranch Wagon 2 18,827 31,561 36,892 29,634 54,650
Ford Puma 5 30,795 33,030 36,466 44,132 42,893
Ford Probe 2 34,589 37,544 27,991 37,946 54,115
Ford Prefect 2 33,062 31,469 25,403 26,058 47,199
Ford Pinto 4 39,783 32,385 30,207 33,442 38,473
Ford Pilot 1 36,103 25,467 42,350 48,017 47,702
Ford Parklane 2 37,838 41,969 35,344 49,670 32,511
Ford Orion 5 39,118 34,303 40,073 33,055 51,603
Ford Mustang Mach 1 4 18,863 37,415 42,049 40,010 44,345
Ford Mustang Cobra Jet 5 29,119 20,173 34,324 33,468 36,819
Ford Mustang Boss 351 2 35,307 40,378 27,168 26,126 31,274
Ford Mustang 5 21,076 24,896 46,808 45,114 34,053
Ford Mondeo 3 33,812 41,607 34,657 25,694 50,649
Ford Model Y 2 32,886 27,496 36,891 34,390 40,375
Ford Model TT 1 30,572 24,758 42,087 40,721 35,847
Ford Model T 4 38,380 39,978 35,334 35,822 36,061
Ford Model N 4 39,650 20,590 42,054 44,283 51,087
Ford Model K 4 27,728 34,191 46,855 29,226 50,183
Ford Model F 5 30,276 28,278 35,942 31,910 33,459
Ford Model C Ten 3 34,268 43,271 26,505 25,374 42,631
Ford Model C 5 39,777 25,623 39,006 25,834 50,026
Ford Model B 5 31,306 27,638 43,532 47,828 51,056
Ford Model AA 3 38,800 42,076 34,796 36,001 30,328
Ford Model A 5 29,982 42,019 29,916 38,819 36,435
Ford Model 91 4 20,555 21,934 42,891 31,787 43,928
Ford Model 48 5 34,288 39,610 34,940 25,600 40,236
Ford Meteor Rideau 3 23,710 42,095 24,951 26,183 41,700
Ford Mercury Monterey 1 39,187 37,214 37,917 46,715 37,249
Ford Mazda B-Series 4 31,556 35,305 35,618 25,237 35,320
Ford Maverick 3 28,462 32,387 41,761 47,349 43,191
Ford Maruti Versa 3 29,850 22,447 26,781 26,654 49,058
Ford LTD II 5 27,253 32,765 31,833 33,895 31,395
Ford LTD Crown Victoria 3 34,751 24,781 37,170 47,705 39,780
Ford LTD 4 28,311 37,796 28,004 28,261 42,541
Ford Lotus Cortina 2 24,430 28,354 35,236 34,410 31,213
Ford Lightning 4 34,889 30,735 44,471 41,322 36,654
Ford Landau 3 39,166 44,323 27,819 38,083 33,163
Ford Kuga 5 28,262 23,772 41,419 29,484 50,035
Ford Köln 4 22,754 33,584 34,031 37,966 39,433
Ford Ka 3 36,579 24,872 35,547 30,103 43,992
Ford John Goss Special 4 24,374 20,621 42,563 34,202 54,460
Ford Ikon 2 36,074 43,205 31,657 39,371 54,348
Ford GT40 1 20,598 23,725 41,980 44,473 48,727
Ford Granada Perana 4 21,978 35,323 30,788 25,729 32,739
Ford Granada 1 31,507 35,325 25,878 35,642 31,195
Ford GPA 3 37,087 38,347 35,556 27,744 38,251
Ford Galaxy 3 18,343 21,100 42,237 34,228 39,637
Ford Galaxie 500XL 1 20,799 43,194 31,185 31,041 38,740
Ford Galaxie 500 3 29,306 43,919 23,821 36,188 34,745
Ford Galaxie 3 18,454 38,533 47,493 30,145 45,863
Ford Futura 3 23,306 35,191 46,025 31,721 38,327
Ford Fusion 2 24,439 30,366 43,374 46,883 34,758
Ford Freestyle 4 23,604 31,187 38,215 39,187 51,651
Ford Freestar 1 39,788 25,990 40,819 39,461 49,965
Ford Forty-Nine 1 32,893 29,092 34,431 28,252 46,503
Ford Focus RS WRC 3 21,490 21,914 42,961 44,085 45,221
Ford Focus RS 3 24,820 32,923 26,017 35,170 30,636
Ford Focus 1 36,546 30,845 35,090 40,848 36,456
Ford Flex 5 21,924 23,014 44,478 29,329 36,809
Ford Five Hundred 5 36,242 40,585 30,032 49,851 36,658
Ford Fiesta RS Turbo 4 37,717 36,879 27,166 46,585 49,870
Ford Fiesta 4 39,624 21,121 47,031 41,955 53,077
Ford FG Falcon 5 38,250 23,867 25,791 44,961 52,704
Ford Falcon XR6 Turbo 5 22,449 34,429 23,899 40,184 48,356
Ford Falcon Cobra 4 24,275 31,133 27,368 26,560 34,412
Ford Falcon (North America) 3 29,269 26,558 34,549 25,074 40,603
Ford Falcon (Australian version) 1 30,204 31,585 41,947 37,165 54,707
Ford Falcon 3 38,378 25,390 32,909 36,112 54,183
Ford Fairmont GT 4 39,165 30,526 43,511 36,941 39,956
Ford Fairmont 1 37,842 44,115 26,780 38,817 33,308
Ford Fairlane GT 4 19,211 23,306 24,817 43,287 44,827
Ford Fairlane Crown Victoria Skyliner 1 31,096 37,161 26,645 39,471 44,849
Ford Fairlane 500 Skyliner 1 23,061 38,390 31,205 32,574 42,033
Ford Fairlane (Australia) 5 21,122 34,457 46,562 40,901 38,275
Ford Fairlane 2 38,725 20,175 39,188 35,377 34,312
Ford F-Series Super Duty 4 30,189 31,886 40,119 28,278 49,017
Ford F-Series 1 38,862 41,084 43,659 28,978 49,305
Ford F-650 5 28,755 35,561 29,248 35,243 51,446
Ford Explorer Sport Trac 5 35,375 26,604 24,820 48,626 31,808
Ford Explorer 4 21,358 34,040 31,552 39,090 34,670
Ford Expedition 3 34,151 43,706 39,537 45,163 49,380
Ford EXP 4 23,343 40,384 40,173 46,175 50,915
Ford Excursion 4 30,860 21,323 29,080 28,461 48,194
Ford Everest 4 29,836 29,288 36,147 26,509 31,730
Ford Escort RS Cosworth 3 19,002 35,015 38,970 36,306 49,163
Ford Escort Mk3 Perana 2 24,010 36,383 28,580 40,253 44,227
Ford Escort Mk1 Perana 2 24,739 28,276 45,600 30,502 44,066
Ford Escort 2 26,198 25,383 25,298 45,945 43,145
Ford Escape Hybrid 2 30,695 31,993 47,179 25,928 43,365
Ford Escape 2 24,781 31,554 31,473 32,616 37,190
Ford Elite 3 31,787 25,101 43,410 44,915 46,073
Ford EL Falcon 2 31,144 20,377 45,574 25,641 32,387
Ford Edsel Villager 5 23,613 20,572 46,903 25,408 42,247
Ford Edsel Ranger 3 34,326 36,900 41,630 46,827 36,629
Ford Edge 1 26,516 40,210 40,894 48,031 53,991
Ford EcoSport 4 19,304 27,969 23,634 26,712 44,022
Ford EB Falcon 2 31,048 27,576 42,192 37,518 50,364
Ford EA Falcon 4 20,004 37,408 43,403 30,712 49,180
Ford E-Series 1 25,620 21,140 28,808 48,677 50,025
Ford Durango 1 36,333 35,004 36,774 39,673 50,795
Ford Del Rey 5 22,335 23,697 41,619 36,050 52,108
Ford CX 4 27,764 32,230 43,245 25,776 42,761
Ford Custom 500 5 22,168 26,818 26,522 49,339 33,291
Ford Custom 2 39,801 32,607 46,549 32,779 54,952
Ford Crown Victoria Police Interceptor 1 26,547 27,229 40,157 30,619 44,245
Ford Crown Victoria 2 35,226 35,765 26,282 45,287 40,458
Ford Crestline Skyliner 2 38,552 38,914 43,165 37,636 33,729
Ford Country Squire 5 18,165 21,663 33,503 32,868 47,680
Ford Cougar 5 27,771 36,632 25,512 36,321 51,560
Ford Cortina XR6 Interceptor 5 32,563 38,881 38,188 31,794 50,359
Ford Cortina Perana Mk 2 3 31,615 21,237 29,442 32,218 30,656
Ford Cortina 2 23,320 36,355 32,865 44,219 45,051
Ford Corsair 4 34,089 32,020 39,343 36,214 41,418
Ford Corcel 2 26,842 20,235 41,646 37,079 52,995
Ford Contour 2 35,981 26,199 43,402 46,266 30,630
Ford Classic 4 34,175 20,868 30,575 39,761 45,821
Ford Capri Perana 1 18,820 27,531 34,951 40,255 53,756
Ford Capri 1 20,189 44,111 32,718 31,920 46,680
Ford C-Series 1 37,806 42,029 26,198 45,100 32,488
Ford C-Max 1 30,901 37,302 45,844 32,420 49,672
Ford Bronco II 2 29,145 43,485 45,807 29,132 47,611
Ford Bronco 2 29,014 38,374 42,510 33,862 30,022
Ford Boss 429 5 31,679 25,887 32,831 48,286 36,238
Ford Boss 302 Mustang 1 20,374 21,153 31,596 31,087 32,912
Ford BF Falcon 3 27,634 25,587 38,177 27,066 45,158
Ford BA Falcon 2 39,471 39,166 46,612 36,781 42,964
Ford AU Falcon 2 21,727 30,039 43,079 30,991 32,106
Ford Anglia 1 19,885 34,209 33,303 42,045 38,875
Ford Airstream 4 28,901 31,530 40,566 43,337 35,919
Ford Aerostar 3 23,308 41,163 44,077 27,415 34,643
Ford 7W 3 35,165 39,825 40,952 44,518 40,821
Ford 1960 Ford 2 20,782 33,515 25,444 25,677 40,445
Ford 1957 Ford 4 18,344 29,074 43,076 34,304 38,078
Ford 1955 Ford 5 23,968 24,672 23,848 41,606 51,812
Ford 1952 Ford 1 24,777 20,787 45,845 37,391 35,591
Ford 1949 Ford 3 27,834 33,613 25,915 44,981 31,479
Ford 1941 Ford 4 39,890 43,469 38,418 42,269 52,821
Honda Zest 4 23,888 42,085 23,861 30,954 49,645
Honda Z600 4 20,269 43,944 37,356 44,278 32,098
Honda Today 3 24,017 29,002 24,314 37,814 52,362
Honda That's 1 39,202 34,211 29,606 25,137 41,671
Honda T360 3 30,961 22,244 40,388 32,142 50,636
Honda Stream 4 29,353 44,643 38,116 27,797 47,949
Honda Stepwgn 1 20,877 44,853 47,077 26,693 31,496
Honda SM600 3 20,946 43,761 38,421 43,657 40,949
Honda Shuttle 4 31,015 33,407 36,508 25,035 41,113
Honda S800 2 35,723 43,894 26,151 40,622 38,061
Honda S600 4 21,843 29,869 32,542 36,817 31,316
Honda S500 1 31,703 33,049 40,371 37,935 39,475
Honda S2000 5 36,370 29,379 38,098 29,988 42,897
Honda S-MX 3 30,209 24,538 39,422 44,628 40,845
Honda Ridgeline 4 33,965 41,371 29,061 35,581 35,402
Honda Quint 4 30,148 42,876 39,672 31,931 43,749
Honda Prelude 1 29,753 39,267 38,385 31,453 43,941
Honda Pilot 5 38,990 23,242 32,527 46,134 30,070
Honda Passport 5 22,682 36,172 30,741 47,390 30,136
Honda Partner Van 4 37,858 38,536 28,128 47,770 46,356
Honda Orthia 1 18,733 39,429 27,580 27,995 38,066
Honda Odyssey 2 25,294 33,904 36,274 49,166 38,221
Honda NSX-R 5 35,770 33,965 38,793 26,806 45,133
Honda NSX 5 24,649 20,665 28,860 48,291 37,577
Honda N360 4 26,967 40,543 46,972 25,796 42,622
Honda Mobilio Spike 4 38,620 38,492 40,669 47,965 48,597
Honda Mobilio 1 21,504 37,126 36,372 42,227 31,668
Honda Logo 4 33,693 44,047 36,042 35,988 52,986
Honda Life Dunk 3 25,404 38,224 25,679 28,491 44,480
Honda Life 2 30,953 40,188 34,431 35,888 34,459
Honda Legend 2 33,562 25,415 30,184 41,945 49,857
Honda L800 3 19,943 35,729 32,830 38,367 51,117
Honda Integra 3 28,935 35,157 47,832 38,419 30,600
Honda Inspire 4 20,550 24,545 30,018 33,117 50,608
Honda Insight 4 28,769 20,132 40,128 40,134 33,542
Honda HR-V 1 35,684 33,535 41,882 46,920 51,488
Honda Hobio 4 31,370 22,415 26,582 36,011 42,282
Honda Fuya-Jo 1 28,593 24,872 39,986 45,736 41,473
Honda Freed 3 20,948 22,099 40,863 45,512 35,356
Honda Fit 3 22,381 35,251 35,999 44,710 43,667
Honda FCX Clarity 3 20,846 35,124 45,073 31,375 30,667
Honda EV Plus 1 18,829 42,529 32,615 33,555 43,612
Honda Element 3 23,718 30,802 24,343 35,819 52,880
Honda Edix 5 29,250 29,726 40,623 40,235 43,378
Honda Domani 3 38,523 39,454 44,049 26,652 40,752
Honda CR-Z 1 36,657 34,894 46,242 48,415 38,639
Honda CR-X del Sol 1 25,577 38,853 29,005 46,765 32,854
Honda CR-V 3 37,221 31,113 28,737 25,828 50,431
Honda Concerto 2 27,652 40,650 29,424 29,671 52,399
Honda Civic Hybrid 3 18,547 36,288 28,356 43,693 50,227
Honda Civic 1 35,898 41,421 36,107 44,652 46,958
Honda City 5 32,763 31,901 27,012 47,796 43,637
Honda Caren 5 39,247 29,602 41,750 32,240 36,518
Honda Capa 4 35,223 23,979 44,903 42,544 40,392
Honda Beat 4 34,250 30,064 38,062 33,198 49,172
Honda Ballade 4 27,364 30,303 42,445 40,144 53,727
Honda Avancier 4 32,287 27,910 38,632 42,233 30,248
Honda Ascot 5 26,442 25,658 32,194 46,913 38,589
Honda Airwave 2 21,506 22,909 37,982 28,213 31,582
Honda Acura TL 5 39,860 31,377 30,011 46,916 40,362
Honda Acura MDX 2 25,238 32,872 28,077 31,606 36,158
Honda Acty 2 19,340 25,598 37,830 44,595 41,135
Honda Accord 4 28,222 30,881 25,738 32,390 51,565
Hyundai Verna 4 25,779 26,853 39,189 33,855 44,543
Hyundai Veracruz 3 39,293 34,859 41,975 25,137 43,546
Hyundai Universe 4 28,889 35,283 45,095 35,688 35,569
Hyundai Tucson 2 30,535 40,967 42,925 48,411 31,135
Hyundai Trajet 1 18,954 28,811 32,672 42,893 52,500
Hyundai Trago 1 37,543 28,779 45,170 48,937 42,999
Hyundai Tiburon 1 25,885 41,380 37,640 49,443 45,136
Hyundai Terracan 5 33,582 36,588 42,326 32,613 33,774
Hyundai Super Truck Medium 4 39,627 32,359 24,655 43,044 51,318
Hyundai Super Truck 2 26,604 36,476 25,147 48,273 51,247
Hyundai Stellar 2 24,852 43,312 31,021 38,798 35,884
Hyundai Sonata 1 37,785 30,770 41,899 44,727 34,793
Hyundai Scoupe 1 33,656 21,794 42,507 28,724 48,455
Hyundai Santa Fe 4 37,962 37,352 40,866 46,140 54,018
Hyundai Portico 4 38,277 21,368 44,242 42,345 54,196
Hyundai Pony 2 33,133 43,324 23,212 25,364 51,587
Hyundai New Power Truck 2 28,815 21,191 31,294 47,299 41,344
Hyundai Mighty II 1 38,144 33,031 41,787 34,090 38,102
Hyundai Mighty 1 23,708 31,014 38,342 34,595 47,551
Hyundai Mega Truck 3 35,011 24,762 27,018 42,532 44,840
Hyundai Marcia 4 26,522 43,801 23,546 29,459 36,670
Hyundai Lavita 4 21,563 23,562 37,466 36,404 47,090
Hyundai Kia Optima 3 24,992 40,282 25,554 30,973 32,357
Hyundai i30 5 36,479 20,953 31,217 42,447 50,121
Hyundai i20 4 30,219 26,980 29,012 37,074 40,341
Hyundai i10 3 21,196 22,418 39,731 34,061 44,329
Hyundai Grandeur 1 20,221 24,913 30,821 30,774 52,363
Hyundai Global 900 1 33,536 38,021 45,341 35,388 30,849
Hyundai Getz 3 33,695 21,209 44,075 26,685 40,164
Hyundai Genesis Coupe 4 18,789 21,763 24,570 46,192 51,785
Hyundai Genesis 4 23,177 32,768 28,504 25,445 42,621
Hyundai Excel 5 33,219 32,173 32,046 30,424 44,334
Hyundai Equus 1 33,903 32,294 46,295 39,220 46,640
Hyundai Entourage 4 36,092 28,660 38,915 45,983 39,768
Hyundai Elantra 1 23,551 27,043 29,965 44,428 38,226
Hyundai e-Mighty 1 28,972 29,420 30,299 26,850 35,042
Hyundai Dynasty 4 31,434 40,788 30,195 40,398 35,266
Hyundai County 2 24,949 39,477 34,437 37,295 45,855
Hyundai Chorus 3 23,667 26,219 45,666 46,568 31,328
Hyundai Atos 5 24,416 22,933 46,371 41,723 41,298
Hyundai Aero Town 3 34,277 31,016 45,060 45,352 39,813
Hyundai Aero City 4 28,921 27,089 36,980 27,341 33,342
Hyundai Aero 4 35,838 33,429 28,070 31,542 40,432
Hyundai Accent 3 39,341 23,821 33,012 26,020 47,324
Hyundai 8 to 25-ton truck 3 26,107 44,897 27,923 39,640 49,896
Infiniti QX56 5 24,208 40,772 36,798 28,528 43,696
Infiniti QX4 2 29,829 27,210 31,176 35,612 46,700
Infiniti QX 1 35,076 32,120 26,223 36,545 44,571
Infiniti Q45 4 35,943 40,274 26,918 46,106 42,917
Infiniti M45 1 34,906 23,626 43,597 42,462 44,617
Infiniti M35 3 18,637 27,685 26,399 30,502 52,112
Infiniti M30 1 20,794 39,162 32,060 46,348 53,333
Infiniti M 3 26,903 21,563 30,634 37,901 36,550
Infiniti Kuraza 4 31,155 31,579 32,119 44,443 54,196
Infiniti J30 1 31,899 21,547 30,937 34,325 37,470
Infiniti IPL G 2 26,525 27,861 37,026 28,934 50,861
Infiniti I35 4 22,069 28,650 29,520 49,183 46,114
Infiniti I30 2 37,434 36,408 29,226 46,241 34,531
Infiniti G37 2 25,365 44,259 35,209 47,980 53,045
Infiniti G25 1 29,395 34,096 31,913 43,992 45,702
Infiniti G20 5 33,810 25,263 36,068 36,814 42,659
Infiniti G 2 24,232 25,919 34,694 31,035 37,664
Infiniti FX45 3 19,665 22,592 42,265 38,253 31,455
Infiniti FX35 5 38,403 31,684 31,662 32,603 31,745
Infiniti FX 1 25,840 34,236 23,742 32,255 52,273
Infiniti EX35 4 18,300 42,013 42,044 37,897 33,063
Infiniti EX 1 23,780 21,325 38,210 44,291 37,377
Lexus SC 4 38,777 36,069 38,419 33,267 43,139
Lexus RX Hybrid 1 18,748 39,415 38,894 40,460 46,186
Lexus RX 4 24,477 25,439 40,216 32,170 32,488
Lexus MC 2 19,863 44,620 47,767 29,205 36,658
Lexus LX 1 24,926 33,224 41,617 48,552 38,791
Lexus LS (XF40) 4 18,351 42,235 29,118 42,193 31,217
Lexus LS 2 24,834 33,985 37,705 36,808 39,436
Lexus LFA 2 19,714 36,553 27,306 47,606 43,780
Lexus LF-Xh 1 26,835 44,161 25,545 35,054 47,208
Lexus IS (XE20) 5 30,357 20,082 45,910 34,594 50,085
Lexus IS 5 26,449 44,810 27,255 46,445 42,323
Lexus HS 4 29,254 25,551 37,209 46,584 52,276
Lexus GX 3 35,325 39,645 39,104 28,699 40,681
Lexus GS 3 25,643 30,560 44,655 26,871 49,471
Lexus ES (XV40) 2 33,281 35,681 45,100 25,530 52,046
Lexus ES 1 23,992 20,414 25,843 39,256 32,250
Lexus CT 3 36,331 29,386 33,579 25,389 32,915
Lincoln Versailles 3 25,093 27,383 30,596 32,617 51,747
Lincoln Town Car 4 23,327 21,264 33,994 35,263 34,625
Lincoln Navigator 3 32,079 39,918 29,038 34,619 50,134
Lincoln MKZ 4 18,970 30,788 28,645 39,331 49,806
Lincoln MKX 1 26,875 24,813 29,913 48,755 36,056
Lincoln MKT 1 22,283 40,019 35,097 42,084 31,712
Lincoln MKS 3 33,614 21,078 35,573 27,122 54,772
Lincoln MKR 3 32,222 29,628 25,321 25,129 33,643
Lincoln Mark VIII 2 29,042 22,826 27,913 29,744 44,167
Lincoln Mark series 1 31,041 44,114 43,517 27,533 47,915
Lincoln Mark LT 5 24,418 25,818 26,370 44,389 31,142
Lincoln LS 3 25,548 30,950 27,412 41,408 54,800
Lincoln Lincoln-Zephyr Continental 4 29,721 44,778 45,060 46,596 54,597
Lincoln L-series 2 29,563 35,997 38,672 36,857 30,706
Lincoln K-series 1 34,594 41,877 39,498 29,858 45,748
Lincoln Custom 5 39,629 26,613 47,339 26,449 49,037
Lincoln Cosmopolitan 4 23,960 44,148 44,789 29,413 32,091
Lincoln Continental Mark VII 4 35,144 37,470 37,462 45,287 31,880
Lincoln Continental Mark V 4 25,768 33,032 24,926 34,226 38,014
Lincoln Continental 4 34,314 42,523 41,292 27,989 47,290
Lincoln Capri 2 20,059 41,351 25,801 26,875 34,963
Lincoln Blackwood 3 25,229 26,267 34,504 28,028 49,647
Lincoln Aviator 3 30,626 25,947 23,236 42,166 43,705
Lincoln 1 25,006 23,922 37,663 40,915 33,957
Mercedes-Benz W31 4 21,754 22,977 30,400 34,718 53,427
Mercedes-Benz W221 1 30,193 30,114 47,389 44,918 43,585
Mercedes-Benz W219 5 20,044 39,776 29,372 34,109 46,664
Mercedes-Benz W212 5 31,465 25,227 24,939 34,715 36,098
Mercedes-Benz W201 1 39,565 32,318 25,952 27,777 47,958
Mercedes-Benz W164 1 36,093 33,350 44,439 36,231 46,658
Mercedes-Benz W163 Grand Prix 4 34,454 21,625 30,655 48,314 48,416
Mercedes-Benz W163 1 39,760 38,043 38,515 32,217 51,431
Mercedes-Benz W126 2 34,672 27,997 36,331 35,697 47,912
Mercedes-Benz W125 4 22,407 36,854 24,923 46,074 30,570
Mercedes-Benz W124 3 34,234 20,728 33,983 42,305 39,019
Mercedes-Benz W123 1 34,555 39,413 35,089 41,614 46,128
Mercedes-Benz W120 4 31,301 26,733 38,570 30,296 49,313
Mercedes-Benz W114 5 30,737 31,440 45,877 35,374 37,955
Mercedes-Benz W112 4 38,664 22,274 30,291 40,279 51,592
Mercedes-Benz W111 1 38,573 34,080 45,239 33,891 33,644
Mercedes-Benz W108 2 26,032 24,467 34,725 29,930 38,347
Mercedes-Benz W10 1 36,998 37,243 43,170 27,264 45,104
Mercedes-Benz Vito 2 24,815 41,773 30,459 30,708 38,761
Mercedes-Benz Viano 3 22,838 41,119 37,466 43,469 40,661
Mercedes-Benz Vaneo 2 20,684 26,228 31,838 28,036 48,626
Mercedes-Benz V-Class 5 29,780 21,951 43,394 43,062 35,164
Mercedes-Benz Stuttgart 260 1 39,142 38,517 24,825 41,905 46,190
Mercedes-Benz Stuttgart 200 3 25,688 44,369 41,639 31,733 36,262
Mercedes-Benz SSK 5 23,644 33,348 32,914 30,216 43,514
Mercedes-Benz SS 4 22,503 20,486 41,415 43,745 30,715
Mercedes-Benz Sprinter 1 18,681 39,546 35,544 28,184 50,481
Mercedes-Benz SLS AMG 2 29,990 25,060 29,013 44,100 36,941
Mercedes-Benz SLR McLaren 5 22,992 24,441 46,718 25,326 31,640
Mercedes-Benz SLK-Class 4 25,437 36,926 31,455 44,994 32,475
Mercedes-Benz SL-Class 1 29,326 30,203 23,943 40,518 34,865
Mercedes-Benz S-Class Hybrid 5 30,000 27,604 37,023 32,888 38,507
Mercedes-Benz S-Class 1 36,019 30,828 43,094 49,184 37,915
Mercedes-Benz R129 1 29,890 20,675 35,986 42,931 47,830
Mercedes-Benz R107 and C107 3 28,297 27,829 36,101 34,802 42,882
Mercedes-Benz R-Class 1 32,632 20,214 37,925 25,822 54,189
Mercedes-Benz Mitsubishi Triton 2 32,496 38,846 23,863 25,923 36,235
Mercedes-Benz Mercedes Benz 170 V 2 24,054 38,622 33,573 47,262 48,157
Mercedes-Benz Mercedes 400 4 18,965 33,534 25,054 39,218 39,649
Mercedes-Benz Mercedes 35 hp 3 18,737 42,950 45,278 47,895 54,668
Mercedes-Benz Mercedes 28/95 2 39,968 44,530 38,263 34,582 44,953
Mercedes-Benz Mercedes 2-Litres 4 30,267 32,675 32,955 44,093 30,255
Mercedes-Benz Mannheim 370 4 27,583 27,861 47,097 36,460 47,473
Mercedes-Benz M-Class 5 39,084 37,269 31,477 42,039 39,483
Mercedes-Benz K 1 23,596 41,878 31,441 28,955 44,770
Mercedes-Benz GLK-Class 3 39,521 29,110 36,048 34,648 35,718
Mercedes-Benz GL-Class 4 34,704 33,072 26,123 30,451 49,377
Mercedes-Benz G-Class 3 26,577 35,736 44,095 49,058 42,719
Mercedes-Benz F-CELL Roadster 2 39,377 22,342 40,157 49,803 43,811
Mercedes-Benz F-Cell 4 20,873 27,415 45,692 38,084 50,058
Mercedes-Benz E-Class 5 19,484 40,852 32,221 38,251 39,703
Mercedes-Benz CLS-Class 1 34,644 42,106 40,849 49,770 37,867
Mercedes-Benz CLK-Class 1 25,527 23,121 45,652 32,238 47,795
Mercedes-Benz CLK GTR 4 38,041 33,772 43,876 34,734 38,568
Mercedes-Benz CLC-Class 5 30,937 29,998 41,490 27,368 45,052
Mercedes-Benz CL-Class 3 23,256 40,757 41,965 36,034 31,921
Mercedes-Benz C63 AMG Sedan 1 35,221 40,997 29,660 49,939 34,510
Mercedes-Benz C300 Sport 4MATIC 3 21,513 44,801 32,370 33,850 37,994
Mercedes-Benz C300 Sport 1 25,475 28,754 39,891 49,321 37,632
Mercedes-Benz C300 Luxury 4MATIC 1 39,379 29,306 29,098 45,657 35,669
Mercedes-Benz C300 Luxury 3 36,545 20,972 37,980 36,717 32,344
Mercedes-Benz C-Class 350 Sport 2 38,274 33,468 35,777 34,986 31,343
Mercedes-Benz C-Class 2 34,885 34,902 37,697 30,807 34,063
Mercedes-Benz Benz Velo 4 27,411 27,887 46,244 26,610 50,248
Mercedes-Benz Benz Tropfenwagen 4 18,466 22,535 34,488 42,208 41,299
Mercedes-Benz Benz Patent-Motorwagen 3 26,364 38,034 26,665 46,854 47,889
Mercedes-Benz B-Class 1 38,413 36,016 28,084 38,374 33,242
Mercedes-Benz A-Class 1 28,432 32,233 28,250 49,944 38,227
Mercedes-Benz 770 1 24,799 42,676 36,432 28,797 30,172
Mercedes-Benz 600 5 32,648 29,295 28,036 43,027 53,269
Mercedes-Benz 540K 2 39,725 24,836 31,538 37,318 37,494
Mercedes-Benz 500K 1 27,456 34,416 33,055 27,217 36,966
Mercedes-Benz 450SEL 6.9 3 36,456 34,906 29,242 44,340 42,707
Mercedes-Benz 380K 2 38,344 39,574 35,912 27,093 52,749
Mercedes-Benz 370S 4 34,895 39,017 39,856 31,304 35,625
Mercedes-Benz 320 3 34,869 20,241 29,706 49,304 33,605
Mercedes-Benz 300SL 5 35,957 22,566 25,254 39,381 43,872
Mercedes-Benz 300D 1 37,328 44,050 42,169 43,593 51,760
Mercedes-Benz 290 2 34,141 20,795 27,064 36,095 45,205
Mercedes-Benz 260 D 5 38,194 44,560 30,046 48,008 37,494
Mercedes-Benz 230 1 26,553 39,110 47,733 38,812 48,244
Mercedes-Benz 200 Lang 5 33,606 37,369 39,465 40,534 54,578
Mercedes-Benz 200 5 39,977 25,753 30,306 43,578 52,345
Mercedes-Benz 190SL 4 18,442 22,065 41,740 32,659 49,983
Mercedes-Benz 170 H 3 23,281 27,546 26,045 33,118 37,150
Mercedes-Benz 150 1 19,568 31,625 41,280 33,574 50,104
Mercedes-Benz 130 1 32,245 28,869 46,667 37,051 40,167
Nissan Xterra 4 32,663 39,545 47,602 32,366 40,828
Nissan X-Trail 3 39,796 22,793 32,958 42,343 40,920
Nissan Wingroad 3 27,368 25,121 31,872 31,389 44,576
Nissan Versa 2 27,109 40,881 38,631 40,403 43,779
Nissan Vanette 3 39,321 25,151 37,625 27,809 44,066
Nissan Ute 1 36,394 42,957 39,804 28,434 37,748
Nissan Titan 3 25,894 29,712 36,542 40,780 34,997
Nissan Tiida 3 30,293 39,649 28,711 32,122 51,134
Nissan Terrano II 2 39,867 36,386 34,332 36,905 54,127
Nissan Teana 1 36,759 22,241 47,219 44,813 36,346
Nissan Sunny 3 29,867 34,662 25,674 39,557 32,342
Nissan Stanza 4 39,905 38,808 23,735 39,131 39,202
Nissan Stagea 4 19,980 43,066 30,348 32,295 42,045
Nissan Skyline GT-R 3 29,989 24,037 31,456 32,982 36,050
Nissan Skyline 3 37,658 30,234 29,512 36,897 44,650
Nissan Silvia 4 30,115 23,386 45,223 25,814 45,572
Nissan Sileighty 4 22,483 32,741 34,794 25,777 52,258
Nissan Serena 3 36,985 34,966 35,631 27,475 53,521
Nissan Sentra 2 34,198 39,430 37,984 33,275 37,694
Nissan Saurus Jr. 2 20,898 29,008 24,907 35,026 33,504
Nissan Saurus 3 18,844 23,801 32,635 36,597 53,359
Nissan S30 2 23,971 39,058 40,855 39,089 48,408
Nissan S-Cargo 1 20,626 42,944 38,185 32,704 38,467
Nissan Rogue 2 19,745 25,690 23,032 35,232 50,747
Nissan Rasheen 1 38,626 20,730 35,351 43,049 45,939
Nissan R90C 5 35,929 23,564 41,107 33,613 41,776
Nissan R89C 5 29,247 40,856 35,310 33,650 53,134
Nissan R391 1 33,894 39,232 24,385 40,656 49,665
Nissan R390 GT1 5 26,982 31,368 30,456 28,761 34,179
Nissan R383 1 20,812 27,098 40,488 46,987 50,436
Nissan R382 1 22,416 32,075 44,930 26,669 51,670
Nissan R381 4 18,701 28,437 29,512 44,285 49,873
Nissan R'nessa 4 28,041 32,256 45,945 46,312 47,894
Nissan Quest 4 25,712 33,193 27,303 25,978 30,353
Nissan Qashqai 3 39,190 21,736 31,462 46,133 30,476
Nissan Pulsar GTI-R 2 27,998 28,852 28,095 48,990 49,501
Nissan Pulsar 1 27,878 37,981 44,543 29,252 39,548
Nissan Prince Royal 1 22,428 33,011 29,781 37,059 36,782
Nissan Prince R380 3 38,343 26,921 24,946 25,097 30,113
Nissan Prince Homer 5 37,966 39,107 36,720 47,955 48,427
Nissan Primera 1 25,472 42,291 37,230 39,219 52,471
Nissan Primastar 4 30,579 26,910 39,144 29,621 50,979
Nissan President 1 28,775 27,948 28,855 32,266 49,606
Nissan Presea 5 36,295 43,039 35,531 30,339 54,438
Nissan Presage 4 36,254 32,751 42,526 25,910 50,407
Nissan Prairie 5 39,464 40,693 30,660 42,231 43,003
Nissan Patrol 3 30,431 42,411 23,964 25,192 45,367
Nissan Pathfinder 4 37,292 39,053 31,067 30,361 38,627
Nissan Pao 1 24,583 44,315 40,959 42,696 38,227
Nissan Paladin 1 29,284 42,938 30,189 33,176 45,914
Nissan P35 5 36,727 20,062 32,079 41,067 50,773
Nissan NX 4 23,083 39,677 43,691 37,439 50,635
Nissan NPT-90 4 32,483 38,220 27,846 46,872 35,444
Nissan Note 3 21,948 20,556 40,463 26,204 50,540
Nissan Navara 1 18,554 30,020 43,655 33,651 54,180
Nissan Murano 4 28,925 24,419 42,940 35,555 45,243
Nissan Micra 4 38,540 38,917 44,178 47,010 54,197
Nissan Maxima 2 28,529 30,975 39,638 25,557 32,532
Nissan Livina Geniss 1 30,820 32,932 40,158 37,906 52,076
Nissan Liberty 3 24,808 32,104 31,158 36,799 44,059
Nissan Leopard 1 29,733 44,090 36,767 48,185 43,488
Nissan Leaf 4 34,086 25,986 29,978 40,868 54,827
Nissan Laurel 2 30,071 33,629 43,738 31,306 43,985
Nissan Largo 5 29,924 38,323 46,972 42,257 37,806
Nissan Lafesta 3 32,561 38,616 47,456 25,935 49,039
Nissan JUKE 5 27,518 42,023 30,647 37,904 42,056
Nissan Hypermini 1 25,555 27,573 29,388 45,269 43,602
Nissan Homy 2 24,921 39,454 30,734 47,684 30,071
Nissan Hardbody Truck 5 36,043 44,599 24,890 28,529 53,821
Nissan GTP ZX-Turbo 5 27,309 42,122 35,506 34,724 53,666
Nissan GT-R 3 37,248 43,321 41,628 46,150 34,456
Nissan Gloria Y31 1 24,897 27,354 33,356 25,810 30,306
Nissan Gloria 5 35,929 22,248 46,000 39,024 49,056
Nissan Gazelle 5 26,529 27,396 35,639 47,505 33,992
Nissan Fuga 2 23,432 37,842 30,785 42,512 50,706
Nissan Figaro 5 30,020 44,922 44,856 33,795 52,652
Nissan Elgrand 2 20,356 43,494 28,190 43,173 52,948
Nissan Diesel Space Runner RP 2 38,428 40,077 42,509 42,191 37,510
Nissan Diesel Space Runner RM 4 21,890 37,701 36,442 31,036 45,637
Nissan Diesel Space Runner JP 4 18,349 38,038 46,856 27,587 48,067
Nissan Diesel RN 1 39,640 22,425 38,782 32,464 48,183
Nissan Diesel Quon 2 21,220 34,679 41,840 28,171 35,179
Nissan Diesel Condor 1 19,401 23,402 37,496 28,274 47,266
Nissan Diesel Big Thumb 2 30,757 28,404 23,082 41,687 50,780
Nissan Datsun/Nissan Z-car 1 23,765 23,199 45,901 48,912 49,679
Nissan Cube 3 21,054 25,576 41,999 26,036 38,543
Nissan Crew 1 19,458 34,529 24,246 31,267 51,367
Nissan Civilian 5 24,866 44,356 43,390 46,846 40,758
Nissan Cima 5 21,911 25,152 39,867 32,341 31,827
Nissan Cherry 3 35,838 34,599 44,741 49,320 34,406
Nissan Cefiro 5 23,209 34,464 40,292 34,842 44,200
Nissan Cedric Y31 2 35,770 31,661 43,557 30,556 51,904
Nissan Cedric 3 34,346 37,498 47,420 37,483 44,507
Nissan Caravan 3 29,495 22,186 26,247 29,374 49,764
Nissan Bluebird Sylphy 1 39,932 38,036 38,195 30,378 47,765
Nissan Bluebird (U12) 2 28,395 20,408 31,590 39,067 32,512
Nissan Bluebird 1 31,756 24,337 39,792 25,858 53,926
Nissan Bevel 2 18,494 20,772 35,060 47,434 35,937
Nissan Be-1 4 23,920 31,296 27,947 35,167 43,743
Nissan Bassara 2 21,621 40,510 31,319 36,101 42,916
Nissan Avenir 2 22,786 30,591 31,887 34,699 52,052
Nissan Atlas 1 30,227 39,552 47,687 25,134 50,700
Nissan Armada 5 24,831 25,737 45,507 49,041 49,455
Nissan Altra 4 30,731 29,707 29,500 44,776 42,150
Nissan Altima 1 25,963 44,352 27,435 31,217 35,815
Nissan Almera Tino 2 30,358 31,839 34,088 38,024 31,076
Nissan Almera 5 32,593 40,049 23,438 46,170 42,075
Nissan 370Z 5 27,068 29,219 38,653 34,552 54,815
Nissan 350Z 3 21,666 29,289 29,556 46,212 46,263
Nissan 300ZX 4 24,727 29,825 37,664 38,708 42,019
Nissan 300C 5 18,780 30,087 33,277 25,468 38,608
Nissan 280ZX 1 28,781 29,682 39,100 41,635 44,261
Nissan 240SX 1 31,839 20,556 31,177 32,438 40,585
Nissan 200SX 1 35,015 40,364 30,606 43,809 47,318
Nissan 180SX 3 31,090 35,501 38,015 44,262 34,980
Subaru XT 1 20,746 25,319 45,586 39,290 40,502
Subaru Vivio 3 30,623 42,141 25,358 25,031 48,845
Subaru Tribeca 4 39,043 36,057 39,315 31,526 48,654
Subaru Sumo 2 23,140 29,966 24,202 33,733 38,057
Subaru Stella 3 21,097 40,586 24,480 32,627 32,400
Subaru Sambar 3 25,896 28,145 38,941 25,919 32,826
Subaru Rex 5 23,587 41,090 28,147 44,919 34,160
Subaru R2 1 35,556 31,931 42,242 33,895 39,154
Subaru R1e 1 21,869 20,722 24,871 31,724 50,333
Subaru R1 3 24,699 44,947 36,644 31,397 50,192
Subaru R-2 3 21,279 39,199 42,615 35,449 36,754
Subaru Pleo 4 23,791 35,241 30,999 39,865 50,266
Subaru Outback 1 31,491 40,303 25,359 45,325 53,528
Subaru Loyale 1 29,771 44,105 33,091 42,639 44,862
Subaru Leone 2 27,235 31,863 44,795 37,069 52,860
Subaru Legacy 2 30,091 37,421 29,858 27,465 30,912
Subaru Justy 1 34,712 28,867 40,116 39,937 33,088
Subaru Impreza WRX WRP10 4 36,846 24,915 39,365 29,712 36,853
Subaru Impreza WRX STI 3 34,116 30,540 41,169 42,438 40,479
Subaru Impreza WRX 3 30,665 42,572 31,111 29,923 33,446
Subaru impreza RB5 5 28,627 25,472 46,209 46,834 38,712
Subaru Impreza RB320 3 25,524 25,355 41,212 31,415 37,077
Subaru Impreza 1 18,217 23,496 26,619 39,567 45,672
Subaru G 2 28,574 31,213 46,069 29,743 31,660
Subaru Forester 4 20,981 35,765 23,091 43,296 30,432
Subaru FF-1 Star 4 32,428 20,057 34,618 29,989 46,868
Subaru Exiga 1 33,024 40,503 30,196 39,213 43,038
Subaru BRAT 1 26,744 30,816 45,909 48,417 39,048
Subaru Baja 2 38,122 26,999 43,236 32,225 44,885
Subaru B9sc 4 26,160 38,326 46,516 29,494 52,163
Subaru B9 Scrambler 2 22,435 25,894 37,758 49,826 32,303
Subaru Alcyone SVX 4 30,253 34,309 25,756 38,543 50,470
Subaru 360 5 38,323 25,582 28,031 26,763 30,950
Subaru 1500 3 20,579 32,820 41,194 41,959 44,891
Subaru 1000 1 35,315 24,187 28,989 39,425 52,489
Toyota Yaris Verso 5 28,078 26,303 30,433 42,110 32,763
Toyota Yaris 2 27,115 43,467 30,163 25,192 51,702
Toyota WISH 5 22,871 25,333 39,403 39,970 51,162
Toyota WiLL 3 30,758 36,904 27,815 27,261 34,943
Toyota Voltz 4 30,949 42,059 37,533 29,044 44,929
Toyota Volkswagen Taro 4 28,189 28,371 34,004 30,406 30,168
Toyota Vitz 2 25,761 36,297 38,305 45,610 46,144
Toyota Vista 3 20,322 39,802 35,607 26,877 49,888
Toyota Vios 5 24,167 24,794 39,950 29,129 52,340
Toyota Verossa 3 23,340 41,421 42,711 27,265 44,192
Toyota Venza 2 24,150 34,164 42,847 42,755 37,012
Toyota Vanguard 4 20,374 25,626 46,382 28,596 31,329
Toyota Tundra 4 30,109 20,350 40,130 25,509 47,926
Toyota TS010 4 25,649 34,864 35,876 48,287 39,920
Toyota Trekker 3 31,859 23,127 29,724 35,752 43,848
Toyota TownAce 2 31,379 38,297 32,120 49,709 53,276
Toyota Tercel 3 21,753 32,509 25,850 46,267 50,195
Toyota Tacoma 2 36,761 23,664 32,193 41,782 30,264
Toyota T100 4 34,543 35,719 24,294 29,465 48,238
Toyota Supra 1 28,255 36,392 46,407 27,991 34,979
Toyota Succeed 2 28,522 25,865 37,745 36,495 35,312
Toyota Stout 5 38,586 23,358 46,093 26,498 31,849
Toyota Starlet GT Turbo 3 18,688 40,905 39,406 48,387 51,298
Toyota Starlet Glanza 5 27,616 27,792 34,484 41,409 54,763
Toyota Starlet 1 18,453 29,983 47,112 37,826 37,690
Toyota Sprinter 2 33,212 37,792 39,292 43,666 43,817
Toyota Sports 800 1 26,407 41,455 32,994 45,676 54,438
Toyota Sportivo Coupe 1 32,387 35,739 26,452 28,758 35,961
Toyota Soarer 5 23,303 20,987 34,312 32,687 51,980
Toyota Sienta 3 20,459 35,841 23,389 28,327 34,894
Toyota Sienna 4 26,939 26,251 25,642 42,374 40,454
Toyota Sera 2 25,629 20,270 30,853 48,134 50,654
Toyota Sequoia 1 33,914 27,485 30,763 43,539 41,949
Toyota Scion xB 3 22,237 31,273 39,891 44,126 51,930
Toyota Scion xA 1 36,052 36,323 43,009 27,101 39,727
Toyota SA 2 36,877 27,484 38,074 33,642 41,072
Toyota RSC 5 19,928 22,887 26,267 29,653 54,222
Toyota Revo 5 19,079 42,402 40,175 38,949 36,098
Toyota Regius 1 31,734 34,551 37,040 37,721 35,736
Toyota RAV4 EV 2 32,144 23,094 46,552 25,712 48,083
Toyota RAV4 3 34,445 44,453 27,047 42,683 36,605
Toyota Raum 3 19,707 31,206 30,195 40,850 51,766
Toyota Ractis 5 32,400 33,943 40,226 40,189 54,331
Toyota QuickDelivery 2 19,857 42,846 41,247 29,857 32,339
Toyota Publica 2 32,356 28,355 34,404 39,446 31,534
Toyota Progrès 3 38,302 23,518 32,876 48,336 31,515
Toyota Probox 4 26,243 38,898 24,982 37,162 47,888
Toyota Prius v 5 19,552 33,785 47,573 37,588 36,413
Toyota Prius Plug-in Hybrid 5 30,317 32,124 36,604 40,812 51,034
Toyota Prius 1 29,874 35,681 30,978 27,610 35,238
Toyota Previa 2 37,762 28,097 34,827 44,521 37,197
Toyota Premio 1 31,654 26,233 35,931 48,061 32,065
Toyota Porte 5 26,299 22,132 29,150 26,599 44,223
Toyota Pontiac Vibe 3 25,797 39,213 46,939 40,031 46,944
Toyota Pod 3 19,940 30,699 41,498 43,695 51,427
Toyota Platz 3 31,463 41,753 35,794 43,347 51,737
Toyota Paseo 5 26,874 30,063 31,757 49,369 35,029
Toyota Origin 4 34,291 40,415 37,698 30,764 52,614
Toyota Opa 3 31,887 34,432 25,939 46,601 35,076
Toyota Noah 2 28,601 29,008 39,742 28,323 30,679
Toyota MR2 3 24,122 31,731 40,917 39,809 46,286
Toyota Motor Triathlon Race Car 3 33,307 33,559 35,398 26,526 46,132
Toyota Mega Cruiser 1 38,087 33,384 41,560 48,663 32,898
Toyota Matrix 5 29,413 20,864 39,465 47,615 32,612
Toyota MasterAce 2 20,827 39,325 43,053 36,808 32,657
Toyota Mark X ZiO 4 18,064 37,349 39,466 44,245 46,502
Toyota Mark X 4 32,597 43,386 44,330 36,668 37,747
Toyota Mark II Blit 2 21,354 31,973 36,735 30,940 42,887
Toyota Mark II 1 29,540 33,499 34,173 27,603 37,874
Toyota LiteAce 3 19,124 33,755 40,346 38,031 32,723
Toyota Limo 3 20,337 26,320 39,571 48,113 30,755
Toyota Lexus SC 4 22,772 40,833 29,779 28,048 36,448
Toyota Lexus LS 4 26,513 30,488 30,975 40,469 35,099
Toyota Lexus ES 2 19,284 23,605 35,423 46,885 49,207
Toyota Land Cruiser Prado 3 38,680 41,717 24,005 25,867 42,728
Toyota Land Cruiser 5 33,678 37,529 45,362 44,266 38,432
Toyota Kijang 1 21,290 42,570 23,793 41,405 42,657
Toyota ist 5 28,505 29,654 26,156 34,423 44,768
Toyota Isis 3 33,860 21,394 47,624 34,925 36,940
Toyota iQ 3 25,563 24,750 38,273 41,627 46,761
Toyota Ipsum 1 27,929 21,900 27,668 43,111 35,729
Toyota Innova 5 26,280 29,927 46,214 36,166 42,226
Toyota i-unit 3 24,302 24,649 26,983 29,425 32,455
Toyota Hybrid X 3 39,490 20,601 36,181 29,481 41,817
Toyota Hilux Surf 5 37,501 38,078 45,709 28,718 49,140
Toyota Hilux 1 37,107 20,352 26,109 30,907 53,678
Toyota Highlander 4 35,062 33,147 37,253 25,186 35,823
Toyota HiAce 5 37,669 38,316 44,979 28,316 34,863
Toyota GT-One 5 38,542 41,615 31,121 39,099 45,266
Toyota Granvia 3 36,821 31,653 29,267 37,932 48,332
Toyota Grand Hiace 5 28,802 33,756 41,539 38,542 48,253
Toyota Gaia 3 38,830 34,759 43,998 40,792 50,978
Toyota G1 1 25,923 36,242 39,920 43,404 40,854
Toyota FTX 2 39,396 31,951 46,258 26,907 43,310
Toyota FT-HS 5 28,842 23,393 38,812 41,241 53,222
Toyota Fortuner 3 37,403 23,334 27,985 47,602 40,352
Toyota FJ Cruiser 2 24,878 44,806 41,560 36,617 31,545
Toyota eCom 5 38,790 39,406 24,864 48,264 46,552
Toyota Dyna 4 39,964 39,386 29,773 33,031 31,038
Toyota Daihatsu Applause 4 32,080 43,098 44,937 48,993 47,771
Toyota Curren 3 35,762 23,363 37,326 37,431 42,572
Toyota Crown Majesta 5 36,588 24,646 25,838 31,255 34,513
Toyota Crown Comfort LPG 4 18,997 40,345 45,949 28,292 47,931
Toyota Crown Comfort 2 30,731 44,692 31,732 40,533 30,008
Toyota Crown 5 24,119 31,386 44,302 37,102 34,007
Toyota Cresta 5 19,245 20,206 43,434 39,524 37,005
Toyota Cressida 1 37,221 26,276 37,117 48,078 33,676
Toyota Corona EXiV 3 27,731 22,768 23,469 40,845 53,502
Toyota Corona 1 21,203 38,694 45,096 36,233 48,125
Toyota Corolla Verso 1 31,317 29,324 45,566 32,651 45,404
Toyota Corolla 5 33,199 42,674 39,446 49,880 53,234
Toyota Comfort 3 33,034 31,094 32,983 39,204 51,956
Toyota Coaster 2 33,485 37,082 35,839 40,741 34,598
Toyota Classic 5 27,516 39,979 47,825 29,929 34,092
Toyota Chaser 3 39,186 40,603 30,884 34,639 54,713
Toyota Century 2 21,107 21,490 23,081 44,474 46,941
Toyota Celica XX 4 35,991 43,938 31,836 37,220 48,307
Toyota Celica GT-Four 5 39,403 22,276 36,050 48,933 52,127
Toyota Celica 2 30,452 33,134 33,360 40,785 42,560
Toyota Carina II 2 39,739 35,355 46,534 46,700 38,393
Toyota Carina ED 4 37,769 31,495 41,954 45,234 48,698
Toyota Carina 5 36,186 33,030 30,797 29,356 41,301
Toyota Camry TS-01 5 22,516 29,514 32,918 43,830 35,419
Toyota Camry Solara 1 19,698 27,594 40,989 25,410 49,344
Toyota Camry Hybrid 2 38,034 35,524 39,347 46,779 34,487
Toyota Camry 5 25,406 28,491 39,208 32,601 45,880
Toyota Caldina 2 34,661 23,594 43,506 25,053 45,816
Toyota Brevis 1 39,810 40,077 40,602 34,854 54,656
Toyota Belta 2 25,710 44,677 39,796 28,796 39,394
Toyota bB 2 38,298 24,135 47,610 42,037 39,787
Toyota Aygo 5 19,944 21,266 47,687 43,546 52,667
Toyota Avensis 2 21,941 20,832 38,655 48,324 50,350
Toyota Avalon 4 33,001 23,568 31,554 40,139 53,554
Toyota Auris 5 24,708 39,898 28,554 31,413 37,839
Toyota Aurion 2 21,520 21,177 47,357 44,602 53,183
Toyota Alphard 2 28,631 26,071 27,021 38,962 41,929
Toyota Allion 3 29,270 32,404 44,015 38,614 44,437
Toyota AE85 4 29,577 36,827 34,544 42,130 46,581
Toyota AA 3 18,049 25,009 46,051 44,908 48,166
Toyota 4Runner 4 32,167 29,863 38,002 25,618 43,589
Toyota 4500GT 2 38,863 23,226 46,805 45,380 47,231
Toyota 2000GT 5 18,659 22,665 24,785 29,449 50,373

Part 2 Action Plan

Action Plan
What do you hope to achieve by visualizing and communicating insights using data? What workplace problem do you think this will help you address? In this part of the course project, you will create an action plan that will guide your efforts.
Complete the grid below.
Key Business Problem(s) Identify the key problem you hope to address by communicating visual information through Excel.
Strategies Which strategies or functions from the course will you use to help you achieve your goal?
Steps What are the specific actions you will take? Be as specific as you can in outlining what you will do.
Timeline Identify a timeline for implementation. What will you do (or will you have your team do) in the next month? What will you have completed over the next quarter?
Measurement/Results How are you going to measure your results or demonstrate that your efforts have had a positive impact? Outline your measurement strategies here.
Graphical Integrity How will you incorporate Professor Haeger's guidelines for ensuring graphical integrity?

Part 3 Instructions

Part 3 Instructions
1 The US Census Bureau would like to examine population trends between different regions. Using the data collected in the "Region Population (Historical)" sheet, insert both a stacked and a 100% stacked column chart containing columns by year. Include titles or legends as appropriate.
2 The Bureau is trying to decide the future of population growth by age group. The second sheet, "Age Population (historical)," contains information on the percentage of the US population that falls within selected age groups. Use the data to create three charts: a line chart, a stacked line chart, and a 100% stacked line chart. Place the charts below the data in the same worksheet and label appropriately.
3 The "Metropolitan Pop (2007-12)" worksheet provides information on the population growth of the ten most populous metropolitan areas. Generate three charts—a column chart, bar chart, and line chart—that summarize the data, making sure to include titles if needed. Place the preferred chart in a new worksheet called "By Metropolitan Area" and the other two charts below the data. Move the new sheet immediately after the sheet containing the original data.
4 You would like to put together a pie chart for 2007-08. Insert a pie of pie chart with a cutoff of fields with a population of fewer than 5,000,000 being relegated to the smaller pie. The bigger pie pieces should appear in order by population number. Use the "point explosion" feature to offset the combined pie segment. Move the chart to its own worksheet, entitled "Pie of Pie," and place it immediately after the "By Metropolitan Area" sheet.
5 Insert a bar of pie chart for 2008-09 with the same cutoff and point explosion mentioned above. Move the chart to its own worksheet, entitled "Bar of Pie" and place the sheet immediately after the "Pie of Pie" sheet.
6 The "Fast Growing Pop (2007-12)" worksheet provides information on the population growth of the ten fastest-growing metropolitan areas. The Bureau is interested in the long-term trends in population growth for these areas. Sparklines provide a quick look at the major trends in data. Insert two different forms of sparkline, one set in the row below the data (Row 13) contrasting areas within a year, and the other immediately to the right in column G comparing an area through the period of years. Choose the most appropriate sparkline. Include both high point and low point markers for any line sparklines.
7 The three fastest-growing areas are Palm Coast, St. George, and Las Vegas. To quickly visualize national changes in these three areas between 2007 and 2012, insert a doughnut chart containing only those fields in those specific years. Include a legend and chart title that makes the content clear. Place the chart to the right of the data.

Region Population (Historical)

United States Population by Region
Region: 2000 2005 2010 2015
Northeast 53,666,295 54,451,230 55,387,174 56,283,891
Midwest 64,491,431 65,751,872 66,977,505 67,907,403
West 63,439,136 67,833,726 72,119,326 76,044,679
South 100,565,549 107,479,771 114,862,858 121,182,847

Age Population (Historical)

Population by Age Groups
Age 2013 2014 2015 2016
Under 18 26% 24% 25% 21%
18-24 10% 10% 11% 11%
25-44 30% 27% 25% 29%
45-64 22% 26% 24% 23%
65 and over 12% 13% 15% 16%
Total 100% 100% 100% 100%

Metropolitan Pop (2007-12)

Population Growth for the Ten Most Populous Metropolitan Areas
Area 2007-08 2008-09 2009-10 2010-11 2011-12
NY 17,596,302 17,692,920 18,093,431 18,323,002 18,897,109
LA 11,302,592 11,903,932 12,265,627 12,365,627 12,828,837
Chicago 8,403,029 8,502,921 8,705,240 9,098,316 9,461,105
Dallas 4,503,677 4,982,281 5,075,893 5,161,544 6,371,773
Philadelphia 5,057,709 5,209,391 5,402,182 5,687,157 5,965,343
Houston 4,715,407 4,931,215 5,528,076 5,840,192 5,946,800
DC 4,294,946 4,201,391 4,503,923 4,796,183 5,582,170
Miami 4,201,586 4,240,395 4,830,482 5,007,564 5,564,635
Atlanta 3,850,381 3,940,281 4,038,281 4,247,981 5,268,860
Boston 3,945,671 4,028,643 4,289,521 4,391,344 4,552,402

Fast Growing Pop (2007-12)

Population Growth for the Ten Fastest-Growing Areas
Area 2007-08 2008-09 2009-10 2010-11 2011-12
Palm Coast 49,832 55,928 60,918 73,043 95,696
St. George 90,354 92,121 95,104 120,958 138,115
Las Vegas 1,375,765 1,602,945 1,830,992 1,805,692 1,951,269
Raleigh-Cary 797,071 940,292 105,381 107,382 1,130,490
Cape Coral 440,888 490,192 592,033 601,855 618,754
Provo-Orem 376,774 402,921 438,012 463,828 526,810
Greeley 180,926 183,023 200,492 204,291 252,825
Austin 1,249,763 1,492,021 1,582,039 1,730,921 1,716,289
Myrtle Beach 196,629 209,921 229,406 246,986 269,291
Bend 115,367 134,940 153,022 142,103 157,733