Question

Q2) An average of 10 people per hour arrive (with exponential inter-arrival times) intending to swim laps at the local YMCA. Each intends to swim an average of 30 minutes. The YMCA has three lanes open for lap swimming. If one swimmer is in a lane, he or she swims up and down the right side of the lane. If there are two swimmers are in a lane, each swims up and down one side of the lane. Swimmers always join the lane with the fewest number of swimmers. If all three lanes are occupied by two swimmers each, a prospective swimmer becomes disgusted and goes running.

1. What fraction of time will exactly three people be swimming laps ?

2. On the average, how many people will be swimming laps in the pool ?

3. How many lanes does the YMCA need to allot to lap swimming to ensure that at most 5% of all prospective swimmers will become disgusted and go running.

Must be solved using Excel! Please be clear explaining formulas used in excel.

Answer 1

Solution :

Given that

The  average of 10 people per hour arrive (with exponential inter-arrival times) intending to swim laps at the local YMCA. Each intends to swim an average of 30 minutes