The worksheet Data in the Excel file Airport Service Times lists a large sample of the times in seconds to process customers at a ticket counter. The second worksheet shows a frequency distribution and histogram of the data.

a. Summarize the data using the Descriptive Statistics tool. What can you say about the shape of the distribution of times?

b. Find the 90th percentile.

c. How might the airline use these results to manage its ticketing counter operations?

Transcribed Image Text:

A E F G H 1 Service Times at an Airport Ticketing Counter 2 3 Times (sec.) Times (sec.) Histogram 227 5 83 300 Mean Standard Error 126.2783 6 7 10 3.691221 250 158 Median 88 200 350 Mode 83 Standard Deviation 105.1836 15 150 10 63 Sample Variance Kurtosis Skewness 11063.59 100 11 224 8.707526 12 96 2413577 50 13 61 Range Minimum 867 14 61 9 15 65 Maximum Sum 876 269 509 16 91 102538 17 133 Count 812 Bin Freque ncy 149 602 329 68E 695