Top 10 best selling new passenger vehicles sales by brand Brand 2018 2020 1 Toyota 217061 204801 2022 231050 2 Mazda 111280 85640 95718 3 Hyundai 94281 64807 73,345 4 Mitsubishi 84944 58335 76,991 5 Ford 69081 59601 66,628 6 Kia 58815 56076 78,330 7 Nissan 57699 38323 26491 8 Volkswagen 56620 39266 30,946 9 Honda 51525 29040 14215 10 Subaru 50015 31501 36036 Analysing passenger car sales by brands in Australia Tupps Motors which was established in year 2000, sells 5 brands of new passenger vehicles Holden, Toyota, Ford, 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. Again, in 2023, Brian wanted Ben to analyse the Australia-wide post-pandemic sales data for 2022 and provide him with up-to-date advice on the market share of the 10 brands of passenger vehicles. Data on the number of passenger vehicles sales for the top 10 brands of passenger vehicles in 2018 and 2022 are provided in file 1Sales.xlsx. [Note that to make comparisons easier Ben collected data for the same top 10 brands of passenger vehicles. As Holden sales ceased in 2021, Ben has excluded Holden from the Top 10 passenger vehicles for this analysis.] Using this data and EXCEL, answer the Part A, B, C and D below. Part A (a) Identify whether the data are primary or secondary data. (b) (c) Identify the type of data that Ben has collected for the various brands of passenger vehicles. Calculate the TOTAL sales of the top 10 passenger vehicles in 2018 and 2022 and comment on the movement of TOTAL sales between 2018 and 2022.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

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