EXCEL DATA QUESTION
The table 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 also listed. Sales data often is reported in this way to compare current sales to last year’s sales.
- Using Excel, 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. Which manufacturers are in the top five with increased sales? Which manufacturers are in the bottom five with decreased sales? (Enter values in decreasing order and negative values with a minus sign.)
- Using Excel, 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? (Enter values in decreasing order and negative values with a minus sign. Round percentage answers to 1 decimal place.)
Problems must follow the following guidelines:
- Copy your results from Excel and paste them into MS Word
- Write a brief report for each problem explaining the results in relation to the problem you analyzed.
