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 from January to November in 2017 and 2018. The top 22 manufacturers, plus others, are listed here. Sales data often is reported in this way to compare current sales to last year’s sales.

a. Using computer software, compare 2017 sales to the 2018 sales for each manufacturer by computing the difference. Make a list of the manufacturers that increased sales compared to 2017; make a list of manufacturers that decreased sales.

b. Using computer software, compare 2017 sales to 2018 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?

c. Using computer software, first sort the data using the 2018 year-to date sales. Then, design a bar graph to illustrate the 2017 and 2018 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:

Car Sales Jan.-Nov. Jan.-Nov. Manufacturer 2017 2018 GM (Est.) 2,691,493 2,654,568 Ford 2,334,290 2,265,590 Toyota Fiat Chrysler 2,211,533 2,205,762 1,887,430 2,038,684 Honda 1,492,112 1,449,713 Nissan 1,455,238 1,345,157 Hyundai 621,961 612,225 Subaru 584,614 615,594 Kia 546,629 332,990 542,245 318,012 276,657 322,017 Mercedes (includes Sprinter) BMW 271,432 Vw 309,395 Mazda 262,577 274,455 Audi 199,534 200,558 106,050 Tesla (Est.) 40,320 Land Rover 66,759 81,526 Volvo 71,828 89,437 Mitsubishi 95,185 109,088 Porsche 51,507 53,116 MINI 42,494 40,887 Jaguar 36,180 27,021 Others 18,901 17,251 smart 2,905 1,154