Process for generating a simple random sample

Assignment Help Business Management

Reference no: EM1342913

Important information about Data Analysis and Decision Making

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.

What I need?

I have tried 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? Please help!!

Reference no: EM1342913

Questions Cloud

Important information about thinking and decision making : Important information about Thinking and Decision Making - Analyze and explain the following three different types of thinking styles: Creative, Scientific, and Persuasive Thinking

Data analysis and decision making : Is my reasoning right on this question and Is the question asking for something mathematical that I am not seeing?

Role of perception in the decision making process : How can a person's perception of others impact an organizations behavior and what are the positive and negative effects of using perceptive shortcuts when judging others

Command style management practices : What is the difference between command style management practices of the past and "participatory style" management practices of the present?

Process for generating a simple random sample : Important information about Data Analysis and Decision Making - What is the process for generating a simple random sample

Element of a persons decision-making style : In what situations are group decisions better than individual decisions and when are they not?

Example of decision making under uncertainty : What is an example of decision making under uncertainty and what do you do if your research results don't answer your research question?

Economics for decision-making : Both of these issues are of concern to you, so you decide to have a meeting with the VP of Marketing and the CFO. Explain the differences among inelastic, elastic, and unitary price elasticity to the VP and CFO. Then, what questions would you ask?

Problem solving and decision making : Problem solving and decision making rely on being able to discern between symptoms and the real problem

User Account

All Pages