Question

As an analyst at American Airlines, your boss has asked you to evaluate the taxi out times built into the airline's schedule for departures out of Salt Lake International Airport.

for American Airlines (AA) out of Salt Lake International Airport (SLC) during the first quarter (January through March).

Calculate the mean, median, mode and standard deviation of taxi out times (taxi_out) using the =average(), =median(), =mode() and =stdev() functions in the Excel spreadsheet.

Answer the following questions about the implications on AA's operations at SLC.

Q1. What is the mean taxi out time in minutes for American Airlines (AA) flights departing Salt Lake City (SLC) in the first quarter (1Q) of 2015? (Round to the nearest 1/10th)

Q2 What is the median taxi out time in minutes for American Airlines (AA) flights departing Salt Lake City (SLC) in the first quarter (1Q) of 2015?

Q3 What is the mode of taxi out times in minutes for American Airlines (AA) flights departing Salt Lake City (SLC) in the first quarter (1Q) of 2015?

Q4. What is the standard deviation of taxi out times in minutes for American Airlines (AA) flights departing Salt Lake City (SLC) in the first quarter (1Q) of 2015? (Round to the nearest 1/10th)

Q5. Your boss would like to know how many minutes should be built into the 2016Q1 schedule for taxi out times at SLC. Which value would be the best to use for future schedules and why? Select all the true statements below.

Mean would be best because it represents the average taxi out time.

Median would be best because it represents the middle value of all taxi out times.

Mode would be best because it represents the most common taxi out times.

There is significant variation in taxi out times because the mean, median and mode are all not close.

The higher mean relative to median and mode indicates unusually long taxi times inflate the average.

The median and mode are both within one standard deviation of the mean, implying that they are not unusual taxi out times.

Image transcription text

K1 mktcarrier AA AB AC AD AE AF AG E F G H M N O R S U V W X Y Z B D A14 flightdate flightmon origin dest deptermir depgate precip_in snow_ino wx_string opcar mktcarrielactype schdep scharr out off OTI In txo cancelled diverted departure arrivalval ontimedel A 2E+07 201501 SLC DFW 1 A3 NULL NULL AA AA M80 28 W N 2E+07 201501 SLC DFW A3 NULL NULL AA AA M80 2E+07 201501 SLC DFW 1 A3 NULL NULL AA AA M80 22 2E+07 201501 SLC DFW 1 A3 NULL NULL M80 13 BR AA AA 2E+07 201501 SLC ORD 1 A5 NULL NULL YX AA 13 EMJ 13 2E+07 201501 SLC LAX 1 A3 NULL NULL OO AA CRJ 2E+07 201501 SLC DFW 1 A3 NULL NULL 12 AA AA M80 NULL NULL NULL NULL O NULL NULL 2E+07 201501 SLC LAX 1 A5 NULL NULL AA CRJ 11 19 10 2E+07 201501 SLC ORD 1 A5 NULL NULL 3R YX AA MJ 11 2E+07 201501 SLC DFW 1 A3 NULL NULL AA AA M80 HHHHHH# 32 2E+07 201501 SLC ORD 1 A3 NULL NULL YX AA EMJ 22 13 2E+07 201501 SLC DFW 1 A5 NULL NULL AA AA M80 34 17 14 2E+07 201501 SLC LAX 1 A3 NULL NULL OO AA CRJ 15 2E+07 201501 SLC 1 A3 NULL AA AA M80 14 DFW DFW 1 A3 NULL NULL HZ AA AA M80 #HHHHHH# 12 16 2E+07 201501 SLC 17 2E+07 201501 SLC ORD 1 A3 NULL NULL YX AA EMJ 18 18 2E+07 201501 SLC DFW 1 A3 NULL NULL AA AA M80 28 19 2E+07 201501 SLC DFW 1 A5 NULL NULL AA AA M80 15 16 20 2E+07 201501 SLC DFW 1 A3 NULL NULL AA AA M80 #### #HHHHHH# LOO O H HOH HOH O OOOH HOH HOO H H HOO O H H OO OO OHH HH 21 2E+07 201501 SLC ORD 1 A5 NULL NULL YX AA EMJ 44 HOOOO HOO O H O O O O O O H O O H O O O O H H O O O O O O O O O O O O O H OOOH H H OO OO H O O O O H H O O H O O H H O O O O H H O O O O O H H O 22 2E+07 201501 SLC LAX 1 A5 NULL NULL AA CRJ 23 2E+07 201501 SLC ORD 1 A3 NULL NULL YX AA EMJ NULL NULL NULL NULL O NULL NUL 2E+07 201501 SLC LAX 1 A2 NULL NULL 00 AA CRJ NON 25 2E+07 201501 SLC DFW 1 A3 NULL NULL AA AA M80 26 2E+07 201501 SLC ORD 1 A3 NULL NULL YX AA EMJ 2E+07 201501 SLC ORD 1 A3 NULL NULL YX AA EMJ NULL NULL NULL NULL O NULL NULL 28 2E+07 201501 SLC DFW 1 A3 NULL NULL AA AA M80 17 201501 SLC LAX 1 A3 NULL NULL AA CRJ HHHHHHHH HHHHHHHH 11 29 2E+07 30 2E+07 201501 SLC DFW 1 A3 NULL AA AA M80 HHHHHH# 41 NULL 31 2E+07 201501 SLC LAX 1 A5 NULL NULL HZ AA CRJ 14 32 2E+07 201501 SLC DFW 1 A3 NULL NULL AA AA M80 10 2E+07 201501 SLC DFW 1 A3 NULL NULL IZ AA AA M80 #HHHHHH# 10 33 34 2E+07 201501 SLC ORD 1 A5 13 NULL NULL YX AA EMJ HHH# 35 2E+07 201501 SLC DFW 1 A3 NULL NULL AA AA M80 # HHHHHHHH HHHHHHHH 28 36 2E+07 201501 SLC LAX 1 A3 0.005 NULL RA BR oo AA CRJ 37 2E+07 201501 SLC ORD 1 A5 NULL NULL BR YX AA EMJ 38 2E+07 201501 SLC LAX 1 A5 NULL NULL HZ OO AA CRJ 39 2E+07 201501 SLC LAX 1 A3 0.02 NULL RA BR 00 AA CRI Windows 3 40 2E+07 201501 SLC LAX 1 A3 NULL NULL 00 AA CRI 41 2E+07 201501 SLC NULL oo AA And= bo Windows = CALC LAX 1 A3 NULL CRJ AA_SLC_Q1_opdata Sheet1 +

...

Solved by verified expert
<p>ce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat</p> Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet