Purchase Solution

Generating a Simple Random Sample

Not what you're looking for?

Ask Custom Question

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!!

Purchase this Solution
Solution Summary

Solution attaches an Excel file that shows how to generate a simple random sample for this quality control problem. 170-word explanation included.

Solution Preview

= rand() function generates a random decimal number in the range 0 to 1. If you want a number in the range 0 to 100, simply multiply it by 100. If you want between 0 to 500, simply multiply it by 500, and so on. But because the original ...

Purchase this Solution
Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Operations Management

This quiz tests a student's knowledge about Operations Management

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

View More Free Quizzes
Related BrainMass Solutions

  • Generating Simple Random Samples

    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. See the attached file.

  • Sampling techniques

    Then do a simple random sample of f = n/N in each strata.  There are several major reasons why you might prefer stratified sampling over simple random sampling.

  • Systematic Sampling and Simple Random Sampling

    484193 Systematic Sampling and Simple Random Sampling Please help answer the following questions. In what ways is a systematic sample more efficient than a simple random sample?

  • Statistics

    A reliable frame of the universities employees and their tentative healthcare preferences are given on the spreadsheet labeled (Question 16/18) a. Use excel to choose a simple random sample of size 45 from the given frame b.

  • Types of Random Sampling

    Does this sampling plan result in a random sample? Simple random sample? Explain. Does this sampling plan result in a random sample? No, the sample is not random because not all voters have the same chance of being selected.

  • Six Types Random Sampling And Example Uses

    A simple random or systematic random sample of items does not produce a good estimate due to high variability. We get a better estimate by giving higher probability of selection to the larger data items.

  • Scholastic Aptitude Test (SAT)

    a) Determine the probability that a simple random sample of 15 students would earn an average score of 1000 or less. b) Determine the probability that a simple random sample of 50 students would earn an average score of 1080 or greater.

  • Identifying Types of Samples

    But this is not a simple random sample, as teachers from schools that were not selected have not been considered in the final sample. 4. This sampling plan results in a random sample, but not a simple random sample.

  • Types of Random Samples

    Does this sampling plan result in a simple random sample? No, it is not a simple random sample because some samples are not possible. For example, a sample includes teachers from schools that were not selected.

View More Related Solutions