Question: The formula =60*RAND() will output a random number between 0 and 60. This can be used to simulate the time someone arrives at an airport
The formula =60*RAND() will output a random number between 0 and 60. This can be used to simulate the time someone arrives at an airport between 1 and 2 p.m. If =60*RAND() returns the value 23.456 that would indicate a person arrived at about 1:23 p.m. (1:23:27 p.m. if you want to be fussy.) Set up two cells, each with =60*RAND() to model a situation where two people arrive at an airport between 1 and 2 p.m. Set up a third cell for the difference between the two times. Then generate a data table and pivot table to answer the question: What is the probability that the two people will arrive within ten minutes of each other?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
