In this lab we explore flights, specifically a random sample of domestic flights that departed from the three major New York City airports in 2013.

We will generate simple graphical and numerical summaries of data on these flights and explore delay times. You can find the instructions for this lab here.

Exercise 1

Question: Experiment with different binwidths to adjust your histogram in a way that will show its important features. You may also want to try using the + scale_x_log10() . What features are revealed now that were obscured in the original histogram? Note: When using the log scale, you may need to experiment with bin widths that are smaller than 1, such as binwidth=0.1 or even less!

Answer: Negative times are when the plane was earlier than expected. This could be due to for example a good tailwind.

Using Log, you can see much more clearly that most delays occur between 10 and 100. In the normal histgram this is not so clear. There it seems like most flight have no delays.

Exercise 2

Question: Create a new data frame that includes flights headed to SFO in February, and save this data frame as sfo_feb_flights. How many flights meet these criteria? Try using the function nrow() inside of inline code in your answer, and knit your file to see that your text shows the answer correctly.

Answer:

text <- paste("There were", nrow(sfo_feb_flights), "flights on SFO in February")
print(text)
## [1] "There were 68 flights on SFO in February"

Exercise 3

Question: Describe the distribution of the arrival delays of flights headed to SFO in February, using an appropriate histogram and summary statistics. Hint: The summary statistics you use should depend on the shape of the distribution.

# Insert code for Exercise 3 here

sfo_feb_flights %>%  
    summarise(median_ad   = median(arr_delay), 
            n         = n())
ggplot(data = sfo_feb_flights, aes(x = arr_delay)) +  
  geom_histogram(binwidth = 10) +
  labs(x = "Arrival delay (min)", y = "Amount of flights")

Answer:

Right skewed distribution. 50% 11 minutes before schedule arrival.

Exercise 4

Question: Calculate the median and interquartile range for arr_delays of flights in in the sfo_feb_flights data frame, grouped by carrier. Which carrier has the most variable arrival delays?

# Insert code for the Exercise here

sfo_feb_flights %>%
  group_by(carrier) %>%
  summarise(median_ad = median(arr_delay), iqr_ad = IQR(arr_delay), n_flights = n())

Answer: Most variable arrival delays were United Airlines and Delta Airlines.

Exercise 5

Question: Create a list of origin airports and their rate of on-time-departure. Then visualize the distribution of on-time-departure rate across the three airports using a segmented bar plot (see below). If you could select an airport based on on time departure percentage, which NYC airport would you choose to fly out of? Hint: For the segmented bar plot, will need to map the aesthetic arguments as follows: x = origin, fill = dep_type and a geom_bar() layer. Create three plots, one with geom_bar() layer, one with geom_bar(position = "fill") and the third with geom_bar(position = "dodge"). Explain the difference between the three results.

# Insert code for the Exercise here

nycflights <- nycflights %>%
  mutate(dep_type = ifelse(dep_delay < 5, "on time", "delayed"))

nycflights %>%
  group_by(origin) %>%
  summarise(on_time_dep_rate = sum(dep_type == "on time") / n()) %>%
  arrange(desc(on_time_dep_rate))
ggplot(data = nycflights, 
       aes(x = origin, fill = dep_type)) +
  geom_bar()

ggplot(data = nycflights, 
       aes(x = origin, fill = dep_type)) +
  geom_bar(position = "fill")

ggplot(data = nycflights, 
       aes(x = origin, fill = dep_type)) +
  geom_bar(position = "dodge")

I would choose LGA airport. geombar() deals with absolute numbers, while fill shows the results relative from the total number of flights. This is much more useful in this case. The dodge function makes the bars of the histogram stand next to each other.

Exercise 6

Question: Mutate the data frame so that it includes a new variable that contains the average speed, avg_speed traveled by the plane for each flight (in mph, or if you are brave, in km/h). Now make a scatterplot of avg_speed vs. distance. Describe the relationship between average speed and distance. Hint: Average speed can be calculated as distance divided by number of hours of travel, and note that air_time is given in minutes. You will need to use geom_point(). Think carefully which of the two variables is the predictor (on the x-axis) and which is the outcome variable (on the y-axis) and explain why you made this choice. Describe the relationship between average speed and distance.

# Insert code for the Exercise here

nycflights <- nycflights %>%
  mutate(air_time_hours = air_time / 60,
         avg_speed = distance / air_time_hours)

ggplot(data = nycflights, 
       aes(x = distance, y = avg_speed)) +
  geom_point() +
  labs(x = "Distance (miles)", y = "Average speed (mph)")

Answer: I chose to place distance on the X-axis since speed cannot influence distance, but distance influences the speed that pilots will fly at. Your cruising speed will be much higher if you make a long flight, since you do not immediately have to stop to land.

Exercise 7

Question: Replicate the following plot and determine what is the cutoff point for the latest departure delay where you can still have a chance to arrive at your destination on time. Hint: The data frame plotted only contains flights from American Airlines, Delta Airlines, and United Airlines, and the points are colored by carrier. To determine the cut off point, try scaling the x-axis and the y-axis on the logarithmic scale. You can also filter the data, so that you plot only data where arr_delay <= 0.

# Insert code for the Exercise here

flights_on_time <- nycflights %>%
  filter(carrier %in% c("AA", "DL", "UA") & arr_delay <= 0)

custom_colors <- c("AA" = "#FFFF00", "DL" = "#40E0D0", "UA" = "#FF69B4") 

flights_on_time %>%
  ggplot(aes(x = dep_delay, y = arr_delay, color = carrier)) +
  geom_point(alpha = 0.7, size = 2) +  
  scale_color_manual(values = custom_colors) +
  labs(
    x = "Departure delay (min)", 
    y = "Arrival delay (min)",
    title = "Scatter Plot of Arrival Delay vs Departure Delay",
    subtitle = "Flights operated by AA, DL, and UA"
  ) +
  theme_minimal() +  
  theme(
    plot.title = element_text(size = 16, face = "bold"), 
    plot.subtitle = element_text(size = 12, face = "italic"),  
    axis.title = element_text(size = 12, face = "bold"),  
    legend.position = "right"  
  )

Answer:

text <- paste("Cutoff latest departure delay and still have a chance to arrive on time is ", flights_on_time %>%  summarise(max_ot = max(dep_delay)))
print(text)
## [1] "Cutoff latest departure delay and still have a chance to arrive on time is  63"