People arrive to a hotel at a rate of 20 on average with each half hour....

People arrive to a hotel at a rate of 20 on average with each half hour. Make a probability distribution in excel for an interval of 30 minute duration. What’s the probability that no more then 14 customers will arrive?

Solutions

Expert Solution

Solution- To find Poisson distribution probabilities in Excel, use the function =POISSON(x;λ;0)

x=number of occurrences over a specified interval

λ=average number of occurrences over a specified interval = 20

since the probability distribution in excel for an interval of 30 minute duration given below.

x	p(X=x)	Round off at six places
0	2.06115E-09	0
1	4.12231E-08	0
2	4.12231E-07	0
3	2.7482E-06	0.000003
4	1.3741E-05	0.000014
5	5.49641E-05	0.000055
6	0.000183214	0.000183
7	0.000523468	0.000523
8	0.001308669	0.001309
9	0.002908153	0.002908
10	0.005816307	0.005816
11	0.010575103	0.010575
12	0.017625171	0.017625
13	0.027115648	0.027116
14	0.03873664	0.038737
15	0.051648854	0.051649
16	0.064561067	0.064561
17	0.075954196	0.075954
18	0.084393552	0.084394
19	0.088835317	0.088835
20	0.088835317	0.088835
21	0.084605064	0.084605
22	0.076913695	0.076914
23	0.066881474	0.066881
24	0.055734561	0.055735
25	0.044587649	0.044588
26	0.034298192	0.034298
27	0.025406068	0.025406
28	0.018147191	0.018147
29	0.012515304	0.012515
30	0.008343536	0.008344

probability that no more then 14 customers will arrive = P(X<_14)

= probability sum of 0 to 14 of above table.

= 0.104864

orchestra answered 1 year ago

Next > < Previous

Related Solutions

On average, 90 patrons arrive per hour at a hotel lobby (interarrival times are exponential) waiting...

On average, 90 patrons arrive per hour at a hotel lobby (interarrival times are exponential) waiting to check in. At present there are five clerks, and patrons wait in a single line for the first available clerk. The average time for a clerk to service a patron is three minutes (exponentially distributed). Clerks earn $10 per hour, and the hotel assesses a waiting time cost of $20 for each hour that a patron waits in line. If needed, round your...

Cars arrive at a parking lot at a rate of 20 per hour. Assume that a...

Cars arrive at a parking lot at a rate of 20 per hour. Assume that a Poisson process model is appropriate. Answer the following questions. No derivations are needed but justification of your answers are necessary. What assumptions are necessary to model the arrival of cars as a Poisson process? What is the expected number of cars that arrive between 10:00 a.m and 11:45 a. m? Suppose you walk into the parking lot at 10:15 a.m.; how long, on average,...

People arrive at a party according to a Poisson process of rate 30 per hour and...

People arrive at a party according to a Poisson process of rate 30 per hour and remain for an independent exponential time of mean 2 hours. Let X(t) be the number of people at the party at time t (in hours) after it started. Compute E[X(t)] and determine how long it takes to have on average more than 40 people at the party.

Customers arrive at a local ATM at an average rate of 14 per hour. Assume the...

Customers arrive at a local ATM at an average rate of 14 per hour. Assume the time between arrivals follows the exponential probability distribution. Determine the probability that the next customer will arrive in the following time frames. a) What is the probability that the next customer will arrive within the next 2 minutes? b) What is the probability that the next customer will arrive in more than 15 minutes? c) What is the probability that the next customer will...

Customers arrive for service at a rate of 50 an hour and each server can deal...

Customers arrive for service at a rate of 50 an hour and each server can deal with 25 customers an hour. There are three servers. If the customers time is valued at $20 an hour and server time costs $30 an hour, how much does the queue cost for an eight hour day?

Customers arrive for service at a rate of 50 an hour and each server can deal...

Cars and trucks arrive at a gas station randomly and independently of each other, at an average rate of 17.4 and 9.6 per hour, respectively.

Cars and trucks arrive at a gas station randomly and independently of each other, at an average rate of 17.4 and 9.6 per hour, respectively. Use the Poisson distribution to find the probability that a. more than 5 cars arrive during the next 16 minutes, b. we have to wait more than 21 minutes for the arrival of the third truck (from now), c. the fifth vehicle will take between 17 and 23 minutes (from now) to arrive.

People arrive are arriving at a specific stop light randomly at the average rate of 4...

People arrive are arriving at a specific stop light randomly at the average rate of 4 per hour. What is the probability that more than 3 arrive between 8:00 AM and 8:30 AM on a specific day? a).8647 b).4060 c).1429 d) .0527

Suppose that customers arrive at a bank at a rate of 10 per hour. Assume that...

Suppose that customers arrive at a bank at a rate of 10 per hour. Assume that the number of customer arrivals X follows a Poisson distribution. A. Find the probability of more than 25 people arriving within the next two hours using the Poisson mass function. B. Find the probability of more than 25 people arriving within the next two hours using the normal approximation to the Poisson. C. Compute the percent relative difference between the exact probability computed in...

Phone calls arrive at the rate of 48 per hour at the reservation desk for Regional...

Phone calls arrive at the rate of 48 per hour at the reservation desk for Regional Airways. a. Compute the probability of receiving one call in a 5-minute interval of time. (to 4 decimals) b. Compute the probability of receiving exactly 13 calls in 15 minutes. (to 4 decimals) c. Suppose no calls are currently on hold. If the agent takes 10 minutes to complete the current call, how many callers do you expect to be waiting by that time?...

Subjects