78
Comment:

← Revision 12 as of 20160218 11:14:32 ⇥
841

Deletions are marked like this.  Additions are marked like this. 
Line 1:  Line 1: 
Describe FAQ/rand here. = 1. How do I generate a random sample in EXCEL? = 
= How do I generate a random sample in EXCEL? = Let us suppose we wish to randomly sample n cases of data comprising N people. 1. Put =RAND()*N in row 1 of the column adjacent to the right most data column in the spreadsheet 2. Copy and paste into remaining N1 rows 3. Go to Data>sort on the EXCEL menu and make sure you sort in ascending order by the column you have just created. Click OK. 4. Delete rows n+1 to N. We have randomly permuted the data rows so that the first, or any adjacent, n rows represent a random sample of size n. Block randomization and other procedures may also be done online [[https://www.random.org/  here.]] [[http://www.stanford.edu/class/msande121/Materials/ExcelTut.pdfMore on the rand() function]]. [[FAQ/rand/spssThere is also easy to use syntax to perform this in SPSS.]] 
How do I generate a random sample in EXCEL?
Let us suppose we wish to randomly sample n cases of data comprising N people.
1. Put =RAND()*N in row 1 of the column adjacent to the right most data column in the spreadsheet
2. Copy and paste into remaining N1 rows
3. Go to Data>sort on the EXCEL menu and make sure you sort in ascending order by the column you have just created. Click OK.
4. Delete rows n+1 to N.
We have randomly permuted the data rows so that the first, or any adjacent, n rows represent a random sample of size n.
Block randomization and other procedures may also be done online here.