Airport.Code	Airport.Name	Statistics.Flights.Delayed
ATL	Atlanta, GA: Hartsfield-Jackson Atlanta International	4331
BOS	Boston, MA: Logan International	1970
BWI	Baltimore, MD: Baltimore/Washington International Thurgood Marshall	1266
CLT	Charlotte, NC: Charlotte Douglas International	1500
DCA	Washington, DC: Ronald Reagan Washington National	1221
DEN	Denver, CO: Denver International	3885
DFW	Dallas/Fort Worth, TX: Dallas/Fort Worth International	5293
DTW	Detroit, MI: Detroit Metro Wayne County	1704
EWR	Newark, NJ: Newark Liberty International	1865
FLL	Fort Lauderdale, FL: Fort Lauderdale-Hollywood International	1414
IAD	Washington, DC: Washington Dulles International	855
IAH	Houston, TX: George Bush Intercontinental/Houston	2684
JFK	New York, NY: John F. Kennedy International	2009
LAS	Las Vegas, NV: McCarran International	1924
LAX	Los Angeles, CA: Los Angeles International	3024
LGA	New York, NY: LaGuardia	2616
MCO	Orlando, FL: Orlando International	2074
MDW	Chicago, IL: Chicago Midway International	1240
MIA	Miami, FL: Miami International	1448
MSP	Minneapolis, MN: Minneapolis-St Paul International	1578
ORD	Chicago, IL: Chicago O'Hare International	6551
PDX	Portland, OR: Portland International	632
PHL	Philadelphia, PA: Philadelphia International	1314
PHX	Phoenix, AZ: Phoenix Sky Harbor International	2226
SAN	San Diego, CA: San Diego International	1030
SEA	Seattle, WA: Seattle/Tacoma International	1544
SFO	San Francisco, CA: San Francisco International	2850
SLC	Salt Lake City, UT: Salt Lake City International	1191
TPA	Tampa, FL: Tampa International	1118

The excel document attached to this assignment has data on the number of delayed flights at 29 major US Airports (month of January 2015). In that excel document, you should create three worksheets that are similar to the example used in class on Tuesday the 11th. Follow that template as closely as possible. Clearly label what each value represents. Part 1: Calculate the following Summary Statistics: a) Mean (Sample) b) Median c) Variance d) Standard Deviation (Sample) e) Minimum f) Maximum g) Range

Part 2 Calculate the following, to get a confidence interval a) Sample mean b) Sample standard deviation c) Sample size d) Critical value (t) e) Standard Error f) Margin of error g) Lower end of 95% confidence interval h) Upper end of 95% confidence interval Part 3: Calculate the following, to test a null hypothesis. The null hypothesis I want you to evaluate is that "the population mean of delayed flights is 2700". Conduct a two tailed test (so the alternative is that it is not equal to 2700). Use a 10% significance level (until parts h and i) to evaluate your null hypothesis. a) Sample mean b) Sample standard deviation c) Sample size d) Calculate the test statistic e) Find the p-value f) Do you reject or fail to reject? g) Interpret your finding h) In the excel document (not here), state whether you would have reached the same conclusion at the 5% significance level? i) What about the 1%?