Explore BrainMass

Explore BrainMass

    Computing Averages and Probability Using Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Question: 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.

    © BrainMass Inc. brainmass.com June 4, 2020, 3:24 am ad1c9bdddf

    Solution Summary

    The expert examines computing the averages and probability using Excel.