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. The sales information for all manufacturers can be accessed in a data file below. Sales data are often reported in this way to compare current sales to last year’s sales. Year-to-Date Sales Manufacturer Through October 2015 Through October 2014 General Motors Corp. 2,562,840 2,434,707 Ford Motor Company 2,178,587 2,065,612 Toyota Motor Sales USA Inc. 2,071,446 1,975,368 Chrysler 1,814,268 1,687,313 American Honda Motor Co Inc. 1,320,217 1,281,777 Nissan North America Inc. 1,238,535 1,166,389 Hyundai Motor America 638,195 607,539 Kia Motors America Inc. 526,024 489,711 Subaru of America Inc. 480,331 418,497 Volkswagen of America Inc. 294,602 301,187 Mercedes-Benz 301,915 281,728 BMW of North America Inc. 279,395 267,193 Mazda Motor of America Inc. 267,158 259,751 Audi of America Inc. 165,103 146,133 Mitsubishi Motors N A, Inc. 80,683 64,564 Volvo 53,803 47,823 Click here for the Excel Data File Required a. Using computer software, compare the October 2015 sales to the October 2014 sales for each manufacturer by computing the difference. Which manufacturers are in the top five? Which manufacturers are in the bottom five? 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?
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. The sales information for all manufacturers can be accessed in a data file below. Sales data are often reported in this way to compare current sales to last year’s sales.
Year-to-Date Sales | ||||
Manufacturer | Through October 2015 | Through October 2014 | ||
General Motors Corp. | 2,562,840 | 2,434,707 | ||
Ford Motor Company | 2,178,587 | 2,065,612 | ||
Toyota Motor Sales USA Inc. | 2,071,446 | 1,975,368 | ||
Chrysler | 1,814,268 | 1,687,313 | ||
American Honda Motor Co Inc. | 1,320,217 | 1,281,777 | ||
Nissan North America Inc. | 1,238,535 | 1,166,389 | ||
Hyundai Motor America | 638,195 | 607,539 | ||
Kia Motors America Inc. | 526,024 | 489,711 | ||
Subaru of America Inc. | 480,331 | 418,497 | ||
Volkswagen of America Inc. | 294,602 |
301,187 |
||
Mercedes-Benz | 301,915 | 281,728 | ||
BMW of North America Inc. | 279,395 | 267,193 | ||
Mazda Motor of America Inc. | 267,158 | 259,751 | ||
Audi of America Inc. | 165,103 | 146,133 | ||
Mitsubishi Motors N A, Inc. | 80,683 | 64,564 | ||
Volvo | 53,803 | 47,823 | ||
Click here for the Excel Data File
Required
a. Using computer software, compare the October 2015 sales to the October 2014 sales for each manufacturer by computing the difference. Which manufacturers are in the top five? Which manufacturers are in the bottom five?
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?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images