|
Size: 273
Comment: you 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- click
|
Size: 733
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| you 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- click Ok and you are done. Was this answer helpful? ---- CategoryHomepage |
= 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. [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.
[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.]