D E F A 1 Company 2016 2015 2014 2013 2 Wal-Mart 468,651.00 446,509.00 421,395.00 407,697.00 3 Costco 102,870.00 97,062.00 87,048.00 76,255.00 4 Sears 36,188.00 39,854.00 41,567.00 42,664.00 5 Dollar General 16,022.10 14,807.20 13,035.00 11,796.00 6 Target 72,596.00 73,301.00 69,865.00 67,390.00 7 8 9 10 11 Use the results to answer the following questions: 12 13 1. Which company had the smallest revenue in 2015? 14 Dollar General 15 16 2. Approximate Wal-Mart's 2013 revenue. 17 407,697.00 18 19 3. Which company experienced a decline in revenue from 2013 to 2014? 20 21 4. Which year did Costco have the highest revenue? 22 23 24 EXERCISE 8: CREATING CLUSTERED BAR CHART For this exercise you will analyze the changes in yearly revenue for five different companies in the retail industry. The data is provided for you. Go to the "Excel_Homework" and click on tab/worksheet labeled "Bar Chart." The columns are years and the rows are companies. The data is the yearly revenue in millions of dollars. Create a Clustered Bar Chart. Use the results to answer the following questions: 1. Which company had the smallest revenue in 2015? 2. Approximate Wal-Mart's 2013 revenue. 3. Which company experienced a decline in revenue from 2013 to 2014? 4. Which year did Costco have the highest revenue? Type All Answers on your Excel Spreadsheet that you will submit