Create pivot tables

User Generated

unlqra69sna

Business Finance

Description

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 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 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.

(see attached)

Unformatted Attachment Preview

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

Explanation & Answer

The Excel File and accompanying word fi...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags