A mandatory requirement for your State of the Industry Paper is to incorporate the most recent available data into the World Airline Data 1929-2010 spreadsheet in Microsoft Excel to create charts comparing 1) operating revenues to net margin and 2) passenger load factor, break even load factor and net margin since 1978. The charts are already created, so all you have to do is update the data table in the first tab.
https://uvu.instructure.com/courses/605010/files/121833958?verifier=HLFVNLLgZSzV2vLwFGVAvzM7HEZ2uoET1XiwnwTC&wrap=1
To update the charts, download the Financial and Traffic/Operations tables from A4A’s World Airlines Annual Results. To do this, click on the download icon at the bottom of the Tableau report, select ‘Data’, choose the ‘Underlying’ tab at the top of the popup window, check the ‘show all columns’ box and click on the ‘Download all rows as a text file’ link. Add rows to the data spreadsheet in the World Airline Data excel file to add the current data and update any historical data as necessary. Copy and paste the charts as images into your State of the Industry Paper. Be sure to interpret and discuss the implications of recent and historical trends identified in your upcoming paper.
https://www.airlines.org/dataset/world-airlines-traffic-and-capacity/
Upload the Excel file (.xslx) of your analysis to receive credit for this assignment. The assignment should be uploaded by the due date. Late assignments will not be accepted!
