random sampling
Hi,
In column 5 enter the formula
=rand()
double click the fill handle and it should autofill down to the length of
column 4
Select all 5 columns and click
Data|sort|column E
and sort the columns
the top 150 will be randomely selected each time you sort
Mike
"staciern" wrote:
Hello
I have a list of 705 patients with four different columns with data in it.
I need a random sample consisting of 150 of those patients. Can someone
please help?
--
Stacie
|