Simulation excel homework.

I like that you have asked a specific question rather than the open ended "how do I do this?" kind of question.

RANDBETWEEN() might be the correct function, it depends on exactly what you are trying to do. RANDBETWEEN(0,20) will return random, uniformly distributed integers between 0 and 20 (2, 15, etc., but not 3.5, 4.26, 10.14, etc.). If integer minutes are adequate for your desired simulation, then this is fine. However, if you would prefer to return random real numbers between 0 and 20, see the formula using the RAND() function: https://support.office.com/en-us/art...0-021ea9f5be73

Another thing for you to consider, if your times are going to be real time values, then you should consider that Excel stores times as fractions of a day (you might review this: http://www.cpearson.com/Excel/datetime.htm#SerialDates ). So, in this respect, a random time between 0 and 20 minutes ends up being a random number between 0/1440 and 20/1440=0.013888.... You could either use the RAND() function as explained in the help file (=RAND()*0.01388888889) or =TIME(0,RAND()*20,0) or TIME(0,RANDBETWEEN(0,20),0). A lot of this depends on exactly how you are entering and using these times (whether or not you are using Excel's built date/time serial number system or something else).

From there, I might also suggest reviewing this brief example of a Monte Carlo simulation that I put together: https://www.excelforum.com/tips-and-...l-problem.html In this example, I use the Monty Hall problem to illustrate how I might set up a Monte Carlo simulation. I would expect to use a similar set up if I were to tackle your simulation.