The formula =60*RAND() will output a random number between 0 and 60. This can be

ID: 3815551 • Letter: T

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 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

I have generate a data table and turn table

Now scheming probability that the two people will reach your destination within two minutes of each other = 20/60 = 1/3

Use excel and use RAND purpose and get number of total value of T1- T2 and compute the probability.

T 1

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

T 1