Random Sampling in Microsoft Excell 2002

E

EJ Ford

Hi, I'm trying to create a random sample using the Data
Analysis tool in Excell. The problem I'm having is that I
can't figure out how to make a non-repeating sample. I
want all the observations in the sample to be unique. How
do I do this without manually deleting the repeat entries
on the output worksheet?
 
T

Tom Ogilvy

next to the entries, put in the formula

=Rand()

then drag fill down the column.

Sort the data and this column with this column as the key.

Then take the top "n" items.

Regards,
Tom Ogilvy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I make a random sample? 4
Random Sampling 7
how to add a letter to front of column sample ID 2
Random Sampling 5
Select a random sample 2
does ctrl f select cells randomly? 3
Formula numbers and text Trying to pull a random sampling 1
Is it possible to do a random sample of non-numeric data in Excel? 4

Top