Final Project BAIS 462

Tesla Information

Author

Kara Carter

Introduction

Electric cars have been increasing in popularity in recent years. Tesla is known as one of the front-runners in electric car sales. Their cars feature more advanced technology compared to those of their competitors. This has attracted many people, including a member of my own family. When looking to purchase a car, it is important to consider its value over its lifetime. Additionally, one should consider the car’s availability across the country.

Data Information

The dataset shows resold Teslas throughout the United States. Each column contains information describing the car and its location, and each row represents a single car. The “year” column contains many N/A values. For entries with a specified year, we assume the car was produced in that year. For entries with N/A values, we assume the cars were produced sometime between 2018 and 2022, since the dataset has not been updated in the past two years.

model: tells which of the Tesla models the car is

year: the year the car was produced

odometer: shows the number of total miles the car has been driven

price: represents the amount the car is now worth

location: tells where the car is being sold

drive_train: explains the type wheel engine power being sent to which wheels

das: tells the extent of the cars’ capabilities to drive itself

accident_history: details about the cars’ past wrecks

paint_job: the color of the cars’ exterior

wheels: the color of rim in the wheel

emi: the excepted monthly payment

zip_code: zip code

interior: the type of interior

state: the state in US the car is currently in

Summary Statics

# A tibble: 6 × 3
  Statistic  Price Odometer
  <chr>      <dbl>    <dbl>
1 Min.      26500      131 
2 1st Qu.   36900    18065 
3 Median    43900    28591 
4 Mean      45444.   30375.
5 3rd Qu.   52100    38470.
6 Max.      86200    95696 
Model 3 Model S Model X Model Y 
    592     488     235     597 

Histogram of Resale Prices

There is a wide range of listings that span a broad range of prices. However, the histogram is left-skewed. In other words, there are more listings priced under $60,000 than over $60,000. The most common listing price is $42,000. For a used car, this is relatively expensive. While cars typically depreciate quickly, this does not seem to be the case for Teslas. Because they are electric and rely on software updates to improve functionality, they tend to retain their value better than other vehicles.

Scatter Plot: Prices Vs Odometer

The more miles a car has, the less it is typically worth. This scatter plot reinforces that trend. However, the line of best fit has a relatively shallow slope, indicating a slow rate of depreciation. The data includes points from all four models in the data set.

Prices Vs Odometer -Model 3 & Model Y

This relationship still shows that the more mileage a car has, the less it is worth. However, this analysis only includes the Model 3 and Model Y.

Box plot: Price Range per State

Car prices can vary by state due to differences in the cost of living. The state with the highest-priced cars is Florida. On average, Florida and Georgia have the highest-priced cars, while Arizona has the lowest prices.

Bar Chart of listings by State

When looking to buy a car, it is important to consider which markets have the most listings available. The top ten states with the most listings are shown in the graph. In the data set, California has the overwhelming majority of Teslas being sold, with just under 800 listings. The state with the next most listings is Maryland, with just over 200.

Price for Each Model

Tesla offers different models at varying price points due to differences in size and amenities. The Model X has the highest average price, at nearly $60,000, followed by the Model S, which averages just over $50,000. The average resale price is an important factor to consider when buying a car, especially if there is a high likelihood of it being resold.

Cars.com Information

To learn more about Teslas being resold, I scraped Cars.com for information on the name, mileage, price, and location. This data specifically pertains to the Model 3 and Model Y. These two models will show the changes in resold Teslas over the past two years.

Average Price per Model

Compared to the average resale value from the original dataset, there has been little change in the resale value of the Model 3 and Model Y. The Model Y was first introduced in 2019, so its resale value is higher due to its relative newness. However, from 2020 to 2022, the value did not change much. Model 3 vehicles produced between 2018 and 2022, and listed within the same years, were originally reselling for around $35,000. However, according to Cars.com, these same cars are now reselling for approximately $25,000. This drop is likely due to the natural depreciation of cars, and there are probably no external factors significantly affecting their worth.

Change in Price by Mileage

The main difference between Cars.com and the original data set is the age of the cars. The newer and older cars on Cars.com have a wider range of mileage compared to the cars listed in the original data set, which includes vehicles from 2018 to 2022. As a result, there are cars with more miles that are priced lower. However, the general trend between mileage and price remains consistent. Over time, Teslas have depreciated, continuing to follow their usual trend.