Diff for "FAQ/rand" - CBU statistics Wiki
location: Diff for "FAQ/rand"
Differences between revisions 1 and 11 (spanning 10 versions)
 ⇤ ← Revision 1 as of 2007-08-15 14:27:00 → Size: 78 Editor: PeterWatson Comment: ← Revision 11 as of 2013-03-08 10:17:32 → ⇥ Size: 736 Editor: localhost Comment: converted to 1.6 markup 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 spreadsheet2. Copy and paste into remaining N-1 rows3. 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.[[http://www.stanford.edu/class/msande121/Materials/ExcelTut.pdf|More on the rand() function]].[[FAQ/rand/spss|There 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 N-1 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.

None: FAQ/rand (last edited 2016-02-18 11:14:32 by PeterWatson)