Question

IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) buring the period of time that a local university takes phone-in registrations, calls come in at the rate of one every two minutes 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?

Answer 1

Answer:

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

d) probability of receiving three calls in five minutes

this is used in excel functions as ,

POISSON.DIST(3,2.5,FALSE) = 0.2138

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

This is Used as excel functions as,

POISSON.DIST(0,5,FALSE) = 0.0067

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

This is Used in excel functions as,

POISSON.DIST(5,5,TRUE) = 0.3840

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

This is used in Excel function as ,

POISSON.DIST(7,7.5,TRUE) = 0.5246

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

This is Used in Excel function as,

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