Binomial Distribution Modeling: Defective Part Rate in Manufacturing
Not what you're looking for?
Please help with the following problem.
A manufacturer has determined that on one of its assembly lines, the defective part rate is 60000 PPM (Parts Per Million), corresponding to a probability of producing a defective part of 6%. You are a Quality Engineer and told by the manufacturer's accountants that they can afford for you to take a sample of 20 parts every hour to aid in determining the actual number of defectives at that time, but they can afford no greater disruption to production. What is the minimum number of defective parts you need to find in the sample to support management's decision to shut down the line if, within a 95% confidence interval, your evidence suggests the tolerant 60000 PPM rate has been exceeded? The company uses Microsoft products as an office standard, so you are required to use Excel to present your reasoning.
Purchase this Solution
Solution Summary
Excel's binomial function modeling a null hypothesis test in a completed spreadsheet is used to explore application of basic probability of this story problem and its implications.
Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.