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...
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...
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
(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...
Customer service processes, non–value-added activities Daniel Morris purchased a 42-inch plasma television, manufactured by TVCO, from...
Customer service processes, non–value-added activities Daniel Morris purchased a 42-inch plasma television, manufactured by TVCO, from a local electronics store that permits customers to return defective products within 30 days of purchase. Approximately 45 days after Daniel’s purchase, the TV began to malfunction periodically. Because Daniel could not return the TV to the local store, he turned to the warranty information and found that the warranty included picking up the approximately 100-pound TV from the owner’s home, repairing the TV,...
Using R to solve the problem, please copy and paste your code. Thanks. (You must use...
Using R to solve the problem, please copy and paste your code. Thanks. (You must use R) 8. (15 pts) Consider the following questions: give the distribution name, carefully define the random variables you use and find the final answer. (a) (3 pts) A professor has made 20 exams of which 8 are hard, 7 are reasonable, and 5 are easy. The exams are mixed up and the professor selects 4 of them at random to give to four sections...
This question has 10 parts. Each of the 10 parts (Part A - Part J) has...
This question has 10 parts. Each of the 10 parts (Part A - Part J) has a dropdown list of possible answers. Choose the best answer from the dropdown list for EACH part of the question below. A group of psychiatrists want to investigate if there is any difference in depression levels (measured on a scale from [0=not at all depressed] to [100=severely depressed]) in patients who have been treated for depression by being told to regularly exercise versus those...