1) During the period of time that a local university takes phone-in registration

ID: 3298244 • Letter: 1

Question

1) During the period of time that a local university takes phone-in registrations, calls come in at the rate of one every two minutes.

Can you please write what to type into Excel to get these answers for parts c-h.

a. Clearly state what the random variable in this problem is?

b. What is an appropriate distribution to be used for this problem and why?

c. What is the expected number of calls in one hour?

d. What is the probability of receiving three calls in five minutes?

e. What is the probability of receiving NO calls in a 10-minute period?

f. What is the probability of receiving more than five calls in a 10-minute period?

g. What is the probability of receiving less than seven calls in 15-minutes?

h. What is the probability of receiving at least three but no more than 10 calls in 12 minutes?

c) expected number of calls in one hour = 30*1 = 30 calls

d) probability of receiving three calls in five minutes

Use excel functions

POISSON.DIST(3,2.5,FALSE)

= 0.2138

e) probability of receiving NO calls in a 10-minute period

Use excel functions

POISSON.DIST(0,5,FALSE)

= 0.0067

f) probability of receiving more than five calls in a 10-minute period

Use excel functions

1-POISSON.DIST(5,5,TRUE)

= 0.3840

g) probability of receiving less than seven calls in 15-minutes

POISSON.DIST(7,7.5,TRUE)

= 0.5246

h) probability of receiving at least three but no more than 10 calls in 12 minutes

Use Excel function'

POISSON.DIST(10,6,TRUE)-POISSON.DIST(2,6,TRUE)

= 0.8954

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