# Thread: Directions to do Random Sampling (2003)

1. ## Directions to do Random Sampling (2003)

I have the following directions to do a Random Sampling but can't figure out how to proceed from my directions:

Say you have dates (or some number field) in A1:A1000
In B1, enter =RAND()
Fill down by double clicking the fill grip in the lower right corner of B1
Sort on Column B
Select and copy the top n cells in Column A (where do I copy it)
Each time the sheet is recalculated (sorted), the random numbers will change

I have a spreadsheet where I would like to do a random sampling but can't figure out these directions. Do I need a column that is a number? If so, can I create a column of numbers from 1 to how many rows? How do you recalculate? As usual I write down directions and then can't figure out what I did. Can anyone explain how to get a random sampling from the above directions or if there is a better way, I would be grateful for any help provided.

Thanks

2. ## Re: Directions to do Random Sampling (2003)

I assume that you want to extract a random sample from some existing data. These data must be in a table format, i.e. each row is a "record" of data. You want to draw some rows at random from the table.
1. <LI>Let's say your data are in A1:F100, with column headings in row 1, so the actual data are in rows 2 through 100. Cells A1 through F1 should all be filled.
<LI>You'll need to have at least two empty columns to the right of the data table; if necessary insert new columns.
<LI>Enter a new column header, say Random in G1 (G is the column immediately to the right of the data; it should be blank)
<LI>Enter the formula =RAND() in G2.
<LI>Fill down this formula to G100 (row 100 is the last row of the data table).
<LI>Click in cell G1, then click the Sort Ascending button on the Standard toolbar (A above Z with a downwards arrow).
<LI>The rows of the data table will be sorted in a completely random order.
<LI>If you want to draw a sample of 10 rows, select the column headers with the first 10 data rows (i.e. rows 1 through 11 in total), copy to the clipboard, and paste where you need them.
To draw a new sample, press F9 to make the formulas recalculate, then repeat steps 6 through 8.

3. ## Re: Directions to do Random Sampling (2003)

Thank you for the explanation.
I will try this.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•