Can someone please help me with this question? I don\'t know if I\'m doing this
ID: 3174585 • Letter: C
Question
Can someone please help me with this question? I don't know if I'm doing this correctly. We are supposed to use Excel to solve this. Thank you so much!
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
Hereby i am atttaching the excelsheet snapshot with data set of the following question
I have generated a daa table and pivot table
Now calculating probability that the two people will arrive within two minutes of each other = 20/60 = 1/3
Use excel and use RAND function and get number of absolute value of T1- T2 and calculate the probability.
T 1 T2 T1 - T2 51.46269 35.99522 15.46747 23.28585 41.70374 18.41789 19.31619 12.18999 7.126193 30.59051 13.21523 17.37528 51.55914 51.16681 0.392322 22.78649 11.80149 10.985 38.36868 44.3643 5.995613 44.6639 56.26554 11.60164 33.5819 34.07576 0.493861 12.54439 42.43062 29.88623 15.64586 39.94793 24.30207 46.53937 7.825168 38.7142 4.694335 24.71859 20.02425 40.93788 44.72501 3.787138 40.28396 37.87331 2.410655 41.13632 53.13396 11.99764 7.3757 37.48234 30.10664 44.66185 23.87141 20.79044 5.678209 45.30949 39.63128 50.41049 45.72867 4.681823 48.47892 45.83276 2.646161 47.30645 33.84479 13.46166 17.69676 41.18352 23.48676 57.58823 4.252433 53.3358 6.23457 22.70804 16.47347 21.3841 52.70801 31.32392 8.145896 55.90411 47.75821 58.31042 11.88568 46.42474 31.49214 31.30052 0.191626 40.38328 3.368676 37.0146 28.6603 54.79702 26.13673 52.28867 30.34152 21.94716 36.96089 25.13298 11.82792 57.5714 26.99977 30.57163 56.48474 35.50724 20.9775 8.26686 28.50036 20.2335 35.00333 28.03206 6.971266 6.009836 25.77811 19.76828 12.67952 59.23034 46.55082 23.28385 54.44632 31.16247 31.7479 14.04238 17.70552 24.21248 47.11771 22.90523 8.202018 4.766496 3.435522 58.77266 15.38829 43.38437 18.7771 19.91173 1.134631 14.22106 45.26348 31.04242 10.98824 3.05703 7.93121 39.9501 1.723891 38.22621 46.58512 54.80474 8.219622 19.50125 4.332232 15.16902 48.11477 50.35204 2.237264 39.21601 40.48901 1.273001 44.82265 22.7553 22.06735 56.89728 24.4813 32.41597 22.07486 55.73727 33.66241 55.36229 27.69227 27.67002 35.16919 44.30771 9.138517 58.09802 56.60177 1.496242 13.17939 3.265482 9.91391 45.84577 47.46095 1.615178