Link: https://github.com/danawoodruff/carsales/blob/main/2020_Year_Of_Reckoning.pptx
Project data is separated into four folders: "COVID_data", "Govt_Data", "CAR_sales_data", and "Stock_Data".
"Working_Notebooks" is a folder containing the individual workbooks of team members. These notebooks were merged into a file named "Working_Master".
Plot formatting changes were made in the Working_Master along with minor edits. The images from the plots were saved in a folder named "Images".
The "Working_Master" was copied as "Master_Notebook". Unused plots and code were culled.
• COVID trend, Interest rate trend, Unemployment trend, and Consumer Sentiment trend were each visualized to easily observe which factors explain the change in consumer behavior towards car sales. COVID, as the precipitating event, influenced each factor and effect examined.
![1](https://github.com/danawoodruff/Car-Sales-Analysis/blob/main/Images/covid_st_barplot.png")
• The team observed the best and worst performances of the targeted forty auto brands car sales from 2019 and 2020.
• Total car sales trend was compared to the Consumer Sentiment trendline.
• The team created weighted average indexes of the targeted twenty-one auto groups to compare to overall S&P 500 performance and to one another pre- and post- COVID. The four indexes' performance differed from one another and from the S&P 500.
• The indexes were compared to the Consumer Sentiment trendline.
The following are our references that were used to analyze our data.
• https://www.truecar.com/prices-new
• https://www.goodcarbadcar.net/
• https://global.toyota/en/ir/library/sec/
• https://www.fcagroup.com/enUS/investors/financial_regulatory/Pages/latest_financial_results.aspx
• https://www.treasury.gov/resource-center/datachartcenter/interestrates/Pages/TextView.aspx?data=billRatesYear&year=2020
• https://www.quandl.com/data/UMICH/SOC38-University-of-Michigan-Consumer-Survey-Reasons-for-Opinions-for-Buying-Conditions-for-Vehicles
• https://covidtracking.com/data/api
• https://www.bls.gov/charts/employment-situation/civilian-unemployment-rate.htm
• https://www.volkswagenag.com/presence/investorrelation/publications/interimreports/2020/Q3_2020_e.pdf
• https://www.yahoofinance.com