Can someone please help me do this in excel? Thank you! The formula =60*RAND() w
ID: 3174729 • Letter: C
Question
Can someone please help me do this in excel? Thank you!
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?
Explanation / Answer
Hi,
Two cells generated with 60*rand() and third cell we have difference between two random generated numbers. Here I have generated 25 samples.
Data Table:
Pivot Table:
Probability of event = probablity of favorable outcomes / probablity of total outcomes
Probablity of event=6/25 = 0.24
Random 1 Random 2 Diff Is lessthan 10Min 15.47934926 11.64604092 3.833308339 Less Than 10 Min 39.02341791 48.78419285 -9.760774937 Less Than 10 Min 36.66684202 6.347224595 30.31961743 Greater than 10 min 34.47587177 15.97997199 18.49589978 Greater than 10 min 0.680943684 24.80160444 -24.12066076 Greater than 10 min 14.39795779 32.88192358 -18.48396579 Greater than 10 min 53.36856544 37.23301468 16.13555075 Greater than 10 min 49.56548318 41.02995397 8.535529216 Less Than 10 Min 30.58225355 51.76416471 -21.18191117 Greater than 10 min 54.85443268 8.423929059 46.43050362 Greater than 10 min 35.16314449 17.94639723 17.21674726 Greater than 10 min 49.17991623 8.32881641 40.85109982 Greater than 10 min 51.83922074 30.90163589 20.93758485 Greater than 10 min 20.5571133 2.273123315 18.28398999 Greater than 10 min 31.18650746 52.23557118 -21.04906372 Greater than 10 min 20.09488014 35.41721145 -15.32233131 Greater than 10 min 59.89764194 34.92826579 24.96937615 Greater than 10 min 9.567300065 32.2335121 -22.66621203 Greater than 10 min 10.49255856 38.04776596 -27.5552074 Greater than 10 min 19.3390275 35.93794141 -16.59891391 Greater than 10 min 33.90269011 3.539222869 30.36346724 Greater than 10 min 6.973225673 19.67597905 -12.70275337 Greater than 10 min 45.18495511 50.41450646 -5.229551357 Less Than 10 Min 41.57931435 49.94384351 -8.364529154 Less Than 10 Min 40.73854971 34.72829506 6.010254646 Less Than 10 Min