FAQ/rand122016-02-18 11:14:32PeterWatson112013-03-08 10:17:32localhostconverted to 1.6 markup102012-07-09 13:35:20PeterWatsonRevert to revision 6.92012-07-07 17:36:16vps-1088369-8017.manage.myhosting.comLSuezt , [url=http://bgeqftnzueww.com/]bgeqftnzueww[/url], [link=http://slktpwnubwkg.com/]slktpwnubwkg[/link], http://hctznbggnsfo.com/82012-07-07 01:40:08188.116.250.2492dzktS <a href="http://xyylhnoloqru.com/">xyylhnoloqru</a>72012-07-05 10:58:28mail.mercadomadrid.com.coyou have Open Office so you have Calc not Excel.basically you just need to Sort- select all your data in all your clomuns (except the 1st row)- click data- click sort- sort by box gets column G- click62007-08-15 14:41:58PeterWatson52007-08-15 14:40:31PeterWatson42007-08-15 14:40:03PeterWatson32007-08-15 14:39:24PeterWatson22007-08-15 14:33:22PeterWatson12007-08-15 14:27:00PeterWatsonHow 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. Block randomization and other procedures may also be done on-line here. More on the rand() function. There is also easy to use syntax to perform this in SPSS.