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

  Participative-delegation and empowerment styles leadership

The three styles of leadership are participative, delegation, and empowerment. Explain how each of these three styles impacts followers in an organization.

  Alternative to achieve net income objective

Determine which alternative Almo should select to achieve its net income objective. Show your calculations.

  Ethics case-uncollectible accounts

You have recently been hired as the assistant controller for Stanton Industries. Your immediate supervisor is the controller, who in turn, reports to the vice president of finance.

  Ethics and social responsibility

Examine the chosen statement in the context of ethics and social responsibility. Examine the impact government regulations have on business ethics and social responsibility in the example you choose.

  The two functions performed by a transition phrase

Discuss  the two functions performed by a transition phrase  in a survey?

  Work-related cultural dimensions identified by hofstede

Where would you place yourself on each of the five work-related cultural dimensions identified by Hofstede (e.g., high on individualism)? Why?

  Explaining inelastic-elastic and unitary price elasticity

Explain the differences among inelastic, elastic, and unitary price elasticity to the VP and CFO.

  Example of decision making under uncertainty

What is an example of decision making under uncertainty?

  Discuss ethics professional standards

According to the ethical standards of the profession, which of following acts generally is prohibited?

  Explaining cultural blooper of american

An example of a cultural blooper would be for an American to?

  Describing family business

Write down the advantages and disadvantages of a family business? How can the involvement of a third party resolve conflict in a family business?

  Negotiate mutually beneficial contracts

Examine two legal responsibilities that employers have regarding their participation in unions. Suggest two ways in which management and unions may negotiate mutually beneficial contracts.

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