*NOTE that the excel file could not be attached onto this question but I have uploaded flight_delays_2020.xlsx is on my courshero profile account.* ALL answers must be shown through excel

The Excel file flight_delays_2020.xlsx has data on arrival and departure delays for every flight that departed from Los Angeles International Airport (LAX) to New York City (JFK) in February 20202 . We say that a flight departed late if it left the gate at LAX with a delay of 15 minutes or longer. A flight arrived late if it arrived at the gate at JFK with a delay of 15 minutes or longer. A flight that is not late is on time.

1. Calculate the mean, median, mode, standard deviation, variance, minimum, maximum, range, IQR of the departure delay and of the arrival delay.

2. What was the fraction of flights that

A. departed on time and arrived on time?

B. departed on time but arrived late?

C. departed late but arrived on time?

D. departed late and arrived late? (Make sure that the sum of a., b., c. and d. is 1.)

Hint: You may find useful to fill out columns D through I by using the Excel functions =SUM( ) =IF(logical_test, [value_if_true], [value_if_false]) =AND(logical1, logical2)

3. Do the data for this flight support Mr. Kolshak's Assertion that flights that depart on time tend to arrive on time? If you only look at the flights that departed LAX on time, what was the fraction of flights that arrived at JFK on time? Compare this with the fraction of flights that arrived on time out of all the flights that departed late, and with the fraction of flights that arrived on time out of all flights.