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

User Account

All Pages