Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help with this r code 14 16. #NH step 8) (10 points) Starting with data set NYC, find the percentage of flights each month

need help with this r code image text in transcribed
14 16. \#NH step 8) (10 points) Starting with data set NYC, find the percentage of flights each month that arrived late at their destination. Arrange the table so that you show the month with the lowest percentage of arrival delays in the top row (showing you the best months to fly!). Round the percentage to 0 decimal places. Again, since the arr delay column includes NA data, you mush remove a11 NAs first for your calculations to work. Steps needed: drop_na; remove flights with missing arr_delay - group by; determine your grouping variable - summarise; create three columins inside of the summarise command to find: * the total number of flights each month for which arrival delay information was recorded, " the number of flights that arrived late (Hint: use sum() to count the number of flights with arr_delay>0 which means that the flight arrived late)! * and the percent of flights that arrived late (\# flights with delayed arrival /total \# of flights * 100 ) * round the percentage to 0 decimal places. - arrange; sort from the lowest to highest percentage of flights with delayed arrivals with 25%. * If done correctly, september will be the month with the month in the top row with the shortest percent of delayed arrivals (25\%)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Current Trends In Database Technology Edbt 2004 Workshops Edbt 2004 Workshops Phd Datax Pim P2panddb And Clustweb Heraklion Crete Greece March 2004 Revised Selected Papers Lncs 3268

Authors: Wolfgang Lindner ,Marco Mesiti ,Can Turker ,Yannis Tzitzikas ,Athena Vakali

2005th Edition

3540233059, 978-3540233053

More Books

Students also viewed these Databases questions

Question

How is expected return for one security determined for a portfolio?

Answered: 1 week ago

Question

5. Identify three characteristics of the dialectical approach.

Answered: 1 week ago