Computing averages and probability using excel


Problem:

Zimmerman's Bank is the only bank in the small town of St. Thomas. On a typical Friday, an average of 10 customers per hour arrive at the bank to the transact business. There is one teller at the bank, and the average time required to transact business is 4 minutes. It is assumed that service times may be described by the exponential distribution. A single line would be used, and the customer at the front of the line would go to the first available bank teller. If a single teller is used, find:

a) The average time in the line.

b) The average number in the line.

c) The average time in the system.

d) The average number in the system.

e) The probability that the bank is empty.

For parts a through e; assume µ = 15

This needs to be completed using Excel.

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Computing averages and probability using excel
Reference No:- TGS01939971

Now Priced at $25 (50% Discount)

Recommended (99%)

Rated (4.3/5)