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
 

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

Random Samples 1
Sampling 1
Random Sampling 5
How do I make a random sample? 4
Random Sampling 7
Select a random sample 2
Sampling 1
how to use excel to do random sampling 2

Back
Top