calculate using excel 2) suppose that Comdell Computer receives its hard drives

Question

calculate using excel

2) suppose that Comdell Computer receives its hard drives from Diskco. on average, 3% of all hard disk drives recieved by Comdell are defective.

A) Comdell has adopted the following policy: it samples 50 hard drives in each shipment and accepts the shipment if all hard drives in the shipment are not defective. What fraction of shipments will Comdell accept?

B) Suppose instead that the shipment is accepted if at most one hard drive in the sample is defecive. What fraction of shipment will Comdell accept?

C) what is the probabilit that the sample size of 50 will contain at least 10 defectives?

Explanation / Answer

a) =BINOM.DIST(0,50,0.03,FALSE)

Ans: 0.2181

b) =BINOM.DIST(1,50,0.03,TRUE)

Ans. 0.5553

c) =1 - BINOM.DIST(9,50,0.03,TRUE)

Ans. 2.0177 * 10-06

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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