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 C (a) (b) Use an appropriate chart to display the market share of the top 10 brands of passenger vehicles in 2018. Comment on the market leaders. Use an appropriate chart to display the market share of the top 10 brands of passenger vehicles in 2022. Comment on the market leaders. 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
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 C (a) (b) Use an appropriate chart to display the market share of the top 10 brands of passenger vehicles in 2018. Comment on the market leaders. Use an appropriate chart to display the market share of the top 10 brands of passenger vehicles in 2022. Comment on the market leaders. 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
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
![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 C
(a)
(b)
Use an appropriate chart to display the market share of the top 10 brands of passenger
vehicles in 2018. Comment on the market leaders.
Use an appropriate chart to display the market share of the top 10 brands of passenger
vehicles in 2022. Comment on the market leaders.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F55521067-0384-497f-95f8-f51a06d5dbdf%2Fe05a301f-f63f-4542-b4ee-523e44a7b6e8%2Fhh9n2g_processed.png&w=3840&q=75)
Transcribed Image Text: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 C
(a)
(b)
Use an appropriate chart to display the market share of the top 10 brands of passenger
vehicles in 2018. Comment on the market leaders.
Use an appropriate chart to display the market share of the top 10 brands of passenger
vehicles in 2022. Comment on the market leaders.
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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 1 steps
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman