Excel Homework

Anonymous

Question Description

I have attached two documents here. One is the excel homework and another provides instruction. Please follow the instruction to complete the excel homework.

Unformatted Attachment Preview

Annual Airline Annual On-Time Performance On-Time Arrival Late Arrival Canceled Diverted Total Operations 2010 79,79% 18,21% 1,76% 0,24% 2011 79,62% 18,24% 1,91% 0,24% 2012 81,85% 16,65% 1,29% 0,21% 2013 78,34% 19,93% 1,51% 0,22% 2014 76,25% 21,32% 2,18% 0,25% On-Time Arrival Late Arrival Canceled Diverted 2010 5.146.504 1.174.884 113.255 15.474 2011 4.845.032 1.109.872 115.978 14.399 2012 4.990.223 1.015.158 78.862 12.519 2013 4.990.033 1.269.277 96.012 14.160 4.437.850 1.240.528 126.984 14.449 Total Operations 6.450.117 6.085.281 6.096.762 6.369.482 5.819.811 2014 SOURCE: Bureau of Transportation Statistics, Airline On-Time Data URL: http://www.rita.dot.gov/bts/subject_areas/airline_information/airline_ontime_tables/2014_12/table_01 Trends Office 2016 – myitlab:grader – Instructions Excel Project EX16_XL_CH03_GRADER_CAP_HW - Airline Arrivals Analysis 1.6 Project Description: You are an analyst for the airline industry. You created a workbook that lists overall airline arrival statistics for several years. In particular, you listed the percentage and number of on-time arrivals, late arrivals, canceled flights, and diverted flights based on information provided by the Bureau of Transportation Statistics. You want to create charts and insert sparklines that show the trends to discuss with airline and airport managers. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Points Possible Instructions 1 Start Excel. Download and open the file named e03_grader_h1.xlsx. 0 2 Insert Line sparklines in the range G4:G7, using the data for the five years in the range B4:F7. 10 3 Display the high and low points for the Sparklines. 4 4 For the range containing Sparklines, change the high point marker color to Green (under Standard Colors). 4 5 Select the range A4:A7 and the range F4:F7. Create a pie chart and move it to a chart sheet named Pie Chart. 10 6 7 8 9 10 Type 2014 Flight Arrivals as the chart title. 3 Apply the Style 12 chart style. Format the chart title with Blue font color (under Standard Colors). Position the legend between the chart title and the plot area. Add data labels to the Best Fit position. 4 4 Apply 12-pt size and bold the data labels. Updated: 02/12/2018 6 4 1 Current_Instruction.docx Office 2016 – myitlab:grader – Instructions Step Excel Project Points Possible Instructions 11 Format the Canceled data point with Dark Red fill color. Format the Late Arrival data point in Green. Explode the Late Arrival data point by 5%. 5 12 Select the range A10:F15 in the Arrivals worksheet and create a clustered column chart. 10 13 14 15 16 17 Type On-Time and Late Flight Arrivals for the chart title. 3 Position the clustered column chart so that the top-left corner is in cell A20. Change the chart width to 5.75 inches and the height to 3.5 inches. Apply chart filters to remove the canceled, diverted, and total operations data. 6 6 Select the value axis, set 500000 for the Major unit, display the axis units in Millions, select category Number format with 1 decimal place. Add a primary vertical axis title Number of Flights. 8 5 Apply the Color 2 chart color to the chart. 18 19 20 Note, depending on the version of Office used, the color name may be Colorful Palette 2. Apply the Light Gradient – Accent 3 fill to the chart area. 4 Close the workbook, and then exit Excel. Submit the workbook as directed. 0 Total Points Updated: 02/12/2018 2 4 100 Current_Instruction.docx ...
Purchase answer to see full attachment

Tutor Answer

uoscar
School: University of Virginia

The solution is attached.Please give me feedback.

Annual Airline Annual On-Time Performance

On-Time Arrival
Late Arrival
Canceled
Diverted
Total Operations

2010
79.79%
18.21%
1.76%
0.24%

2011
79.62%
18.24%
1.91%
0.24%

...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors