$1)$ Create a tree map that shows how many flights were conducted by each of the airlines in your dataset. Name this worksheet $$flights by airline$.$

$2)$ Create a bar chart that shows average departure delay by airline. Name this worksheet $$delay by airline$.$

$3)$ Create a bar chart that shows average departure delay by origin airport. Name this worksheet $$delay by airport$.$

$4)$ Create a heat map that shows the number of flights by origin airport and destination airport. Title this worksheet with the name of the most popular route $($e$.$g$.,$ ORD to DEN$)$

$5)$ Create a filled map that shows the number of flights by state. Name this worksheet flights by state.

$6)$ Create a line chart that tracks the sum of weather delay by month. Show a forecast on your line chart that includes the upper and lower interval. Name this worksheet with the two months with the most minutes of weather delays $($e$.$g$.,$ April and May$).$

$7)$ Create a scatterplot that shows the relationship between Departure delay and Average Passenger Rating. Name this worksheet $$Correlation$.$

a$.$ Hint: one field to row shelf, one field to column shelf, and $$record number$$ to detail, or disaggregate using the analysis tab.

You will combine your sheets into a dashboard that has the following characteristics:

$-$ It will be sized $1100$ x $900$ pixels.

$-$ It will incorporate stylistic elements of your client company$$s website to include color palette and fonts.