Purchase Solution

Binomial Distribution Modeling: Defective Part Rate in Manufacturing

Not what you're looking for?

Ask Custom Question

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.

Attachments
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.