Mark Lines is an online portal (www.marklines.com) that reports automotive industry data. The table below shows the number of cars sold in the United States in 2018 and 2019. The top 22 manufacturers, plus others, are listed here. Sales data often are reported in this way to compare current sales to last year’s sales.

Using computer software, compare 2018 sales to the 2019 sales for each manufacturer by computing the difference. Make a list of the manufacturers that increased sales from 2018 to 2019; make a list of manufacturers that decreased sales. Using computer software, compare 2018 sales to 2019 sales for each manufacturer by computing the percentage change in sales. Make a list of the manufacturers in order of increasing percentage changes. Which manufacturers are in the top five in percentage change? Which manufacturers are in the bottom five in percentage change? Using computer software, first sort the data using the 2019 year-to-date sales. Then, design a bar graph to illustrate the 2018 and 2019 year-to-date sales for the top 10 manufacturers. Also, design a bar graph to illustrate the percentage change for the top 10 manufacturers. Compare these two graphs and prepare a brief written report.

Transcribed Image Text:

Manufacturer GM (Est.) Ford Toyota FCA (Est.) Honda Nissan Hyundai Subaru Kia VW Mercedes (includes Sprinter) BMW Mazda Audi Tesla (Est.) Mitsubishi Volvo Land Rover Porsche Car Sales Jan.-Dec.2019 2,877,590 2,406,188 2,383,349 2,203,663 1,608,170 1,345,681 710,007 700,117 615,338 363,322 357,730 324,826 278,552 224,111 178,950 121,046 108,234 94,736 61,568 Jan.-Dec.2018 2,951,200 2,485,222 2,426,674 2,235,204 1,604,828 1,493,877 677,946 680,135 589,673 354,064 354,137 311,014 300,325 223,323 126,150 118,074 98,263 92,143 57,202