EX16_XL_CH03_GRADER_CAP_HW - Airline Arrivals Analysis 1.5
HI I WANT THIS SOLUTION IN A...
Engineering, 10.04.2020 20:19 whitakers87
EX16_XL_CH03_GRADER_CAP_HW - Airline Arrivals Analysis 1.5
HI I WANT THIS SOLUTION IN A EXCEL FILE..I CAN EMAIL U A EXCEL FILE ON WHICH YOU HAVE TO SOLVE THIS QUESTION...YOU CAN EMAIL ME YOUR ID SO I CAN SEND YOU THE EXCEL FILE.
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 named e03_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 (under Standard Colors).
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.
3.000
7 Apply the Style 12 chart style. Format the chart title with Blue font color (under Standard Colors). 6.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.
Note, depending on the version of Office used, the color name may be Colorful Palette 2.
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
Answers: 2
Other questions on the subject: Engineering
Engineering, 03.07.2019 14:10, kayabwaller4589
When at a point two solid phase changes to one solid phase on cooling then it is known as a) eutectoid point b) eutectic point c) peritectic point d) peritectoid point
Answers: 3
Engineering, 03.07.2019 14:10, BardiFan
Amass of m 1.5 kg of steam is contained in a closed rigid container. initially the pressure and temperature of the steam are: p 1.5 mpa and t 240°c (superheated state), respectively. then the temperature drops to t2= 100°c as the result of heat transfer to the surroundings. determine: a) quality of the steam at the end of the process, b) heat transfer with the surroundings. for: p1.5 mpa and t 240°c: enthalpy of superheated vapour is 2900 kj/kg, specific volume of superheated vapour is 0. 1483 m/kg, while for t 100°c: enthalpy of saturated liquid water is 419kj/kg, specific volume of saturated liquid water is 0.001043m/kg, enthalpy of saturated vapour is 2676 kj/kg, specific volume of saturated vapour is 1.672 m/kg and pressure is 0.1 mpa.
Answers: 3
Engineering, 04.07.2019 18:20, jessie8022
Apiston-cylinder device contains 0.1 m3 of liquid water and 0.9 m3 of water vapor in equilibrium at 800 kpa. heat is transferred at constant pressure until the temperature of water reaches 350 °c. determine (a) the quality of water at the initial state (b) the work associated with this process, (c) the heat associated with this process.
Answers: 2
Engineering, 04.07.2019 18:20, cdyshaylia55
Water vapor initially at 10 bar and 400 °c is contained within a piston-cylinder assembly. the water lost heat to the surrounding according to isochoric (iso-volumetric) process until its temperature is 150 °c. the water is then condensed isothermally to saturated liquid. for the water as a system, calculate the work in kj/kg
Answers: 2
You know the right answer?
Questions in other subjects:
Physics, 11.10.2019 19:20
History, 11.10.2019 19:20
History, 11.10.2019 19:20
Computers and Technology, 11.10.2019 19:20
English, 11.10.2019 19:20
Mathematics, 11.10.2019 19:20
