Simple Research Study – KSL Car Posting Analysis

Car Postings by Price

Introduction

Background

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.

Methodology

About KSL Cars for Sale

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

Results

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.

Total Vehicles by Make

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.

Percentage of Car Colors

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.

Total Car Posts by Title Type

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.

Car Postings by Price

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. 

 Exterior and Interior Car Condition

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.

Total Postings by Vehicle Body Type

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.

 

Car Mileage Distribution

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.

Car Postings by Year

Conclusion

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 chase.willden@gmail.com.

  • 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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.