Whenever it’s time to buy or sell a used car, especially in Utah, KSL cars is usually the best place to get the job done. If you look at the car’s search results, you will notice that there are literally thousands of cars for sale. I thought that it would be fun to pull 1,200 recent car postings to see what kind of information we could analyze. For this KSL car posting analysis, we will discover what may influence your car posting views.
Statement of Purpose
The purpose of this research study is to show what types of cars and what specs will have the highest chance of gaining the most views.
About KSL Cars for Sale
Name: KSL Auto
Total Cars per Page: ~24
Total Pages: 3132
Approximate Total Cars: 75,168
About the Data Set
Snapshot: 4/20/2017 6:31pm – 6:40
Total Cars Pulled: 1,200
The raw data set can be downloaded from here.
Vehicles by Make
It is interesting to note the most commonly listed vehicle on KSL is a Ford. I also compared the make of the car and the number of total page views on the post. I found the adjusted R-squared is 0.3536, or in other words, the make of the car can explain about 35% of the posting views.
Vehicles by Color
For another portion of the study, I decided to look only at the top ten exterior car colors and how it affected page views. The top ten colors represent about 60% of the 1,200 car sample. Total colors available for the sample 249. The graph below shows that 50% of the pie is dominated by three colors, White, Black, and Silver. (**I tried to match the colors of the car up with the color of the graph**) The adjusted R-squared is 0.03639, or in other words, the color of the car can explain about 3.6% of the page views.
Vehicles by Car Title Type
According to the sampling, 62% of the cars posted had a “not specified” title. While registering my car at the DMV, there were 2 people that walked in who didn’t know what a car title was. I am wondering if this is a lack of education, rather than a lack of giving information. The adjusted R-squared is 0.005442, or in other words, the car title status can explain about 1/2 of a percent of the page views.
Vehicles by Price
It was surprising to see that a large bulk of the cars are priced between $12,000 and $28,000, and also many under $4,000. The adjusted R-squared is 0.2785, or in other words, the pricing of the car can explain about 28% of the page views.
Vehicles by Exterior and Interior Car Condition
Most people withheld disclosing the exterior and interior condition of the car, so therefore the data is skewed in this sampling.
Vehicles by Body Type
Most of the cars listed in this KSL sample were sedans, trucks, and sports utility cars. It was surprising to find that the adjusted R-squared is 0.0002172, or in other words, the body type of the car has no influence for the page views. Overall, it would seem this would be a major factor for most people searching for a car.
Vehicles by Car Mileage
What we can learn from the following graph below is that nearly half of the cars are under 10,000 miles. This can be explained by how many car dealerships use KSL to advertise their cars. The adjusted R-squared is 0.9137, or in other words, the mileage of the car can explain about 91% of the page views.
Vehicles by Year
Generally, it would seem the year the car was made would have a strong impact on the number of views on a listing. The adjusted R-squared is 0.002328, or in other words, the year of the vehicle had no influence on the number of page views received in this data set.
Below is listed the final insights drawn from data mining 1,200 car listings on KSL’s website. Why is this important? Understanding this data will help gauge the probabilty of selling your car through the KSL website. If you have any other questions or comments about the study, feel free to email firstname.lastname@example.org.
- The make of the car can explain about 35% of the posting views
- The color of the car can explain about 3.6% of the page views
- The car title status can explain about 1/2 of a percent of the page views
- The pricing of the car can explain about 28% of the page views
- Most people withheld disclosing the exterior and interior condition of the car
- The body type of the car has no influence for the page views
- The mileage of the car can explain about 91% of the page views
- The year of the vehicle had no influence on the number of page views received in this data set