Description
Exercises for All Students
1) This exercise is for aggregate departure delay information for flights from 1987 to 1989
in the data.
a) Using SQL, obtain the total number of flights in the data in the 1980s.
b) Using SQL, obtain the number of flights with departure delayed by more than 15
minutes in the 1980s in the data.
c) Comment on the percentage of flights with departure delayed by more than 15
minutes during that time period.
2) Now we look at the similar delay information by month during that period. (Note: This is
just by month, not by month and year. For instance, flights for January 1987, January
1988, and January 1989 will be aggregated together.)
a) Obtain a table for the total number of flights in our data by month in the 1980s from
the data.
b) In a separate table, obtain the number of flights by month with departure delayed
by more than 15 minutes in the 1980s in the data.
c) From the results in parts a and b, programmatically calculate the percentage of
flights delayed by more than 15 minutes by month of year during that time period,
and comment on how the monthly rates compare to the overall rate found in
exercise 1.
3) Now we look at aggregate flight data for 2007 and 2008.
a) Obtain the total number of flights in 2007 and 2008, the number of flights delayed
by more than 15 minutes during that time period, and the percentage of flights
delayed by more than 15 minutes during that time period.
b) Comment on how this delay rate compares with the rate found for the 1987-1989
flights.
4) Now we look at the delay rate per year for 2007 and 2008.
a) For each year from 2007 to 2008, calculate the number of flights and the number of
flights delayed by more than 15 minutes. (You should have counts for 2007 and
counts for 2008.) Be sure to use efficient programming techniques.
b) Compute the percentage of flights with departure delayed by more than 15 in each
of those two years and compare the annual rates with the aggregate rate found in
exercise 3.
Additional Exercises for Graduate Students
5) This exercise is to compare delay rates by day of week from 1987 to 1989 with delay
rates by day of week from 2007 to 2008 within the data provided.
a) Calculate the percentage of flights delayed by more than 15 minutes for each day of
the week for the period from 1987 to 1989 in the data provided.
b) Repeat part a for 2007 and 2008 data.
c) Comment on similarities and differences in the delay rate on particular days of
week between the two time periods.
STAT 480
