Tupps motors which was established in year 2000, sells 5 brands of new passenger vehicles Holden, Toyota, Ford and Mitsubishi and Nissan which were the market leaders in 2000. As years passed the General Manager of Tupps Motors, Brian Tupps, noticed that brands such as Holden, Ford and Nissan are not selling as much as they used to.

In 2018, Brian Tupps discusses his observation with his recent Business graduate son, Ben Tupps, and they both decided to collect Australia-wide sales data of the top 10 brands of passenger vehicles in 2018 to see how the market share of the different brands have changed. So, Brian Tupps took his son's advice and decided to sell the current top 5 models.

In 2020, the pandemic stuck, and business was not in a good shape, but Brian managed to keep the business and his employees functioning with pandemic subsidies provided by the Federal government. With the closure of the production of Holden in Australia in 2021 and the end of lockdowns in 2022, Brian wanted Ben to analyse the Australia-wide post-pandemic sales data for 2022 and provide him with advice on the market share of the 10 brands of passenger vehicles.

Analysis

1. Identify the type of data that Ben has collected for the various brands of passenger vehicles.

1. Comment on the movement in the TOTAL sales of the top 10 passenger vehicles in 2018, 2020 and 2022.

Top 10 best selling new passenger vehicles sales by brand Brand 2018 2020 2022 217061 111280 94281 84944 69081 58815 57699 56620 51525 50015 1 Toyota 2 Mazda 3 Hyundai 4 Mitsubishi 5 Ford 6 Kia 7 Nissan 8 Volkswagen 9 Honda 10 Subaru 204801 231050 85640 95718 64807 73,345 58335 76,991 59601 66,628 56076 78,330 38323 26491 39266 30,946 29040 14215 31501 36036