Question

How do I draw 5 random samples of sizes 50, 100,250 and 500 on excel.

Additional context: The random samples come from a population I already have. Any help would be deeply appreciated. Thank you!

Answer 1

Let us consider you have a population lets say in column X.

1. Now create a new column with the name random.
2. now in the first cell in the column random use function '=RAND()' and press enter. This will generate a random number between 0 to 1
3. Now drag that cell to the corresponding last cell of column X.
4. Now copy and paste column random in the another column because each time you refresh the page the values in random column will get change. So, to avoid this we do copy paste.
5. Now select both the columns X and random and click on data option in the toolbar. Then click on sort.
6. Then a dialog box will appear. Then in the sort by, select random and click ok.
7. Now this will generate your data in the random order. So. now select the samples of size ,50,100,250 and 500.