I need some help to finish this project creating a spreadsheet! 

 

Ofce 2016 – myitlab:grader – InstructionsExcel ProjectEX16_XL_CH03_GRADER_CAP_HW - Airline Arrivals Analysis 1.1Project Description:You are an analyst for the airline industry. You created a workbook that lists overall airline arrivalstatistics for several years. In particular, you listed the percentage and number of on-time arrivals,late arrivals, canceled Fights, and diverted Fights based on information provided by the Bureau ofTransportation Statistics. You want to create charts and insert sparklines that show the trends todiscuss with airline and airport managers.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Start Excel. Download and open the ²le namede03_grader_h1.xlsx.02Insert Line sparklines in the range G4:G7, using the data ±or the ²ve years in therange B4:F7.2.53Display the high and low points ±or the Sparklines.14For the range containing Sparklines, change the high point marker color to Green.15Select the range A4:A7 and the range F4:F7. Create pie chart and move it to achart sheet namedPie Chart.2.56Type2014 Flight Arrivalsas the chart title. Format the chart title with Blue ±ontcolor.1.257Apply the Style 12 chart style.18Position the legend between the chart title and the plot area.19Add data labels to the Best Fit position.110Apply 12-pt size and bold the data labels.1Updated: 07/29/20161Current_Instruction.docx

Annual Airline Annual On-Time Performance20102011201220132014TrendsOn-Time Arrival79.79%79.62%81.85%78.34%76.25%Late Arrival18.21%18.24%16.65%19.93%21.32%Canceled1.76%1.91%1.29%1.51%2.18%Diverted0.24%0.24%0.21%0.22%0.25%Total Operations20102011201220132014On-Time Arrival5,146,5044,845,0324,990,2234,990,0334,437,850Late Arrival1,174,8841,109,8721,015,1581,269,2771,240,528Canceled113,255115,97878,86296,012126,984Diverted15,47414,39912,51914,16014,449Total Operations6,450,1176,085,2816,096,7626,369,4825,819,811SOURCE: Bureau of Transportation Statistics, Airline On-Time DataURL:htp://www.riTa.doT.gov/bTs/subjecT_areas/airline_informa±on/airline_on±me_Tables/2014_12/Table_01

Attachments:

• 1494299272-Anual airline.xlsx
• 1494299273-annual airline outline.docx