Please help in this assaiment,

view AS Read aloud | Draw v Highlig In this assignment, you will design a visualization for a dataset. You are free to use any graphics or charting tool you please including drafting it by hand. Data Set: Flight Delays and Cancelations The U.S. Department of Transportation tracks the performance of domestic flights operated by alr carriers. Summary Information on the number of on-time, delayed, and canceled flights is published for 2020. Each entry shows information about a flight. The columns are described in the attached file [ColumnDescriptions.txt). The dataset is in file [FlightsJan Jun2020.csv). Assignment Your task is to design a visualization that you believe effectively communicates the data and provide a short write-up (2 to 4 paragraphs) describing your design. Start by choosing two questions you'd like your visualizations to answer. Design your visualizations to answer these two questions, and use the questions as the title of your graphic. Examples of questions: . Do the seasons (e.g., winter) impact the flight delays? Is there a relationship between airlines in terms of flight delays? . Note that you are free to transform the data as you see fit. Such transforms may include (but are not limited to) computing summation, counts, percentages or averages, grouping elements into new categories, or removing unnecessary variables or records. You are also free to incorporate external data as you see fit. Your chart image should be interpretable without recourse to your short write-up. Do not forget to include title, axis labels or legends. Grading The assignment score is out of a maximum of 5 points. I will determine scores by judging both the soundness of your design and logic, and the quality of the write-up. Here are some points that may lead to loosing grades: . Missing chart title, axis labels, or description. Incorrect data transformation. YEAR QUARTER MONTH DAY OF MONTH DAY OF WEEK MKT_UNIQUE_CARRIER MKT_CARRIER_FL_NUM ORIGIN ORIGIN CITY NAME ORIGIN_STATE_ABR ORIGIN_STATE_NM DEST DEST CITY NAME DEST_STATE_ABR DEST_STATE_NM CRS_DEP_TIME DEP_TIME DEP DELAY CRS ARR TIME ARR_TIME ARR DELAY CANCELLED CANCELLATION CODE CRS_ELAPSED TIME ACTUAL ELAPSED TIME Year 1: Jan-Mar, 2: Apr-Jun, 3: Jul-Sep, 4: Oct-Dec Month of Year Date of Month Day of Week (1: Monday, 7: Sunday) Airline Carrier Code: AA: American Airlines AS: Alaska Airlines B6: JetBlue DL: Delta Air Lines F9: Frontier Airlines G4: Allegiant Air HA: Hawaiian Airlines NK: Spirit Airlines UA: United Airlines WN: Southwest Airlines Flight Number Flight Departure 3-Letter Airport Abbreviation Flight Departure City, State Names Flight Departure 2-Letter State Abbreviation Flight Departure State Name Flight Arrival 3-Letter Airport Abbreviation Flight Arrival City, State Names Flight Arrival 2-Letter State Abbreviation Flight Arrival State Name Scheduled Departure Time (HHMM) (Single or 2-Digit Values Represent 00:MM, e.g. 3 represents 00:03 or 12:03 AM) - Actual Departure Time (HHMM) Departure Delay (Difference Between Actual Departure Time and Scheduled Departure Time in Minutes) Scheduled Arrival Time (HHMM) (Single or 2-Digit Values Represent 00:MM, e.g. 3 represents 00:03 or 12:03 AM) - Actual Arrival Time (HHMM) - Arrival Delay (Difference Between Actual Arrival Time and Scheduled Arrival Time in Minutes) 0: Flight Not Cancelled, 1: Flight Cancelled - Reason for Cancellation - if Cancelled, Letter Present (A: Carrier, B: Weather, C: National Aviation System, D: Security) Scheduled Total Flight Time (in Minutes) Actual Total Elapsed Flight Time (in Minutes) Arriva DEST_CITY_NAME DEST_STATE_ABR DEST_STATE_NM CRS DEP TIME DEP TIME DEP DELAY CRS_ARR_TIME ARR TIME ARR_DELAY CANCELLED CANCELLATION_CODE CRS_ELAPSED_TIME ACTUAL ELAPSED TIME DISTANCE 3-Letter Airport Abbreviation Flight Arrival City, State Names Flight Arrival 2-Letter State Abbreviation Flight Arrival State Name Scheduled Departure Time (HHMM) (Single or 2-Digit Values Represent 00:MM, e.g. 3 represents 00:03 or 12:03 AM) Actual Departure Time (HHMM) Departure Delay (Difference Between Actual Departure Time and Scheduled Departure Time in Minutes) Scheduled Arrival Time (HHMM) (Single or 2-Digit Values Represent 00:MM, e.g. 3 represents 00:03 or 12:03 AM) Actual Arrival Time (HHMM) Arrival Delay (Difference Between Actual Arrival Time and Scheduled Arrival Time in Minutes) 0: Flight Not Cancelled, 1: Flight Cancelled Reason for Cancellation - if Cancelled, Letter Present (A: Carrier, B: Weather, C: National Aviation System, D: Securit Scheduled Total Flight Time (in Minutes) Actual Total Elapsed Flight Time (in Minutes) - Distance Between Departure and Arrival Airports (in Miles) Ln 1, Col 1 100% Wind A O BI 1 Type here to search 1 H RTER MONTH DAY_OF DAY OF MKT UNI MKT CAR ORIGIN 1 1 1 3 WN 4600 RDU 1 1 3 WN 5197 SJC 1 1 1 3 WN 5251 SMF 1 1 30 4 WN 2176 ONT 1 1 31 5 WN 1393 IND 1 1 31 5 WN 1389 LAS 1 1 31 5 WN 1371 MCO 1 1 31 5 WN 669 OGG 1 1 6 1 WN 1480 MSP 1 1 6 1 WN 1073 STL 1 1 7 2 WN 153 ATL 1 1 13 1 WN 1581 HOU 1 1 16 4 AA 3995 SCE 1 1 15 3 AA 4045 ORD 1 1 30 4 AA 4057 DFW 1 1 15 3 AA 4068 DFW 1 1 15 3 AA 4109 MIA 1 1 29 3 AA 4151 LSE 1 1 1 3 AA 4155 ORD 1 1 8 3 AA 4195 BTR 1 1 11 6 AA 4244 DAY 1 1 23 4 AA 4262 SRO iahtsJan2 Jun 2020 (1) J K L ORIGIN ORIGIN S ORIGIN S DEST Raleigh/D NC North Car MCO San Jose, CA California PDX Sacramen CA California LGB Ontario, CCA California LAS Indianapo IN Indiana ATL Las Vegas, NV Nevada HOU Orlando, FFL Florida BHM Kahului, HHI Hawaii HNL Minneapo MN Minnesot: BNA St. Louis, I MO Missouri PHX Atlanta, G GA Georgia RSW Houston, TX Texas DEN State Colle PA Pennsylva ORD Chicago, ILIL Illinois DBQ Dallas/For TX Texas SGF Dallas/For TX Texas FSM Miami, FL FL Florida PNS La Crosse, WI Wisconsin ORD Chicago, IIIL Illinois ATW Baton RouLA Louisiana DFW Dayton, O OH Ohio LGA Sarasota/EFL Florida DEW M N o P DEST CIT DEST STA DEST STA CRS DEP DE Orlando, FFL Florida 1215 Portland, OR Oregon 1830 Long Beac CA California 720 Las Vegas, NV Nevada 1045 Atlanta, G GA Georgia 1650 Houston, TX Texas 955 Birmingha AL Alabama 2000 Honolulu, HI Hawaii 1615 Nashville, TN Tennesse 1750 Phoenix, AZ Arizona 1610 Fort Myer FL Florida 1200 Denver, C CO Colorado 1655 Chicago, IIIL Illinois 1504 Dubuque, IA lowa 1502 Springfiel MO Missouri 2040 Fort Smith AR Arkansas 1242 Pensacola FL Florida 650 Chicago, IUIL Illinois 1142 Appleton, WI Wisconsin 1145 Dallas/For TX Texas 600 New York, NY New York 1127 Dallas/For TX Texas 1505 G H K L 20 1 1 P 23 4 AA Florida 4262 SRO 6126 IAH DFW 020 1 1 Texas 1505 30 4 UA 020 Texas 1 1 725 17 5 UA 6008 BNA 020 1300 1 1 31 5 UA 6008 IAD 845 020 1 12 7 UA 6064 IAH 803 020 1 1 9 Texas MAF Tennesse IAD Virginia BNA Texas DCA Ohio TAD North Car IAD Pennsylva IAH Hawaii HNL 4 UA 6165 CMH 615 020 1 24 5 UA 6079 CLT Virginia Tennesses Virginia Virginia Virginia Texas Hawaii Hawaii 1025 020 1 1 17 5 UA 6232 PHL 1236 020 1 4 HA 131 ITO 730 020 1 7 HA 321 ITO Hawaii HNL 1536 1 1 1 3 HA Hawaii HNL 1540 327 KOA 381 ITO M N Dallas/For TX Midland/CTX WashingtVA Nashville, TN WashingtVA Washingt&VA WashingtVA Houston, TX Honolulu, HI Honolulu, HI Honolulu, HI Honolulu, HI Honolulu, HI Lihue, HIHI Lanai, HI HI Philadelp PA Nashville, TN Charlotte, NC Chattanoc TN Philadelpl PA WashingtVA WashingtVA Kalispell, MT Hawaii Hawaii 1 1 12 Sarasota/IFL Houston, TX Nashville, TN WashingtVA Houston, TX Columbus OH Charlotte, NC Philadelpl PA Hilo, HI Hilo, HI HI Kona, HI Hilo, HI HI Hilo, HI HI Honolulu, HI Honolulu, HI Dayton, O OH Charlotte, NC Lexington KY Charlotte, NC Norfolk, VVA Albany, N NY Buffalo, N NY Seattle, WA 7 HA Hawaii HNL 1814 1 1 29 Hawaii HNL 2020 3 HA 6 HA 541 ITO 563 HNL Hawaii Hawaii 1 1 18 Hawaii LIH 2015 1 1 4 6 HA 664 HNL Hawaii LNY 020 020 2020 2020 2020 2020 2020 2020 2020 2020 2020 Hawaii 1533 1 1 7 2 AA 5015 DAY Ohio PHL 535 1 1 19 7 AA 5060 CLT 1757 1 1 1356 5 AA 3 5071 LEX 1800 1 1 30 4 AA 5076 CLT Pennsylva Tennesset North Car Tennesses Pennsylva Virginia Virginia Montana 800 North Car BNA Kentucky CLT North Car CHA Virginia PHL New York DCA New York DCA Washingto FCA 1 15 1 3 AA 5088 ORF 1142 1 1 25 6 AA 5118 ALB 1719 1 2020 1 29 5172 BUF 3 AA 1435 2020 2 2108 SEA 4 AS 1 1 Flights lan2 lun 2020 (1) - ... f fx G F E D C B A YEAR, QU 1 2020,1,1,1 2 2020,1,1,1 3 2020,1,1,1 4 2020,1,1,3 5 2020,1,1,3 6 2020,1,1,3 7 2020,1,1,3 8 2020,1,1,3 9 2020,1,1,6 10 2020,1,1,6 11 2020,1,1,7 12 2020,1,1,1 13 2020,1,1,1 14 2020,1,1,1 15 2020,1,1,3 16 2020,1,1,1 17 2020,1,1,1 18 2020,1,1,2 19 2020,1,1,1 20 2020,1,1,8 21 2020,1,1,1 22 2020,1,1,2 23 2020,1,1,3 24 2020,1,1,1 25 2020,1,1,3 26 2020,1,1,1 27 2020,1,1,9 28 2020,1,1,2 29 2020,1,1,1 30 2020,1,1,2 31 2020,1,1,5 32 2020,1,1,1 33 2020,1,1,1 34 2020,1,1,2 35 2020,1,1,1 36 2020,1,1,4 37 2020,1,1,7 38 2020,1,1,1 39 2020.1.1.3 40 Y EL > Jx G F E D B 40 A ZUZU, 1, 1, 2020,1,1, 41 2020,1,1,1 42 2020,1,1,2 43 2020,1,1,2 44 2020,1,1,2 45 2020,1,1,9 46 2020,1,1,1 47 2020,1,1,1 48 2020,1,1,1 49 2020,1,1,1 50 2020,1,1,1 51 2020,1,1,2 52 2020,1,1,2 53 2020,1,1,2 54 2020,1,1,2 55 2020,1,1,1 56 2020,1,1,2 57 2020,1,1,1 58 2020,1,1,4 59 2020,1,1,2 60 2020,1,1,1 61 2020,1,1, 62 2020,1,1,2 63 2020,1,1,1 64 2020,1,1,1 65 2020,1,1,9 66 2020,1,1,1 67 2020,1,1,9 68 2020,1,1,1 69 2020,1,1,1 70 2020,1,1,2 71 2020,1,1,6 72 2020,1,1,2 73 2020,1,1,4 74 2020,1,1,2 75 2020,1,1,2 76 2020,1,1,2 77 2020,1,1,3 78 2020,1,1,2 79 2020,1,1,1 80 2020,1,1,2 81 2020,1,1,1 82 2020,1,1,1 83 2020,1,1,1 84 2020.1.1.2 85 a A EJ Jx G F E D B = A ZUZU, 1, 1,2 123 2020,1,1,2 124 2020,1,1,2 125 2020,1,1,2 126 2020,1,1,1 127 2020,1,1, 128 2020,1,1,1 129 2020,1,1,1 130 2020,1,1,1 131 2020,1,1,2 132 2020,1,1,2 133 2020,1,1,1 134 2020,1,1,5 135 2020,1,1,4 136 2020,1,1,3 137 2020,1,1,3 138 2020,1,1,3 139 2020,1,1,3 140 2020,1,1,2 141 2020,1,1,2 142 2020,1,1,2 143 2020,1,1,2 144 2020,1,1,1 145 2020,1,1,1 146 2020,1,1,2 147 2020,1,1,2 148 2020,1,1,8 149 2020,1,1,1 150 2020,1,1,1 151 2020,1,1,1 152 2020,1,1,3 153 2020,1,1,6 154 2020,1,1,2 155 2020,1,1,2 156 2020,1,1,2 157 2020,1,1,1 158 2020,1,1,2 159 2020,1,1,2 160 2020,1,1,2 161 2020,1,1,1 162 2020,1,1,2 163 2020,1,1,1 164 2020,1,1,4 165 2020,1,1,1 166 2020,1,1,2 167 2020 1.1 168 4 > Jx G E D B A . 2020,1,1,2 167 2020,1,1,4 168 2020,1,1,2 169 2020,1,1, 170 2020,1,1,4 171 2020,1,1,4 172 2020,1,1,4 173 2020,1,1,1 174 2020,1,1,1 175 2020,1,1,1 176 2020,1,1,1 177 2020,1,1,1 178 2020,1,1,1 179 2020,1,1,1 180 2020,1,1,3 181 2020,1,1,1 182 2020,1,1,1 183 2020,1,1,2 184 2020,1,1,1 185 2020,1,1,2 186 2020,1,1,1 187 2020,1,1,1 188 2020,1,1,1 189 2020,1,1,5 190 2020,1,1,7 191 2020,1,1,1 192 2020,1,1,8 193 2020,1,1,3 194 2020,1,1,2 195 2020,1,1,2 196 2020,1,1,2 197 2020,1,1,1 198 2020,1,1,1 199 2020,1,1,1 200 2020,1,1, 201 2020,1,1,1 202 2020,1,1,3 203 2020,1,1,1 204 2020,1,1,2 205 2020,1,1,1 206 2020,1,1,1 207 2020,1,1,1 208 2020,1,1,1 209 2020,1,1,1 210 2020,1,1,3 211 2020 1 11 212 a EL Jx G F E D B 40 A ZUZU, 1, 1, 2020,1,1, 41 2020,1,1,1 42 2020,1,1,2 43 2020,1,1,2 44 2020,1,1,2 45 2020,1,1,9 46 2020,1,1,1 47 2020,1,1,1 48 2020,1,1,1 49 2020,1,1,1 50 2020,1,1,1 51 2020,1,1,2 52 2020,1,1,2 53 2020,1,1,2 54 2020,1,1,2 55 2020,1,1,1 56 2020,1,1,2 57 2020,1,1,1 58 2020,1,1,4 59 2020,1,1,2 60 2020,1,1,1 61 2020,1,1, 62 2020,1,1,2 63 2020,1,1,1 64 2020,1,1,1 65 2020,1,1,9 66 2020,1,1,1 67 2020,1,1,9 68 2020,1,1,1 69 2020,1,1,1 70 2020,1,1,2 71 2020,1,1,6 72 2020,1,1,2 73 2020,1,1,4 74 2020,1,1,2 75 2020,1,1,2 76 2020,1,1,2 77 2020,1,1,3 78 2020,1,1,2 79 2020,1,1,1 80 2020,1,1,2 81 2020,1,1,1 82 2020,1,1,1 83 2020,1,1,1 84 2020.1.1.2 85 a A EJ Jx G F E D B = A ZUZU, 1, 1,2 123 2020,1,1,2 124 2020,1,1,2 125 2020,1,1,2 126 2020,1,1,1 127 2020,1,1, 128 2020,1,1,1 129 2020,1,1,1 130 2020,1,1,1 131 2020,1,1,2 132 2020,1,1,2 133 2020,1,1,1 134 2020,1,1,5 135 2020,1,1,4 136 2020,1,1,3 137 2020,1,1,3 138 2020,1,1,3 139 2020,1,1,3 140 2020,1,1,2 141 2020,1,1,2 142 2020,1,1,2 143 2020,1,1,2 144 2020,1,1,1 145 2020,1,1,1 146 2020,1,1,2 147 2020,1,1,2 148 2020,1,1,8 149 2020,1,1,1 150 2020,1,1,1 151 2020,1,1,1 152 2020,1,1,3 153 2020,1,1,6 154 2020,1,1,2 155 2020,1,1,2 156 2020,1,1,2 157 2020,1,1,1 158 2020,1,1,2 159 2020,1,1,2 160 2020,1,1,2 161 2020,1,1,1 162 2020,1,1,2 163 2020,1,1,1 164 2020,1,1,4 165 2020,1,1,1 166 2020,1,1,2 167 2020 1.1 168 4 > Jx G E D B A . 2020,1,1,2 167 2020,1,1,4 168 2020,1,1,2 169 2020,1,1, 170 2020,1,1,4 171 2020,1,1,4 172 2020,1,1,4 173 2020,1,1,1 174 2020,1,1,1 175 2020,1,1,1 176 2020,1,1,1 177 2020,1,1,1 178 2020,1,1,1 179 2020,1,1,1 180 2020,1,1,3 181 2020,1,1,1 182 2020,1,1,1 183 2020,1,1,2 184 2020,1,1,1 185 2020,1,1,2 186 2020,1,1,1 187 2020,1,1,1 188 2020,1,1,1 189 2020,1,1,5 190 2020,1,1,7 191 2020,1,1,1 192 2020,1,1,8 193 2020,1,1,3 194 2020,1,1,2 195 2020,1,1,2 196 2020,1,1,2 197 2020,1,1,1 198 2020,1,1,1 199 2020,1,1,1 200 2020,1,1, 201 2020,1,1,1 202 2020,1,1,3 203 2020,1,1,1 204 2020,1,1,2 205 2020,1,1,1 206 2020,1,1,1 207 2020,1,1,1 208 2020,1,1,1 209 2020,1,1,1 210 2020,1,1,3 211 2020 1 11 212 a EL