Reference no: EM132986855
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.
Download attached operational data 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.
Problem 1: 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)
Problem 2: 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?
Problem 3: 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?
Problem 4: 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)