Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
2a. Can you join table flights and weather to generate a new table flights.weather so that we have weather information at departure location for each
2a. Can you join table flights and weather to generate a new table flights.weather so that we have weather information at departure location for each flight in flights.weather. 2b. We can use flights.weather to study how precipitation affects flights. Is there a correlation between precipitation and departure delays? Does precipitation affect flight speed? You might want to use ggplot to show scatter plots and calculate the Pearson correlation coefficient. 2c. The departure delay might also depend on carrier of each flight. Can you use table flights to find the average departure delay for each carrier? Which carrier has the longest departure delay? 2d. Can you list all the tail number of planes (in table flights) owned by the carrier identified in 2c.? What are the models of these planes? What is average number of seats in these planes
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started