Hi,

Hope you are well!

I received the following problem along with an excel document containing relevant data(please see attached)the data goes all the way to 200 minutes.

The expansion of the Istanbul International Airport has drawn media attention for its revolutionised baggage service which shortened the time a passenger needed to collect his or her baggage. To gauge the performance of its newly-installed baggage carousel, the department of aviation services has collected a random dataset on the number of bags per minute handled by Baggage Carousel A and Baggage Carousel B. These are two different carousels. You would like to summarise the dataset, compare the two carousels and report to the department of aviation services

a)Choose appropriate graphs to visualise the dataset and provide relevant descriptive statistics and a brief commentary.

b)Compute the average time a passenger needs to wait to see the next piece of baggage. State the assumption you need to make this computation. Hint: what is the assumption behind modelling inter-arrival waiting time as an exponentially distributed variable?

Can you please suggest graphs and other ways to organise and display this data using excel as well as the right steps to follow answer b).

Please note: I tried to make a cluster bar chart but since there is a lot of data, it looked messy and it was hard to read. I've also tried to organise the data into a pivot table followed by a pivot chart with not much success and I believe I must condense this data but I am not sure how.

I look forward to hearing from you.

Kind regards,

Sky

\f