Question: this needs to be done in excel, please show step by step especially the formulas . thanks 2. Perform a simulation analysis consisting of 5,000

this needs to be done in excel, please show step by step especially the formulas . thanks

this needs to be done in excel, please show step by step

2. Perform a simulation analysis consisting of 5,000 simulations in another worksheet of your workbook; however, assume that the total number of victims is normally distributed with a mean of 150 victims and a standard deviation of 50 victims. Furthermore, suppose that the transport time for each hospital is normally distributed with a mean and a standard deviation that differ for each hospital. The table below displays these quantities: Hospital Average in Minutes SD in Minutes Beth Israel Medical 15 3 Tufts Medical 10 4 Massachusetts General 7 Boston Medical 15 Brigham and Women's 20 3 Analyze the results of this simulation by repeating parts (a) - (e] of part 1 using the above values. 3. In the word document, explain your methodologies and conclusions. 4. In the word document, provide your opinion regarding a few major quantitative and qualitative differences between the outputs of simulations (1) and (2) above. 5. In the word document, explain how the information obtained from your simulation can be used for planning purposes. 6. In the word document, explain in your opinion, how each simulation can be changed to provide additional useful information

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!