Question

I am passing out Halloween candy at home to Trick or Treaters. The time between arrivals of childern is distributed exponentially with a mean time of 12 min between visists. A child just by and got a piece of candy. Answer the following probability questions using Excel and Show your work

A. What is the probability the next child will come within the next 10 Minutes?

B. What is the probability the next child will come bwtween 5 and 12 min from now?

C. What is the probability it will be more than 13 min before the next child arrives?

D, My favorite 30min TV show just started. What is the probability I can watch the whole thing without being interrupted by a Trick or Treater?

Answer 1

formula for excel is given in bold ; paste them in cell and you will get required probability

a) for paramter =1/12

probability the next child will come within the next 10 Minutes P(X<10)=expondist(10,1/12,true) =0.5645

b)e probability the next child will come bwtween 5 and 12 min from now=P(5<X<12)

=expondist(12,1/12,true)-expondist(5,1/12,true)=0.2914

c)

probability it will be more than 13 min before the next child arrives =P(X>13 )=1-P(X<13)

=1-expondist(13,1/12,true) =0.3385

d)

P(X>30) =1-P(X<30) =1-expondist(30,1/12,true) =0.0821