Consider the number of data entry errors per hour of data entry work by a resear

Question

Consider the number of data entry errors per hour of data entry work by a research assistant. The average number of errors per hour is historically 6 errors per hour.

5) In cell B45, briefly explain why the Poisson Probability Distribution is a better fit for this issue than the Binomial Probability Distribution.

6) What is the probability of one or fewer errors in a given hour? Insert your own reference in the appriate cell on the answer worksheet.

7) What is the probability of one or more errors in a given hour? Insert your own reference in the appriate cell on the answer worksheet.

8) In cell B47 determine the probability of between 3 and 6 errors during a given hour (inclusive of the endpoints).

Copy of 221-5p15-HW3- cd Irsat Page Layou Fomu D RaviVi Hl Tel me what you wan to do Linked Call ormatting Table pboard tw 1 conddethe nLmbar ct data entry errors per hour of data entry work by 2historncallyerrors per hour. rasoarch assistant. The average numbar errars per hcur 45 In ccll B45, bricfly explzin wny tha Pozson Prcbablty Dirbutons better fit for thls su than the Binomlal Probab lty Distribution. 7} what ls the probability ot na ar mare errors In ghen hcu? insert your awn raterance in the appriate cl the answer warkheet. 81 In cllB47 determine the prahahlity cr beween anderra dunre elven hourince at the endpoinzs 10 rix) 2 instructiuns | Answers | u14 | Q5-8 ! 02 11:31 PM

Explanation / Answer

5) In cell B45, briefly explain why the Poisson Probability Distribution is a better fit for this issue than the Binomial Probability Distribution.

Answer : Here Poisson distribution is better fit here as there is no fixed sample size parameter is given here. Poisson fits here as there is fixed rate error per hour is given which is the characteristic of Poisson Distribution.

6) What is the probability of one or fewer errors in a given hour? Insert your own reference in the appriate cell on the answer worksheet.

Answer : If we apply the formula in Excel worksheet

POISSON (1,6, True) = 0.0174

7) What is the probability of one or more errors in a given hour? Insert your own reference in the appriate cell on the answer worksheet.

Here we will apply formula

1 - POISSON (0,6, false) ; as we know that if we deduct the probability of zero error in given hour from 1, i will give us the desire probabilty

ANswer is 1 - POISSON (0,6, false) = 1 - 0.0025 = 0.9975

8) In cell B47 determine the probability of between 3 and 6 errors during a given hour (inclusive of the endpoints).

Here we will get this probability by using formula

POISSON (6, 6, true) - POISSON(2,6, true) = 0.6063 - 0.0620 = 0.5443

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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