Paste B $ % 9 808 A1 4 fe Company A B D E F G H 1 Company 2 Wal-Mart 3 Costco 4 Sears 5 Dollar General 6 Target 7 2016 468,651.00 102,870.00 36,188.00 16,022.10 72,596.00 2015 446,509.00 97,062.00 39,854.00 14,807.20 73,301.00 2014 421,395.00 87,048.00 41,567.00 13,035.00 69,865.00 2013 407,697.00 76,255.00 42,664.00 11,796.00 67,390.00 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Breakeven Analysis Lookup Income Statement Pivot Table Data EXERCISE 7: CREATING A CLUSTERED COLUMN AND LINE CHART Charts are visual representations of data. Charts are useful because they often make it easier to understand the data because users can pick out patterns and trends that are illustrated in the chart that are otherwise difficult to see. For this exercise you will analyze the changes in stock price for five different airlines. The data is provided for you Go to the "Excel_Homework and click on sheet labeled "Une Chart." Open the file and find the spreadsheet with Columns for each airline and Rows for each month. The data is the percent change in stock price over the course of the month. Create line charts to interpret data and answer the following questions Use the results to answer the following questions: 1. Which airline did not experience a decline in stock price? 2. What month had the highest stock price change? 3. Which airline showed the greatest change in stock prices during this period (August to December 2014)? 4. When did American airlines have a negative percent change in stock price? Type All Answers on your Excel Spreadsheet that you will submit. aye Layout Formulas Data Review View Tell me X Calibri (Body) 11 ~ A M 21 General Conditio Paste BIU a v A 191 $ % 9 2. Formata Cell Style G6 foc A D E G H 1 Year 2. 3 4 5 6 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 B Southwest Airlines United Continental Ryanair 13.19 2.63 5.5 -1.72 2.1 12.87 21.29 15.94 1.2 9.24 American Airlines Delta Airlines 3.6 0.08 5.66 2.79 -8.75 8.67 -1.58 16.54 11.29 13.23 17.36 16.01 13.32 10.51 5.4 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Line Chart Bar Lookup Breakeven Analysis Pivot Table Data Income Statement EXERCISE 7: CREATING A CLUSTERED COLUMN AND LINE CHART Charts are visual representations of data. Charts are useful because they often make it easier to understand the data because users can pick out patterns and trends that are illustrated in the chart that are otherwise difficult to see For this exercise you will analyze the changes in stock price for five different airlines. The data is provided for you. Go to the "Excel_Homework and click on sheet labeled "Line Chart." Open the file and find the spreadsheet with columns for each airline and Rows for each month. The data is the percent change in stock price over the course of the month. Create line charts to interpret data and answer the following questions Use the results to answer the following questions: 1. Which airline did not experience a decline in stock price? 2. What month had the highest stock price change? 3. Which airline showed the greatest change in stock prices during this period (August to December 2014)? 4. When did American airlines have a negative percent change in stock price? Type All Answers on your Excel Spreadsheet that you will submit