POW_airports

Airport (Airport Code) Total Passengers (Millions) Z-scores Boston Logan (BOS) 36.3 -0.864669994453688 Charlotte Douglas (CLT) 44.4 -0.415141430948419 Chicago O'Hare (ORD) 78 1.44841930116473 Dallas/Ft. Worth (DFW) 65.7 0.766222961730449 Denver (DEN) 58.3 0.35579589572934 Detroit Metropolitan (DTW) 34.4 -0.969772601220189 Hartsfield-Jackson Atlanta (ATL) 104.2 2.90155296727676 Houston George Bush (IAH) 41.6 -0.570438158624514 Las Vegas McCarran (LAS) 47.5 -0.243205768164171 Los Angeles (LAX) 80.9 1.60926234054354 Miami (MIA) 44.6 -0.404048807542984 Minneapolis/St. Paul (MSP) 37.4 -0.803383250138658 New York John F. Kennedy (JFK) 59.1 0.400166389351082 Newark Liberty (EWR) 40.6 -0.625901275651691 Orlando (MCO) 41.9 -0.553799223516362 Philadelphia (PHL) 36.4 -0.858846367165835 Phoenix Sky Harbor (PHX) 43.3 -0.476150859678314 San Francisco (SFO) 53.1 0.06738768718802 Seattle-Tacoma (SEA) 45.7 -0.343039378813089 Toronto Pearson (YYZ) 44.3 -0.420687742651137 MAX MIN MEAN 104.2 34.4 51.885

STANDARD DEVIATION Q1 Q3 MEDIAN IQR 18.0279395734276 40.85 58.9 44.5 18.05 This chart isn’t available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.

Questions: The busiest airport is Hartsfield-Jackson Atlanta (ATL) with 104.2 million total passengers. The least busy airport is Detroit Metropolitan (DTW) with 34.4 million total passengers. There is an outlier, the dot in the box-plot graph indicates an outlier, which is Hartsfield-Jackson Atlanta ai Mean = 51.885 Standar Deviation = 18.02793957 Z-scores (in sheet 1) Yes, there are airports with z-values of approximately +3 which is Hartsfield-Jackson Atlanta (ATL) airpo Qs. 1 Which is busiest airport in terms of total passenger traffic? Which is the least busy airport in terms of Qs. 2 Draw a box plot. Add data labels, axis titles and chart titles.  Examine the plot visually. Are there any Qs. 3 Calculate the mean and sample standard deviation. Calculate the z-scores. Are there any airports with This chart isn’t available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.

iport, with 104.2 million total passengers. ort with 2.901552967 as its z-scores. f total passenger traffic? y outliers? Which airport/s seem to be outliers? h z-values of approximately +3 or more or -3 or less? These are the outliers. Which airport/s seem to be out