Please provides the fomula in Excel. From past data we know that the mean number

Question

Please provides the fomula in Excel.

From past data we know that the mean number of arrivals to buy tickets at the Family Fun Center in Tukwila on Saturday afternoon is 20 per 1/2 hour Assume: The probability of a person arriving is the same for all equal-size intervals Assume: The number of people arriving in any interval is independent of the number of people arriving in any other interval In cell B12 calculate the probability that 25 people will arrive in 1/2 hour In cell B13 calculate the probability that between 25 and 30 people (inclusive) will arrive in 1/2 hour Use anywhere in the spreadhseet to place formulas inputs, make calculations and charts (if needed), but put your final answer in the cells B12 and B13. P(25) P(25

Explanation / Answer

hre as this is poisson distribution :

therefore P(25) =poisson(25,20,false) =0.0446

and for P(25<=X<=30) =poisson(30,20,true) -poisson(24,20,true) =0.1433

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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