Build an EXCEL MODEL for the following prompt: 2 people agreed to meet each othe

Question

Build an EXCEL MODEL for the following prompt:

2 people agreed to meet each other between 6am and 7am, but do not mention a specific time. Each man will wait for only 5 minutes (a 5 minute waiting frame) for the other, what is the probability of meeting?

Develop probability estimates for 8 combinations of meeting frames with waiting frames: 1 and 2 hrs by 5, 10, 15, and 20 minutes. Report your results in a visually meaningful way. In other words, estimate probability for one hour and five minutes, one hour and 10 minutes etc. and generate using minutes as uniform from 0 to 60 using decimals, called minutes past the hour A=0 B=60 then B=120

Explanation / Answer

The probability that both the people will be able to meet each other given that they decide to wait for time 't' is given by the area of the shaded region below:

Thus, the probability of meeting :

P (t) = [3600 - (60- t)2 ] / 3600

Thus, EXCEL Output will be:

Hope this helps.

t P(t) 0 0 5 0.159722 10 0.305556 15 0.4375 20 0.555556 25 0.659722 30 0.75 35 0.826389 40 0.888889 45 0.9375 50 0.972222 55 0.993056 60 1

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.