Automotive Angels - References
Contents
References
1 Pudaruth, S. (2014). Predicting the Price of Used Cars using Machine Learning Techniques. International Journal of Information & Computation Technology, 4(7), 753-764. Retrieved March 29, 2017, from http://www.ripublication.com/irph/ijict_spl/ijictv4n7spl_17.pdf
2 Peerun S., Chummun N.H., Pudaruth, S. (2015) Predicting the Price of Second-hand Cars using Artificial Neural Networks. Retrieved April 01, 2017, from https://www.academia.edu/13579173/Predicting_the_Price_of_Second-hand_Cars_using_Artificial_Neural_Networks
3 D. (2017, February 14). Car Price Prediction. Retrieved March 28, 2017, from https://github.com/dkeske/CarPrice
4 Chen, P. (2015, March 22). Predicting Car Prices Part 1: Linear Regression. Retrieved March 28, 2017, from http://www.datasciencecentral.com/profiles/blogs/predicting-car-prices-part-1-linear-regression
5 Hirsh, E., Hedlund, S., & Schweizer, M. (2003, November 30). Reality Is Perception: The Truth about Car Brands. Retrieved April 03, 2017, from https://www.strategy-business.com/article/03302?gko=fbb50
6 MarketLine Advantage (February 2017). MarketlLine Industry Profile Automotive Aftermarket in the United States
7 Biostatistics. (2006). www.biostat.jhsph.edu. Retrieved 7 February 2017, from http://www.biostat.jhsph.edu/~iruczins/teaching/jf/ch10.pdf
8 Tibshirani, R. (1996). Regression shrinkage and selection via the lasso. J. Royal. Statist. Soc B., Vol. 58, No. 1, pages 267-288)
9 Sarma, K. (n.d.). Predictive modeling with SAS Enterprise Miner. 1st ed. SAS Publishing.
10 Kadane, J., & Lazar, N. (2008). Methods and Criteria for Model Selection (1st ed.). Carnegie Mellon University Department of Statistics. Retrieved from https://www.cs.cmu.edu/~tom/10-702/tr759.pdf
11 Ag, B. (2017, January 20). CLAIMS YOUR TERRITORY. Retrieved February 07, 2017, from http://www.bmw.com/com/en/newvehicles/mseries/overview.html
12 List of Chevrolet vehicles. (2017, March 10). Retrieved February 07, 2017, from https://en.wikipedia.org/wiki/List_of_Chevrolet_vehicles#Current_production_vehicles_.28North_America.29
13 List of Ford vehicles. (2017, March 22). Retrieved February 07, 2017, from https://en.wikipedia.org/wiki/List_of_Ford_vehicles
14 G. (2016, March 21). Most (and Least) Expensive States to Own a Car. Retrieved February 1, 2017, from http://www.huffingtonpost.com/gobankingrates/most-and-least-expensive_b_9516846.html
Appendix
Exploratory Data Analysis for Ford and Chevrolet
Figure 16: Scatterplot of Current Selling Price and Current Suggested Retail Price for Ford
Figure 17: Scatterplot of Current Selling Price and Current Suggested Retail Price for Chevrolet
Figure 18: Parameter estimates based on fit of least squares for Ford
Figure 19: Parameter estimates based on fit of least squares for Chevrolet
Figure 20: Map of Ford Dealers’ locations by Number of Listings
Figure 21: Map of Chevrolet Dealers’ locations by Number of Listings
Figure 22: Box Plot of Current Selling Price by Corrected Vehicle Model for Ford
Figure 23: Box Plot of Current Selling Price by Corrected Vehicle Model for Chevrolet
Figure 24: Table of Corrected Vehicle Models by Number of Rows and Mean of Current Selling Price for Ford
Figure 25: Table of Corrected Vehicle Models by Number of Rows and Mean of Current Selling Price for Chevrolet
Missing Value Tables
Figure 26: Before removing missing values for “Current Selling Price” (BMW)
Figure 27: After removing missing values for “Current Selling Price” (BMW)
Figure 28: Missing Values Table for “Vehicle Make” BMW
Figure 29: Before removing missing values for Current Selling Price (Ford)
Figure 30: After removing missing values for Current Selling Price (Ford)
Table 31: Missing Values Table for “Vehicle Make” Ford
Figure 32: Before removing missing values for Current Selling Price (Chevrolet)
Figure 33: After removing missing values for Current Selling Price (Chevrolet)
Figure 34: Missing Values Table for “Vehicle Make” Chevrolet
Match( :modelName, "318", "3 Series", "323", "3 Series", "325", "3 Series", "325Ic", "3 Series", "325iC", "3 Series", "328I", "3 Series", "3Series", "3 Series", "524TD AUTOMATIC", "5 Series", "525", "5 Series", "525I", "5 Series", "528I", "5 Series", "530", "5 Series", "530It Automatic", "5 Series", "535I", "5 Series", "5Series", "5 Series", "6Series", "6 Series", "735I Automatic", "7 Series", "740", "7 Series", "7Series", "7 Series", "X3 25I", "X3", "Z4M", "Z4 M", If( :modelName == "i3" | :modelName == "i8", :modelName, Titlecase( :modelName ) ) )
Figure 35: Code to rectify “Vehicle Model” (BMW)
If( Contains( Lowercase( :Vehicle Model ), "police" ), "Police Interceptor", Contains( Lowercase( :Vehicle Model ), "taurus" ), "Taurus", Contains( Lowercase( :Vehicle Model ), "escape" ), "Escape", Contains( Lowercase( :Vehicle Model ), "focus" ), "Focus", Contains( Lowercase( :Vehicle Model ), "explorer" ), "Explorer", Contains( Lowercase( :Vehicle Model ), "mustang" ), "Mustang", Contains( Lowercase( :Vehicle Model ), "f-150" ), "F-150", Contains( Lowercase( :Vehicle Model ), "tempo" ), "Tempo", Contains( Lowercase( :Vehicle Model ), "f-250" ), "F-250", Contains( Lowercase( :Vehicle Model ), "f250" ), "F-250", Contains( Lowercase( :Vehicle Model ), "econoline" ), "Econoline", Contains( Lowercase( :Vehicle Model ), "econo" ), "Econoline", Contains( Lowercase( :Vehicle Model ), "c-max" ), "C-Max", Contains( Lowercase( :Vehicle Model ), "crown victoria" ), "Crown Victoria", Contains( Lowercase( :Vehicle Model ), "crownvictoria" ), "Crown Victoria", Contains( Lowercase( :Vehicle Model ), "crown vic" ), "Crown Victoria", Contains( Lowercase( :Vehicle Model ), "club wagon" ), "Club Wagon", Contains( Lowercase( :Vehicle Model ), "conventional" ), "Conventional", Contains( Lowercase( :Vehicle Model ), "aspire" ), "Aspire", Contains( Lowercase( :Vehicle Model ), "bronco" ), "Bronco", Contains( Lowercase( :Vehicle Model ), "cab forw" ), "Cab Forw", Contains( Lowercase( :Vehicle Model ), "e-series" ), "E-Series", Contains( Lowercase( :Vehicle Model ), "escort" ), "Escort", Contains( Lowercase( :Vehicle Model ), "festiva" ), "Festiva", Contains( Lowercase( :Vehicle Model ), "e150" ), "E-150", Contains( Lowercase( :Vehicle Model ), "e250" ), "E-250", Contains( Lowercase( :Vehicle Model ), "e350" ), "E-350", Contains( Lowercase( :Vehicle Model ), "e450" ), "E-450", Contains( Lowercase( :Vehicle Model ), "escort" ), "Escort", Contains( Lowercase( :Vehicle Model ), "expedition" ), "Expedition", Contains( Lowercase( :Vehicle Model ), "f150" ), "F-150", Contains( Lowercase( :Vehicle Model ), "f100" ), "F-100", Contains( Lowercase( :Vehicle Model ), "f350" ), "F-350", Contains( Lowercase( :Vehicle Model ), "f450" ), "F-450", Contains( Lowercase( :Vehicle Model ), "f550" ), "F-550", Contains( Lowercase( :Vehicle Model ), "f650" ), "F-650", Contains( Lowercase( :Vehicle Model ), "f600" ), "F-600", Contains( Lowercase( :Vehicle Model ), "f700" ), "F-700", Contains( Lowercase( :Vehicle Model ), "f750" ), "F-750", Contains( Lowercase( :Vehicle Model ), "f800" ), "F-800", Contains( Lowercase( :Vehicle Model ), "freestar" ), "Freestar", Contains( Lowercase( :Vehicle Model ), "fusion" ), "Fusion", Contains( Lowercase( :Vehicle Model ), "probe" ), "Probe", Contains( Lowercase( :Vehicle Model ), "shelby" ), "Shelby", Contains( Lowercase( :Vehicle Model ), "super duty" ), "Super Duty", Contains( Lowercase( :Vehicle Model ), "thunderbird" ), "Thunderbird", Contains( Lowercase( :Vehicle Model ), "transit" ), "Transit", Contains( Lowercase( :Vehicle Model ), "windstar" ), "Windstar", Titlecase( :Vehicle Model ) )
Figure 36: Code to rectify “Vehicle Model” (Ford)
If( Contains( Lowercase( :modelName ), "van" ), "Van", Contains( Lowercase( :modelName ), "v20" ), "V20", Contains( Lowercase( :modelName ), "v10" ), "V10", Contains( Lowercase( :modelName ), "trax" ), "Trax", Contains( Lowercase( :modelName ), "traverse" ), "Traverse", Contains( Lowercase( :modelName ), "trailblazer" ), "TrailBlazer", Contains( Lowercase( :modelName ), "tahoe" ), "Tahoe", Contains( Lowercase( :modelName ), "suburban2500" ), "Suburban", Contains( Lowercase( :modelName ), "suburban1500" ), "Suburban", Contains( Lowercase( :modelName ), "suburban 2500" ), "Suburban", Contains( Lowercase( :modelName ), "suburban 20" ), "Suburban", Contains( Lowercase( :modelName ), "suburban 1500" ), "Suburban", Contains( Lowercase( :modelName ), "suburban 10" ), "Suburban", Contains( Lowercase( :modelName ), "sportvan" ), "Sportvan", Contains( Lowercase( :modelName ), "spark" ), "Spark", Contains( Lowercase( :modelName ), "sonic" ), "Sonic", Contains( Lowercase( :modelName ), "silverado" ), "Silverado", Contains( Lowercase( :modelName ), "s-10" ), "S-10", Contains( Lowercase( :modelName ), "s10" ), "S-10", Contains( Lowercase( :modelName ), "r10" ), "R10", Contains( Lowercase( :modelName ), "r/v" ), "R10", Contains( Lowercase( :modelName ), "p30" ), "P30", Contains( Lowercase( :modelName ), "tiltmaster" ), "P30", Contains( Lowercase( :modelName ), "monte" ), "Monte Carlo", Contains( Lowercase( :modelName ), "metro" ), "METRO", Contains( Lowercase( :modelName ), "malibu" ), "Malibu", Contains( Lowercase( :modelName ), "lumina" ), "Lumina", Contains( Lowercase( :modelName ), "kodiak" ), "K30", Contains( Lowercase( :modelName ), "k20" ), "K20", Contains( Lowercase( :modelName ), "k2500" ), "K2500", Contains( Lowercase( :modelName ), "k1500" ), "K1500", Contains( Lowercase( :modelName ), "k10" ), "K10", Contains( Lowercase( :modelName ), "impala" ), "Impala", Contains( Lowercase( :modelName ), "hhr" ), "HHR", Contains( Lowercase( :modelName ), "g-" ), "Van", Contains( Lowercase( :modelName ), "g30" ), "Van", Contains( Lowercase( :modelName ), "g20" ), "Van", Contains( Lowercase( :modelName ), "express" ), "Express", Contains( Lowercase( :modelName ), "elcamino" ), "El Camino", Contains( Lowercase( :modelName ), "military" ), "Van", Contains( Lowercase( :modelName ), "c-" ), "Van", Contains( Lowercase( :modelName ), "cruze" ), "Cruze", Contains( Lowercase( :modelName ), "corsica" ), "Corsica", Contains( Lowercase( :modelName ), "chevette" ), "Chevette", Contains( Lowercase( :modelName ), "cavalier" ), "Cavalier", Contains( Lowercase( :modelName ), "captiva" ), "Captiva Sport", Contains( Lowercase( :modelName ), "caprice" ), "Caprice", Contains( Lowercase( :modelName ), "c8500" ), "Silverado", Contains( Lowercase( :modelName ), "c7500" ), "Silverado", Contains( Lowercase( :modelName ), "c6500" ), "Silverado", Contains( Lowercase( :modelName ), "c5c042" ), "Silverado", Contains( Lowercase( :modelName ), "c5500" ), "Silverado", Contains( Lowercase( :modelName ), "c4500" ), "Silverado", Contains( Lowercase( :modelName ), "c3500" ), "Silverado", Contains( Lowercase( :modelName ), "c30" ), "Silverado", Contains( Lowercase( :modelName ), "c2500" ), "Silverado", Contains( Lowercase( :modelName ), "c20" ), "Silverado", Contains( Lowercase( :modelName ), "c1500" ), "Silverado", Contains( Lowercase( :modelName ), "c10" ), "Silverado", Contains( Lowercase( :modelName ), "c/k" ), "C/K Pickup", Contains( Lowercase( :modelName ), "c%2fk" ), "C/K Pickup", Contains( Lowercase( :modelName ), "blazer" ), "Blazer", Contains( Lowercase( :modelName ), "avalanche" ), "Avalanche", Contains( Lowercase( :modelName ), "beretta" ), "Beretta", Contains( Lowercase( :modelName ), "aveo" ), "Aveo", Contains( Lowercase( :modelName ), "astro" ), "Astro", Titlecase( :modelName ) )
Figure 37: Code to rectify “Vehicle Model” (Chevrolet)
Comparisons of Distributions of Vehicle Model and Corrected Vehicle Model
Figure 38: Before re-categorising values for Vehicle Model (BMW)
Figure 39: After re-categorising values for Vehicle Model (BMW)
Figure 40: Before re-categorising values for Vehicle Model (Ford)
Figure 41: After re-categorising values for Vehicle Model (Ford)
Figure 42: Before re-categorising values for Vehicle Model (Chevrolet)
Figure 43: After re-categorising values for Vehicle Model (Chevrolet)