Top 10 best selling new passenger vehicles sales by brand Brand 2018 1 Toyota 217061 2020 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 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 B (a) Use an appropriate chart to display the number of cars sold in the top 10 brands of passenger vehicles in 2018 and 2022. From what you observe from the chart, present a comparison of changes in sales by brand between 2018 and 2022 (Max 100 words)

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.6: Summarizing Categorical Data

Problem 28PPS

See similar textbooks

Related questions

Question

Transcribed Image Text:Top 10 best selling new passenger vehicles sales by brand Brand 2018 1 Toyota 217061 2020 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

Transcribed Image Text: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 B (a) Use an appropriate chart to display the number of cars sold in the top 10 brands of passenger vehicles in 2018 and 2022. From what you observe from the chart, present a comparison of changes in sales by brand between 2018 and 2022 (Max 100 words)

Expert Solution

Step by step

Solved in 1 steps with 1 images

SEE SOLUTION Check out a sample Q&A here