Admistrative:

Please indicate

  • Who you collaborated with: Amanda Hotvedt, Nina Sonneborn, Kyra Gray,
  • Roughly how much time you spent on this HW so far: ~11 hours
  • The URL of the RPubs published URL here.
  • What gave you the most trouble:

Mostly debugging issues and practicing using each function correctly and in the right context.

  • Any comments you have:

Question 1:

Plot a “time series” of the proportion of flights that were delayed by > 30 minutes on each day. i.e.

  • the x-axis should be some notion of time
  • the y-axis should be the proportion.

Using this plot, indicate describe the seasonality of when delays over 30 minutes tend to occur.

The time series plot depicting the proportion of flights per day leaving Houston that are delayed by over 30 minutes indicates that these types of delays occur most frequently in the winter and spring months, specifically January through June. The proportion of delays over 30 minutes dips for the months of August through November.

It is important to note that flights with missing delay values were not considered in the analysis of the data set. The eliminated values represented roughly 1.3% of the data set, or 2,905 out of 224,591 entries.

Question 2:

Some people prefer flying on older planes. Even though they aren’t as nice, they tend to have more room. Which airlines should these people favor?

carrier avg_age SD # of planes
MQ 34.3 3.2 55
AA 29.3 6.1 1368
DL 25.7 8.4 2573
US 24.1 6.1 3830
UA 19.6 4.2 2013
WN 18.0 7.1 44054
XE 15.6 2.8 71023
CO 14.9 6.2 67804
FL 13.9 3.7 1939
YV 12.1 2.2 78
F9 12.1 1.9 814
EV 11.4 3.5 2066
OO 11.0 2.7 15541
NA 11.0 3.5 6
AS 10.4 3.5 363
B6 9.9 2.5 648

Passengers who enjoy flying on older planes should favor Envoy Air, American Airlines, Delta, and US Airways, as these airlines have the oldest planes, on average. Notably, Envoy Air is a wholly owned subsidiary of American Airlines.

Question 3:

  • What states did Southwest Airlines’ flight paths tend to fly to?
  • What states did Southwest Airlines’ flights tend to fly to?

For example, Southwest Airlines Flight 60 to Dallas consists of a single flight path, but since it flew 299 times in 2013, it would be counted as 299 flights.

Number of SW Flight Paths From Houston Arriving in Each State
state number of flight paths
TX 767
FL 297
LA 236
CA 219
OK 178
IL 163
NV 123
CO 121
TN 107
AZ 106
MO 101
NM 80
MD 79
MS 78
AL 52
NA 52
SC 43
PA 35
AR 28
NJ 26
Number of SW Flights From Houston Arriving in Each State
state number of flights
TX 16709
FL 3977
LA 3343
CA 2777
OK 2319
IL 2072
NV 1536
CO 1435
TN 1371
AZ 1365
MO 1319
MD 1217
NM 1014
MS 1012
NA 727
AL 685
SC 588
PA 434
NJ 385
AR 361

Southwest flight paths from Houston tend to fly to other cities in Texas. After texas, Southwest flights tend to fly to Florida, Louisiana, California, and Oklahoma.

Similarly, Southwest flights from Houston follow the same pattern, flying most frequently to other cities in Texas and then to Florida, Louisiana, California, and Oklahoma.

Question 4:

I want to know proportionately what regions (NE, south, west, midwest) each carrier flies to/from Houston in the month of July. Consider the month() function from the lubridate package.