EX16_XL_CH03_GRADER_CAP_HW – Airline Arrivals Analysis 1.1

EX16_XL_CH03_GRADER_CAP_HW – Airline Arrivals Analysis 1.1

 

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

Instructions

Points Possible

1

Start Excel. Download and open the file namede03_grader_h1.xlsx.

0.000

2

Insert Line sparklines in the range G4:G7, using the data for the five years in the range B4:F7.

10.000

3

Display the high and low points for the Sparklines.

4.000

4

For the range containing Sparklines, change the high point marker color to Green.

4.000

5

Select the range A4:A7 and the range F4:F7. Create pie chart and move it to a chart sheet named Pie Chart.

10.000

6

Type 2014 Flight Arrivals as the chart title. Format the chart title with Blue font color.

5.000

7

Apply the Style 12 chart style.

4.000

8

Position the legend between the chart title and the plot area.

4.000

9

Add data labels to the Best Fit position.

4.000

10

Apply 12-pt size and bold the data labels.

4.000

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.000

12

Select the range A10:F15 in the Arrivals worksheet and create a clustered column chart.

10.000

13

Type On-Time and Late Flight Arrivals for the chart title.

3.000

14

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.

6.000

15

Apply chart filters to remove the canceled, diverted, and total operations data.

6.000

16

Select the value axis, set 500000 for the Major unit, display the axis units in Millions, select category Number format with 1 decimal place.

8.000

17

Add a primary vertical axis title Number of Flights.

5.000

18

Apply the Color 2 chart color to the chart.

4.000

19

Apply the Light Gradient  Accent 3 fill to the chart area.

4.000

20

Close the workbook, and then exit Excel. Submit the workbook as directed.

0.000

 

Total Points

100.000

Order This Solution

Ask your homework question

 

INDIVIDUAL APPROACH:
Chat with every writer who applies to your request, and view their skills and portfolio. Make the choice that’s right for you.
MANAGE YOUR ORDER:
Monitor progress and see any changes made. Have full control over every phase of the process.
COMMUNICATE:
Ask your writer questions and provide your ideas about your paper. Produce the exact result that you want.
ENJOY THE OUTCOME:
Get everything done on time with high quality. Writing papers is much simpler with us.

Ask your homework question

 

© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.
Loading...