An analysis was made of car sales data in the United States of America. This dashboard is based on real data and made as part of the curriculum.
Made by a student of St. Petersburg State Technological University, Faculty of Economics and Management, direction "Business Informatics" Yulia Bizina.
During the analysis, we came to different results:
- In the tree diagram, we can see the best-selling car brand in the United States of America. The following brands fall into the top: Ford, Toyota, Nissan.
- By car brands, we compared sales from 2005 to 2022, also determined the maximum and minimum market shares, and derived market change indicators.
- Sales of Audi cars have been growing rapidly since 2005. By 2020, the decline begins. And in 2022, there is still not enough data, so many charts have minimum values. They also indicated the dynamics of market share and market changes.
- Maximum value of market share: 1.32
- Minimum market share value: 0.48
- Maximum market change value: 16.30
- Minimum market change value: -3.80
- BMW car sales go up and down.
- Maximum market share value: 2.25
- Minimum market share value: 1.57
- Maximum market change value: 15.29
- Minimum market change value: -11.00
- According to the histogram of Ford sales, you can see a decrease by 2009 and an increase by 2015, by 2020 there is a decrease in sales to 1.9 million.
- Maximum market share value: 16.00
- Minimum Market Share: 12.07
- Maximum market change value: 8.65
- Minimum market change value: -12.90
- Sales of Huyndai cars are declining sharply in 2006 and there is an increase and since 2017 a slight decline.
- Maximum value of market share: 5.81
- Minimum Market Share: 2.71
- Maximum market change value: 26.97
- Minimum market change value: -13.61
- Sales of KIA gradually grew.
- Maximum market share value: 5.32
- Minimum market share value: 1.63
- Maximum market change value: 28.11
- Minimum market change value: -13.44
- Sales of Mazda cars are not stable, then there is a decline, then an increase. According to the histogram of the market change, we notice that from 2009 to 2019 there are negative indicators.
- Maximum value of market share: 44.56
- Minimum Market Share: 19.36
- Maximum market change value: 13.83
- Minimum market change value: -7.95
- Sales of Mitsubishi cars fell by 2009 and gradually grew until 2019.
- Maximum value of market share: 0.81
- Minimum market share value: 0.34
- Maximum market change value: 22.27
- Minimum market change value: -53.64
- Nissan cars fell in sales by 2009 and gradually increased in 2018, with a decline until 2020.
- Maximum market share value: 8.37
- Minimum market share value: 4.03
- Maximum market change value: 7.82
- Minimum market change value: -26.55
- Sales of Toyota by 2010 began to fall, then there is a gradual increase, by 2020 sales are falling again.
- Maximum value of market share: 15.84
- Minimum Market Share: 10.66
- Maximum market change value: 14.41
- Minimum market change value: -17.77
Based on the statistics obtained, the following conclusions can be drawn:
Most car sales fell by 2009 and by 2020. In the United States of America, residents opt for Ford cars.
eyJrIjoiZDcxNTI2ZDEtYjIyOS00YTNjLThhODQtMDY0NDBkMTFmZWYyIiwidCI6IjZiZTgxZjIwLWFlY2MtNGQyZC1hMTM0LWJmZWJlOTAxODE4NCIsImMiOjl9
