Question: 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

2. Use Excel to simulate (Monte Carlo simulation) the below stated Hospital

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!