Question: need help with this r code 91 92 93. ###N Step 7) (10 points) Starting with data set NYC, create a new column to calculate

need help with this r code need help with this r code 91 92 93. \#\#\#N Step 7)

91 92 93. \#\#\#N Step 7) (10 points) Starting with data set NYC, create a new column to calculate the total delay which is the sum of the arrival and departure delays, and display a table to report only the smallest total delay, the longest total delay, and the average total delay. Notice that in step 4 , the ouput of the summary O command shows you that both the dep delay and arrdelay columns have missing data (NAs). For your calculations to work, you can only include flights for which both dep_delay and arr_delay are available. Steps needed: 94 * drop_na; remove dep_delay and arr_delay entries listed as NA. You can do this in one drop naO) command by separating the variables with commas, i.e., drop na(variable 1 , variable 2). 95 " mutate; Create a new column called tota7_delay where you add up the arrival and departure delays. 96 - sumarise; use the proper conmands inside of summarise to find the shortest, longest, and average total delays. Create unique names for these columns. 97. If done correctly, you wi 17 find the shortest total delay is 100 (meaning the two delays for this flight totaled 100 min early), the longest delay is 2,573 minutes (wouldn't want to be on that flight!), and the average delay is 19.45min

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!