Random Sampling in Microsoft Excell 2002

  • Thread starter Thread starter EJ Ford
  • Start date Start date
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?
 
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
 
Back
Top