U.S Used Vehicle Trends
Data for this project is sourced from :
Data source provides different statistics regarding used vehicle such as :
◦- Average vehicle priced per state
◦- Colors of vehicle
◦- Year of manufacturing
◦- The title condition of each vehicle
Average Price of Vehicle Sold per State & Effect of Vehicle Status(Based of 2499 cars sold via auction)
Visualization:
○This data set is comprised of average price of used vehicle sold per state
○The X-axis on the chart represents the state
○The Y-axis on the chart represents the average price per title status of vehicle sold
○The map showed average price of every vehicle sold nationally
Reasoning:
○This visualization was created to show which state has the best average price for
passenger car sold in the united states, this showed different demographics of
buyers per state based on average price of vehicle sold
○The map visualization makes it easier to see the demographic of used car prices
across the nation
○The stacked bar helped to visualize the mixed ratio between clean and salvage
titled cars
Conclusion
○ The average of Clean vs Salvage titled cars sold per state varied, with Idaho being the only state with 100% salvage titled cars sold through this research
■ Clean titled cars demanded more nationally, Salvaged titled cars are more popular in the lower range of the chart that denotes cheaper average price sold per vehicle
■ The used vehicle market in Kentucky seems to be the highest in average price vehicle sold with demand in clean titled cars
○ The highest average price of cars available for purchase is in Kentucky, this could be factored due to the number of clean titled luxury cars availability for sale in the state
○ Cars with clean titled cars are priced higher than cars with salvage title
○Some states with lower average price of vehicle sold (below $15.000) are mostly dominated with salvage titled cars, this is because of salvage titled cars are cheaper than clean titled cars, showing purchasing power of people in these states are lower than the other states
Effect of Mileage on Vehicle Prices(Based of 2499 cars sold via auction)
● Visualization:
○ This data set is comparing mileage and price of vehicle per brand
○ The X-axis represents the average mileage per vehicle brand
○ The Y-axis represents the average price per vehicle brand
● Reasoning:
○ This visualization is used to see if there’s any effect of a vehicle’s mileage towards its price
○ Horizontal bars eased the comparison process so we can see the correlation easier between mileage and vehicle price
○ The text tables helped to aid the horizontal bars to compare data numerically
Conclusion
Based on drawing conclusion on vehicle mileage and its correlation to sales price alone, it is shown that vehicles with larger mileage are averagely lower in price compared to vehicles with less mileage
■ Vehicle that have lower mileage tends to be sold at a higher price
■ The demographic of vehicle that covered more than 100.000 miles are priced
below $10.000
○ Even though there’s a correlation shown in this research that vehicles with more mileage tends to be priced cheaper, there are more factors that aren’t included in this research such as brand image and reliability
○ The correlation could also be factored based on the condition of each vehicle in this sample, higher mileage cars could be more weathered down compared to lower mileage cars that couldn’t be factored in this research
○ Type of vehicle could also factor in this chart
Correlation Between Vehicle Age and Color Towards Price(Based of 2499 cars sold via auction)
Visualization:
○ This data set is comparing vehicle registration year and vehicle color towards price
○ The X-axis on the line chart represents the color of vehicle
○ The Y-axis on the line chart represents the average price per vehicle color
○ The X-axis on the packed bubble the year of manufacturing
○ The Y-axis on the packed bubble represents the average price per vehicle year
Reasoning:
○ This visualization is used to see if there’s any effect between a vehicle price and its color, and a vehicle price and its manufacturing year
○ The line chart is used to distinguish the trend of vehicle sold with each color
○ The packed bubble is used to show the correlation between a vehicle price and its manufacturing year, the bigger the bubble the higher its averagely marketed
Conclusion
Based on the visualization we can conclude the following:
o There are trends of vehicle painted in monochrome colors (black, white, silver) being offered at higher average prices, this showed consumer pattern in purchasing vehicles in monochrome colors more than brave colors such as gold, green, or purple
o Vehicle in red and blue are in more demand than other vibrant colors
o There are a possible correlation between a vehicle price and its manufacturing date, the average vehicle price gets averagely lower, descending from 2020
o There is an explanation why the vehicle from 1973 may be priced higher, being the sample is a single unit with a low mileage may explain that this vehicle is a collector’s item, and it doesn’t correlate to the average vehicle being tested
Hire Expert to get other tableau visualization help with complete attractive dashboard which looks professionals. Send your query at below mail id with your project requirement details:
realcode4you@gmail.com