2. Use Excel to simulate (Monte Carlo simulation) the below stated Hospital waiting time problem. A...

Transcribed Image Text:

2. Use Excel to simulate (Monte Carlo simulation) the below stated Hospital waiting time problem. A doctor schedules all his patients for 30-minute appointments in his hospital. Some of the patients take more or less than 30 minutes depending on the type of patient's health issue. The following summary shows the various types of health issues, their probabilities and time actually needed to complete the check up: Type of health issue (A-E) Time Required for check up Probability of patients' health issue type A 40 0.40 B 0.15 0.20 0.10 0.15 D E 15 25 60 30 Simulate the hospital for five hours and determine the average waiting time for the patients. Assume that all the patients show up at the hospital at exactly their scheduled arrival time starting at 7.00 a.m till 11:30 am. For patient arrival, use random numbers with a uniform distribution. Run ten or more experiments to estimate the average waiting time of hospital patients, and briefly comment on the efficiency of hospital operations given the waiting time. 2. Use Excel to simulate (Monte Carlo simulation) the below stated Hospital waiting time problem. A doctor schedules all his patients for 30-minute appointments in his hospital. Some of the patients take more or less than 30 minutes depending on the type of patient's health issue. The following summary shows the various types of health issues, their probabilities and time actually needed to complete the check up: Type of health issue (A-E) Time Required for check up Probability of patients' health issue type A 40 0.40 B 0.15 0.20 0.10 0.15 D E 15 25 60 30 Simulate the hospital for five hours and determine the average waiting time for the patients. Assume that all the patients show up at the hospital at exactly their scheduled arrival time starting at 7.00 a.m till 11:30 am. For patient arrival, use random numbers with a uniform distribution. Run ten or more experiments to estimate the average waiting time of hospital patients, and briefly comment on the efficiency of hospital operations given the waiting time.