Grading Rubric

The flights data frame from the nycflights13 package.

1. Load and review the data

   • Load the tidyverse nycflights 13 packages
   • Load the flights data frame
   • What are the variables
   • How many observations (rows) are there?

2. Worst Plane to Fly

• Which planes (tailnum) have the three worst (highest) average departure delay record?
  • How many flights did each make?
  • Now only look at the tailnums where each flew more than 12 flights and find the three tailnums with the highest average departure delay and show the tailnums with their average departure delay and number of flights.

3. Best Time of Day to Fly

   • Use a plot to see what hour of the day you should fly to minimize your expected (average) delay time. Which time is best?

   • Which time is best?

4. Worst Flight Numbers for each Destination

   • In a single series of steps, with no intermediate variables, complete the following steps in one set of piped code to produce a single output:

     1. For each destination, compute the total minutes of arrival delay, then use that result to:
     2. Compute for each trip (observation) to a destination its proportion of the total arrival delay for the destination; then use that result to
     3. Sort by destination, alphabetically, and from the highest to lowest proportion of total delay for each destination; then use that result to
     4. Choose for each trip, the destination, total arrival delay, flight number, proportion of the delay, number of trips, and the year, month, and day of departure; then use that result to
     5. Show the worst trip for each destination (where the delay is the maximum for the destination) with total arrival delay >= 0.

   • Extra Credit (1 pt), Repeat but instead of the worst trip for a destination,

   • Replace step 2 with Compute for each flight number to a destination. step 4, choose for each flight number, and step 5 Show the worst flight number …

5. Destinations with Multiple Carriers from NYC Area

   • Find all destinations that are flown to by at least two carriers. Of these, show the destination airports that have the most carriers flying into them from any of the NYC airports. (hints: distinct() or n_distinct() will help here, your final data frame will have 5 rows. )

Star Wars Characters

The starwars data frame in the dplyr package contains demographic characteristics of various characters from the hit franchise Star Wars.

1. Load the data into R and load any necessary packages

2. Use appropriate R code to determine which individuals have missing gender. Make sure to only print out their names and heights, arranged in ascending order of height.

3. Change their gender to "droid" (even if they are not droids) and save to a new dataframe named starwars_clean.

4. Use across to calculate the median and mean of both height and mass for each gender of starwars_clean show the results.

5. The body mass index (BMI) is defined as $$ BMI = \frac{\text{mass}{\text{kg}}}{\text{height}{m}^2} $$.

   • That is, the BMI is the weight of the individual (in kg) divided by the height of the individual (in m) squared. There are 100 cm in each m.
   • Calculate the BMI for each individual in the starwars data frame and add it to the starwars_clean data frame.
   • Sanity check: The median BMI should be in the 20-30 range.

6. Make boxplots of gender vs BMI from starwars_clean. Include only masculine, feminine, and droids. Use the black and white theme.

7. Make scatterplots of height vs mass, faceting by gender.

8. Reproduce the following plot (hint: filter based on birth year):