1. This dataset represents 10% of the flights within the U.S. during the month of October 2022. Approximately how many total flights within the U.S. were there in October 2022 (including those not in this 10% sample)? And show your calculation.
   1. Recommended Visualization: Any
   2. Hint: (Try histogram to start, and notice how the "Show Me" pane options change when Tableau automatically calculates a Binned and Count version of the count variable found near the bottom of the measures list; you may need to expand the variable names since count shows up at the last of the variable name; this is an auto-generated variable)

GIVEN THE DATA POINTS, PLEASE GUIDE ME TO WHAT MEASURE NEED TO BE PULLED INTO THE CHART TO MAKE THE NECESSARY GRAPH IN TABLEAU TO ANWER THE QUESTION ABOVE.

 

• FL_DATE: Date of flight 
• CARRIER_Description: Name of airline 
• ORIGIN_CITY_NAME: Name of the city or metropolitan area served by the airport the flight originated from 
• ORIGIN_STATE_ABR: State or territory the originating airport is located in 
• DEST_CITY_NAME, DEST_STATE_ABR: As above, but for the destination airport 
• DEP_DELAY: Delay in minutes past the scheduled departure (negative indicates early departure) 
• DEP_DEL15: A binary value with 1 indicating the flight's departure was delayed 15 minutes or more, and 0 indicating the flight was not delayed 15 minutes or more; this is really a categorical variable not a measured variable. However, it can be used as a measured variable to count the number of delays. 
• ARR_DELAY, ARR_DEL15: As above, but related measured relative to scheduled arrival time 
• AIR_TIME: flight time, in minutes 
• DISTANCE: Distance between airports, in miles 
• CARRIER_DELAY: minutes of delay attributed to carrier 
• WEATHER_DELAY: minutes of delay attributed to weather 
• NAS_DELAY: minutes of delay attributed to the National Air System 
• SECURITY_DELAY: minutes of delay attributed to security (e.g. evacuated terminals or lines at security screenings in excess of 29 minutes) 
• LATE_AIRCRAFT_DELAY^[1]: minutes of delay attributed to a late-arriving aircraft

 

Transcribed Image Text:

Data Search Tables # Airline Id Abc Cancellation Code Abc Carrier Abc CARRIER Description Abc Dest # Dest Airport Id # Dest Airport Seq ld # Dest City Market Id ( Analytics AirlineDelays (7) (Airline... Dest City Name Dest State Abr FI Date Abc Origin # Origin Airport Id # Origin Airport Seq ld ( OY CON # Origin City Market Id Origin City Name Origin State Abr Abc Unique Carrier Abc Measure Names # # # # # # Air Time Arr Del15 Arr Delay Arr Delay New Cancelled Carrier Delay # Dep Dell5 # Dep Delay #Dep Delay New # Distance # Diverted # Late Aircraft Delay # Nas Delay # # (CT) Security Delay Weather Delay AirlineDelays (7) (Count) Latitude (generated) Longitude (generated) # Measure Values Data Search Tables # Airline Id Abc Cancellation Code Abc Carrier Abc CARRIER Description Abc Dest # Dest Airport Id # Dest Airport Seq ld # Dest City Market Id ( Analytics AirlineDelays (7) (Airline... Dest City Name Dest State Abr FI Date Abc Origin # Origin Airport Id # Origin Airport Seq ld ( OY CON # Origin City Market Id Origin City Name Origin State Abr Abc Unique Carrier Abc Measure Names # # # # # # Air Time Arr Del15 Arr Delay Arr Delay New Cancelled Carrier Delay # Dep Dell5 # Dep Delay #Dep Delay New # Distance # Diverted # Late Aircraft Delay # Nas Delay # # (CT) Security Delay Weather Delay AirlineDelays (7) (Count) Latitude (generated) Longitude (generated) # Measure Values

Answer rating: 100% (QA)

To answer the question about the total number of flights within the US for October 2022 using the da... View the full answer