Question

Your shop has produced a batch of 2000 parts today and shipped to your customer. Each...

Your shop has produced a batch of 2000 parts today and shipped to your customer. Each part in the batch has a probability of being defective as 0.005.
If the batch has 3 or more defectives, the batch is returned. What is the probability of a batch of 2000 being returned by the customer? Also, please show how it can be solve using excel.?

Homework Answers

Answer #1

I have answered the question below using excel

Please up vote for the same and thanks!!!

Do reach out in the comments for any queries

Answer:

Here Probability of being defective is 0.005

Number of trials = 2000 = n

We need to find the probability of returning back => It is returned if it has greater than or equal to 3 defectives

Greater or equal to 3 means => Greater than 2 defectives => x = 2

BINOMDIST(x, n, p, TRUE) = cumulative probability distribution F(x) value at x for the binomial distribution B(n, p), i.e. the probability that there are at most x successes in n trials where the probability of success on any trial is p.

Probability of return = 1 - Prob ( 2 defectives)

= 1 - BINOMDIST(2,2000,0.005,true) = 0.9973

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Customer feedback indicates that any more than ten defective parts in a box of 250 are...
Customer feedback indicates that any more than ten defective parts in a box of 250 are unacceptable. Elroy has directed you, the Head of Quality, to determine what probability of any given part being defective (p) is acceptable if we are to have 90% of our customers happy. (Put another way we want the cumulative probability of 10 defects or less to be at least 0.900.) Please answer to three decimal places.
Two machines each produce batches of part Q7BC. A random sample of Q7BC parts from each...
Two machines each produce batches of part Q7BC. A random sample of Q7BC parts from each machine’s recent production produced the following frequency table. One Q7BC part is selected randomly. Frequencies Machine A Machine B Totals Defective (D) 5 2 7 Not Defective (N)   145 48 193 Totals 150 50 200 Express each desired probability using proper probability notation. Then find the probability using our probability framework. Show your work. Find the probability that the part was produced by machine...
The ABC Transistor Corporation ships out transistors in lots of 12. 10% of all transistors produced...
The ABC Transistor Corporation ships out transistors in lots of 12. 10% of all transistors produced are defective. ABC promises to repair any defectives which are shipped out. It also gives a money-back guarantee to customers is a lot has more than 2 defectives. The cost of ABC to repair a transistor is $10.00. The money-back guarantee costs ABC $30.00 in addition to repair costs. 1. Computer the probability that a lot of transistors will have more than 2 defectives....
Many companies use a quality control technique called acceptance sampling to monitor incoming shipments of parts,...
Many companies use a quality control technique called acceptance sampling to monitor incoming shipments of parts, raw materials, and so on. In the electronics industry, component parts are commonly shipped from suppliers in large lots. Inspection of a sample of 40 components can be viewed as the 40 trials of a binomial experiment. The outcome for each component tested (trial) will be that the component is classified as good or defective. Reynolds Electronics accepts a lot from a particular supplier...
Quasi-Tech Corporation produces specially machined parts. The parts are produced in batches in one continuous manufacturing...
Quasi-Tech Corporation produces specially machined parts. The parts are produced in batches in one continuous manufacturing process. Each part is custom produced and requires special engineering design activity (based on customer specifications). Once the design is completed, the equipment can be set up for batch production. Once the batch is completed, a sample is taken and inspected to see if the parts are within the tolerances allowed. Thus, the manufacturing process has four activities: engineering, setups, machining, and inspecting. Costs...
Grear Tire Company has produced a new tire with an estimated mean lifetime mileage of 36,500...
Grear Tire Company has produced a new tire with an estimated mean lifetime mileage of 36,500 miles. Management also believes that the standard deviation is 5000 miles and that tire mileage is normally distributed. To promote the new tire, Grear has offered to refund a portion of the purchase price if the tire fails to reach 30,000 miles before the tire needs to be replaced. Specifically, for tires with a lifetime below 30,000 miles, Grear will refund a customer $1...
Suppose each time a potential customer visits your website on a weekday there is a 25%...
Suppose each time a potential customer visits your website on a weekday there is a 25% chance they purchase something. Every hour you get exactly 20 potential customers visiting your website. Suppose that all website visits are independent. What is the probability that you make 5 or less sales in an hour? What is the expected number of sales from your website in a 10 hour time period? Suppose on weekends the probability a visitor makes a purchase is 0.63...
An investor has $25,000 that he can invest today. In addition to this amount, he can...
An investor has $25,000 that he can invest today. In addition to this amount, he can also invest $12,000 per year for 30 years (beginning one year from now) at which time he will retire. He plans on living for 25 years after he retires. If interest rates are 8 percent, what size annual annuity payment can he obtain for his retirement years? (All annuity payments are at year-end. Round your answer to the nearest dollar.) PLEASE show in excel
Grear Tire Company has produced a new tire with an estimated mean lifetime mileage of 36,500...
Grear Tire Company has produced a new tire with an estimated mean lifetime mileage of 36,500 miles. Management also believes that the standard deviation is 5000 miles and that tire mileage is normally distributed. To promote the new tire, Grear has offered to refund some money if the tire fails to reach 30,000 miles before the tire needs to be replaced. Specifically, for tires with a lifetime below 30,000 miles, Grear will refund a customer $1 per 100 miles short...
(All answers were generated using 1,000 trials and native Excel functionality.) Grear Tire Company has produced...
(All answers were generated using 1,000 trials and native Excel functionality.) Grear Tire Company has produced a new tire with an estimated mean lifetime mileage of 36,500 miles. Management also believes that the standard deviation is 5,000 miles and that tire mileage is normally distributed. To promote the new tire, Grear has offered to refund some money if the tire fails to reach 30,000 miles before the tire needs to be replaced. Specifically, for tires with a lifetime below 30,000...