Goodcarbadcar is an online portal (www.goodcarbadcar.net) that reports automotive industry data. The table shows the number of

Question:

Goodcarbadcar is an online portal (www.goodcarbadcar.net) that reports automotive industry data. The table shows the number of cars sold in the United States in 2019 and 2020. The top 34 brands are listed. Sales data are often reported in this way to compare current sales to last year’s sales.


image


image


a. Using computer software, compare 2019 sales to 2020 sales for each brand by computing the difference. Make a list of the brands that increased sales in 2020 compared to 2019; make a list of brands that decreased sales.


b. Using computer software, compare 2019 sales to 2020 sales for each brand by computing the percentage change in sales. Make a list of the brands in order of increasing percentage changes. Which brands are in the top five in percentage change? Which brands are in the bottom five in percentage change?


c. Using computer software, first sort the data using the 2020 year-to-date sales. Then, design a bar graph to illustrate the 2019 and 2020 year-to-date sales for the top 10 brands. Also, design a bar graph to illustrate the percentage change for the top 10 brands. Compare these two graphs in a brief written report.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Statistical Techniques In Business And Economics

ISBN: 9781265779696

19th Edition

Authors: Douglas Lind, William Marchal, Samuel Wathen

Question Posted: