Question: can you help me with the full solution in EXCEL with the formulas for each cell Problem 1: Use the information below, to answer the

can you help me with the full solution in EXCEL with the formulas for each cell
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 24 customers per hour or 0.4 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 rate service in the cell rate in the below this cell below one 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 servedStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
