Question: need to know the correct command in excel. thank you! Using the arrival and departure data of 20 cars collected at the parking ramp during

Using the arrival and departure data of 20 cars collected at the parking ramp during 22 minutes below, 1) (15 pts pts) Develop a table of showing arrival time, departure time, service time, queuing time and a total time spent in the system 2) (20 pts) Plot a probability density curve for arrival rate and a probability density curve for service time based on the data below and show the theoretical plot of Poisson distribution (for arrival rate) and the theoretical pot of Exponential distribution (service time) as discussed in class. Discuss if arrival rate follows the Poisson distribution and if the service time follows the Exponential distribution 3) (20 pts) Plot the queue length (number of cars in the queue) over 22 minutes. 4) (15 pts) Compute: 1) average number of cars waiting in the queue, 2) average waiting time in the queue and 3) average time spent in the system based on your data and compare them against the theoretical values based on the queuing theory CAR Arrival Departure 1 0.1 0.52 2 0.7 2.03 3 1.28 2.62 4 1.47 3.37 5 3.17 3.57 6 3.88 6.07 7 7.12 7.45 8 7.72 8.18 9 9.82 10.17 10 10.78 113 11 11.07 11.7 12 11.18 14.07 13 1238 14.3 14 124 14.68 15 12.68 15.13 16 14.42 16.03 17 16.11 17.62 18 1753 18.8 19 17.6 19.32 20 19.15 21.56 Time Period -22 min Time Period - 22 min
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
