Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help with this problem and please show the excel formulas. thank you for the help. Problem 1: Use the information below, to answer the
please help with this problem and please show the excel formulas. thank you for the help. Problem 1: Use the information below, to answer the questions that follow. Enter the formulas into the yellow cells so that the cells will show the information requested. Prairie State Bank operates a drive-up teller window that allows customers to complete bank transactions without getting out of their cars. On weekday mornings, arrivals to the drive-up teller window occur at random and follow a poisson distribution. The arrival rate is 20 customers per hour or 0.3333 customers per minute. Service times at the drive-up teller follow an exponential probability distribution with a service rate of 36 customers per hour or 0.6 customers per minute. Enter the Enter the arrival service rate in the rate in the cell below this one cell below this one Question 1 What is the probability that no customers are in the system? Question 2 What is the probability that 3 or more customers are in the system? Question 3 What is the average number of customers in line? Question 4 What is the average number of customers in the system? Question 5 How long should a customer expect to wait (on average) before being served? Perhour or Per minute
please help with this problem and please show the excel formulas. thank you for the help.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started