Process for generating a simple random sample

Assignment Help Business Management
Reference no: EM1334254

A manufacturing company's quality control personnel have recorded the proportion of defective items for each of 500 monthly shipments of one of the computer components that the company produces. The data are in the file P02_02.xls. The quality control department manager does not have sufficient time to review all of these data. Rather, she would like to examine the proportions of defective items for sample of these shipments.

A. Use Excel to generate a simple random sample of size 25 from the given frame.
B. Compute the point estimate of the population mean from the sample selected in part a. What is the sampling error in this case? Assume that the population consists of the proportion of defective items for each of the given 500 monthly shipments.
C. Determine a good approximation to the standard error of the mean in this case.
D. Repeat parts b and c after generating a simple random sample of size 50 from the given frame.

Try to do a simple random sample on my own but I am having problems. Could you tell me the following? I understand that the formula is =RAND(), but when I attempt to type this into the cell, it is not doing so correctly. What am I doing wrong?

What is the process for generating a simple random sample?

Reference no: EM1334254

Questions Cloud

Explain new product launch in foreign market : Explain New product launch in foreign market and Assume you are launching a product for a foreign market
Use of annual performance appraisals : Show how a complete performance management system differs from the use of annual performance appraisals
Command style management practices of past : What is the difference between "command style" management practices of the past and "participatory style" management practices of the present?
Discription of marketing initiatives for best buy : Discription of marketing initiatives for Best Buy and It also empowers employees to recognize unique sets of customers and to build offerings and experiences to meet their needs
Process for generating a simple random sample : What is the process for generating a simple random sample?
Explain marketing : Explain Marketing- Research Ford Motor Company and also visit their web site and assume you are preparing a SWOT analysis for Ford
How to use control flow to track membership : Using the Internet and other resources, discuss and study "control flow" in programming. How would you use control flow in computer programming to solve problems? Give an example of how you would use control flow to track membership dues in a smal..
Element of person-s decision-making style : One element of a person's decision-making style is whether the decision maker prefers to make decisions alone or involve others.
Outsource hrm functions : Outsource HRM functions - Why do organizations outsource HRM functions? How does outsourcing affect the role of human resource professionals

Reviews

Write a Review

Business Management Questions & Answers

  The advantages and disadvantages of using part time workers

Discuss the advantages and disadvantages of using part-time workers, subcontracting work, and building up inventory as strategies for meeting demand.

  Report memo measuring each alternative by the yardstick

Develop criteria that you could use to evaluate each alternative. Write a report memo measuring each alternative by the yardstick you have produced.

  Explaining features of genuine empowerment

Compare the features of your plan against the characteristics of bogus empowerment vs. genuine empowerment to show how your plan incorporates the features of genuine empowerment rather than bogus empowerment.

  Neutral and failing to engage

Ruth carelessly parks her car on a steep hill, leaving the car in neutral and failing to engage the parking brake. The car rolls down the hill, knocking down an electric line. This sparks from the broken line ignite a grass fire.

  Manufacturing cost under previous simple job-costing system

Compute the manufacturing cost per unit for each job under the previous simple job-costing system.

  Four elements of motivation-four types of innovation

What are the four elements of the motivation? How would you state the framework for incentives systems design?

  Cultural understanding in today-s changing world

Why is cultural understanding so significant in today's changing world?

  Identifying the commonalities in terms of leaders

Analyze and identify the commonalities in terms of these leaders' personalities, communication styles, ego, personal will, and other leadership qualities.

  Determining the product life cycle

Provide rationale for your answer. Based on your knowledge of the product life cycle, what types of changes will occur to this product as it continues through the product life cycle? How will this affect marketing of the product?

  Managerial roles-essentail knowledge and skills

Managerial roles include adapting an organization to its environment, articulating and gaining support for the organization's mission, vision and values, and designing the internal structures of the organization.

  Performance affect leader behaviors

How could Jack's perception of Eileen's performance affect his leader behaviors when interacting with her?

  Violation of electronic communications privacy

Rosalie is an employee of High & Mighty. She uses her company computer to check her personal email. In particular, Rosalie reads email from her sister, who is a stay at home mom who takes care of Rosalie's two children in addition to her own.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd