How do I do this in Excel? On the average 20 customers arrive each hour at the c

ID: 3046970 • Letter: H

Question

How do I do this in Excel?

On the average 20 customers arrive each hour at the checkout counter at a local pharmacy store.

a) What is the probability that more than 10 customers will arrive at the checkout counter in one hour?

b) What is the probability that less than 7 customers arrive at the checkout counter in 24 min.?

c) What is the probability that no more than 6 customers arrive at the checkout counter in 18 min.?

d) What is the probability that no less than 4 customers arrive at the checkout counter in 22.5 min.?

e) What is the probability that at least 2 but less than 5 customers arrive at the checkout counter in 6 min.?

Thank you

a)
lambda = 10

P(X>10) = 0.989188281
Excel formula: =1-POISSON.DIST(10,20,TRUE)

b)
lambda = 20/60 * 24 = 8

P(X<7) = 0.3134
Excel formula: =POISSON.DIST(6,8,TRUE)

c)
lambda = 20/60 * 18 = 6

P(X<=6) = 0.6063
Excel formula: =POISSON.DIST(6,6,TRUE)

d)
lambda = 20/60 * 22.5 = 7.5

P(X >= 4) = 0.9408
Excel formula: =1-POISSON.DIST(3,7.5,TRUE)

e)
lambda = 20/60 * 6 = 2

P(2 <= X < 5) = P(X < 5) - P(X <= 2) = 0.5413
Excel formla: =POISSON.DIST(4,2,TRUE)-POISSON.DIST(1,2,TRUE)

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