Dear Excel/VBA gurus,
I'm new to using VBA and we are taught queuing simulation in class. As part of the assignment we need to modify the attached code (in file) as per the following
Change the program so that the current simulation is embedded in a For Loop from 1 to 100. Each time through the loop, one simulation is run, and its output (you can select which ones) are reported on a Replications sheet. After all 100 simulations have run, summarize the selected outputs on a Summary sheet. For each output, report the following summary measures: minimum, maximum, average, standard deviation, median and 5th and 95th percentile.
For example, if one of your outputs on any replication is the maximum number in queue, then you will get 100 such maximums, one for each replication. The summary sheet should summarize these 100 numbers: their average, their standard deviation and so on. In this way you can see how results vary from replication to another.forum.ozgrid.com/index.php?attachment/63312/