Visualizing And Communicating In Excel

See uploaded file

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