I need help with question 9 and 10.

Note: For question 9 it should use mean of 20 minutes and a standard deviation of 5 minutes.

I need both answers with excel calculations.

visit the medication lab and have all of their existing medications inven- toried when they arrive. The interarrival times of patients to the medication lab follow a uniform distribution with an upper bound of 45 minutes and a lower bound of 30 minutes. The service times to have their medication average tin for your answer. logged follow a normal distribution with a mean of 20 minutes and standard deviation of 5 seconds. Using Excel, determine queuing and service statistics for the 40 patients who visit the medication lab over a one-day period. The columns of data you will need to generate include patient ID, interarrival time, arrival time, service start time, wait time, service time, service completion time, time in system, and server idle time. 10. Calculate the following summary statistics for question 9: a. Number of patients who wait b. Probability of waiting c. Average wait time d. Maximum wait time e. Percentage of time server is busy f. Number waiting > 1 minute g. Probability of waiting > 1 minute h. Average number of patients in line