Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. people arrive to a hotel at a rate of 20 on averag

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

Free

50.1K

Verified Solution

Question

Statistics

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

Answer & Explanation Solved by verified expert
4.4 Ratings (852 Votes)

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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Calculus
1.2K views

A car travels east in a straight path at a speed of 60 miles per...

Statistics
1.2K views

For 50 randomly selected speed​ dates, attractiveness ratings by males of their female date partners​ (x)...

Biology
1.2K views

Illustrate and label the interactions between its hypothetical model of a substrate molecule bound in the...

Physics
1.2K views

How would you solve the problem of malnutrition using science (not pseudoscience) and technology?

Geometry
1.2K views

The length of the side AC is 8 cm Find the measure of the side...

Geometry
1.2K views

8 If two things are equal and one of those things is also equal to...

Calculus
1.2K views

From the graph of f x determine the graph of f x 12 10 8...

Calculus
1.2K views

www Give the intervals where the function is continuous Answers are expected in interval notation...

Algebra
1.2K views

7 4pts Find a formula for an exponential function passing through a 2 6 3...

Algebra
1.2K views

Questions 3 8 use information from this table for Town A and Town B for...

Accounting
1.2K views

Michelle is attending college and has a part-time job. Once she finishes college, Michelle...

Accounting
1.2K views

Compu goods s LIFO, (LO 2), E6-7 Jeters Company reports the following for the month...