A random sample is defined as a sample where each individual member of the population has a known, non-zero chance of being selected as part of the sample. 3.Look back to the population list, and find out the corresponding member name of the selected number. For this reason, simple random sampling is more commonly used when the researcher knows little about the population. The reasons to use stratified sampling rather than simple random sampling include This wikiHow teaches you how to generate a random selection from pre-existing data in Microsoft Excel. For instance, to do an election poll, calling people randomly out of the phone book would be better than asking people at a labor union meeting or at a small business convention. In practice, random samples are always taken by means of a well-defined procedure. The necessity to have a large sample size can be a major disadvantage in practical levels. The use of random number table similar to one below can help greatly with the application of this sampling technique. For example, if your data in columns "B" and "C" extends all the way down to cell 100, you would hold down. For example: you might place your users' names in the "A" column and their responses to a survey (e.g., "yes" or "no") in the "B" column. This article has been viewed 413,218 times. % of people told us that this article helped them. If applied appropriately, simple random sampling is associated with the minimum amount of sampling bias compared to other sampling methods. Depending on the type of data you have, this process will vary. For instance, to do an election poll, calling people randomly out of the phone book would be better than asking people at a labor union meeting or at a small business convention. For example, if your data in columns "B" and "C" extends all the way down to cell 100, you would hold down ⇧ Shift and click "A100" to … Clicking the "A1" cell and highlighting from there can cause a sorting error. When I copy the random values from column A and paste them in column B following the paste special -> values instruction, I get a different set of numbers from what I have in column A. A random sample is a sample taken at random from a population of data. Number each of the member from 1 to N (N is the population size). Consider the problem of designing a sample to predict the result of an election poll. For example, his sampling method is not suitable for studies that involve face-to-face interviews covering a large geographical area due to cost and time considerations. Can I make a random sampling with only a certain set of numbers? Probability sampling, or random sampling, is a sampling technique in which the probability of getting any particular sample may be calculated. You can also right-click the "RAND" cell and then select. Purposive sampling (also known as judgment, selective or subjective sampling) is a sampling technique in which researcher relies on his or her own judgment when choosing members of population to participate in the study. Get them involved in your research! The sample size in this sampling method should ideally be more than a few hundred so that simple random sampling can be applied appropriately. This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. Highlight the rest of the random sample cells. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/ba\/Create-a-Random-Sample-in-Excel-Step-1-Version-4.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-1-Version-4.jpg","bigUrl":"\/images\/thumb\/b\/ba\/Create-a-Random-Sample-in-Excel-Step-1-Version-4.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/11\/Create-a-Random-Sample-in-Excel-Step-2-Version-4.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-2-Version-4.jpg","bigUrl":"\/images\/thumb\/1\/11\/Create-a-Random-Sample-in-Excel-Step-2-Version-4.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4d\/Create-a-Random-Sample-in-Excel-Step-3-Version-4.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-3-Version-4.jpg","bigUrl":"\/images\/thumb\/4\/4d\/Create-a-Random-Sample-in-Excel-Step-3-Version-4.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Create-a-Random-Sample-in-Excel-Step-4-Version-4.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-4-Version-4.jpg","bigUrl":"\/images\/thumb\/f\/fe\/Create-a-Random-Sample-in-Excel-Step-4-Version-4.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2b\/Create-a-Random-Sample-in-Excel-Step-5-Version-4.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-5-Version-4.jpg","bigUrl":"\/images\/thumb\/2\/2b\/Create-a-Random-Sample-in-Excel-Step-5-Version-4.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c1\/Create-a-Random-Sample-in-Excel-Step-6-Version-4.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-6-Version-4.jpg","bigUrl":"\/images\/thumb\/c\/c1\/Create-a-Random-Sample-in-Excel-Step-6-Version-4.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b5\/Create-a-Random-Sample-in-Excel-Step-7-Version-3.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-7-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/b5\/Create-a-Random-Sample-in-Excel-Step-7-Version-3.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5d\/Create-a-Random-Sample-in-Excel-Step-8-Version-4.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-8-Version-4.jpg","bigUrl":"\/images\/thumb\/5\/5d\/Create-a-Random-Sample-in-Excel-Step-8-Version-4.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-8-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Create-a-Random-Sample-in-Excel-Step-9-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-9-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/4c\/Create-a-Random-Sample-in-Excel-Step-9-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e6\/Create-a-Random-Sample-in-Excel-Step-10-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-10-Version-2.jpg","bigUrl":"\/images\/thumb\/e\/e6\/Create-a-Random-Sample-in-Excel-Step-10-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c3\/Create-a-Random-Sample-in-Excel-Step-11-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-11-Version-2.jpg","bigUrl":"\/images\/thumb\/c\/c3\/Create-a-Random-Sample-in-Excel-Step-11-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/83\/Create-a-Random-Sample-in-Excel-Step-12-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-12-Version-2.jpg","bigUrl":"\/images\/thumb\/8\/83\/Create-a-Random-Sample-in-Excel-Step-12-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f5\/Create-a-Random-Sample-in-Excel-Step-13-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-13-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/f5\/Create-a-Random-Sample-in-Excel-Step-13-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8f\/Create-a-Random-Sample-in-Excel-Step-14-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-14-Version-2.jpg","bigUrl":"\/images\/thumb\/8\/8f\/Create-a-Random-Sample-in-Excel-Step-14-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f9\/Create-a-Random-Sample-in-Excel-Step-15-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-15-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/f9\/Create-a-Random-Sample-in-Excel-Step-15-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/38\/Create-a-Random-Sample-in-Excel-Step-16-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-16-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/38\/Create-a-Random-Sample-in-Excel-Step-16-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/62\/Create-a-Random-Sample-in-Excel-Step-17-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-17-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/62\/Create-a-Random-Sample-in-Excel-Step-17-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3e\/Create-a-Random-Sample-in-Excel-Step-18-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-18-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/3e\/Create-a-Random-Sample-in-Excel-Step-18-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Create-a-Random-Sample-in-Excel-Step-19-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-19-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/d3\/Create-a-Random-Sample-in-Excel-Step-19-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-19-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2f\/Create-a-Random-Sample-in-Excel-Step-20-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-20-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/2f\/Create-a-Random-Sample-in-Excel-Step-20-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2e\/Create-a-Random-Sample-in-Excel-Step-21-Version-2.jpg\/v4-460px-Create-a-Random-Sample-in-Excel-Step-21-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/2e\/Create-a-Random-Sample-in-Excel-Step-21-Version-2.jpg\/aid3684338-v4-728px-Create-a-Random-Sample-in-Excel-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"