The Wall Street Journal€™s website, www.wsj.com, reported the number of cars and light-duty trucks sold through October of 2014 and October of 2015. The top sixteen manufacturers 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 the October 2015 sales to the October 2014 sales for each manufacturer by computing the difference. Make a list of the manufacturers that increased sales compared to 2014; make a list of manufacturers that decreased sales.
b. Using computer software, compare 2014 sales to 2015 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 2015 year-to-date sales. Then, design a bar graph to illustrate the 2014 and 2015 year-to-date sales for the top 12 manufacturers. Also, design a bar graph to illustrate the percentage change for the top 12 manufacturers. Compare these two graphs and prepare brief written comments.

Transcribed Image Text:

Year-to-Date Sales Through October Through October Manufacturer 2015 2014 General Motors Corp. Ford Motor Company 2,562,840 2,434,707 2,178,587 2,065,612 Toyota Motor Sales USA Inc. Chrysler 2,071,446 1,975,368 1,814,268 1,687,313 American Honda Motor Co Inc. 1,320,217 1,281,777 1,238,535 1,166,389 Nissan North America Inc. Hyundal Motor Amerlca 638,195 607,539 Kla Motors America Inc. 526,024 489,711 Subaru of Amerlca Inc. 480,331 418,497 Volkswagen of America Inc. 294,602 301,187 Mercedes-Benz 301,915 281,728 BMW of North Amerlca Inc. 279,395 267,193 259,751 Mazda Motor of America Inc. 267,158 Audl of America Inc. 165,103 146,133 Mitsublshi Motors N A, Inc. 80,683 64,564 47,823 Volvo 53,803