Select 50% of each item in a list

[Niels]

For modelling purposes I have a list with records of plant species. I
need of each species randomly 50% to run in my modelling software and
the other 50% I use for testing. Any suggestions on how to split this
dataset? Regards,

Niels

 

[James Silverton]

Niels wrote on 20 Sep 2005 06:08:35 -0700:

N> For modelling purposes I have a list with records of plant
N> species. I need of each species randomly 50% to run in my
N> modelling software and the other 50% I use for testing. Any
N> suggestions on how to split this dataset? Regards,

N> Niels

I would say that it depends a lot on how the list is formatted.
You can certainly randomly select 50% of the rows of an Excel
worksheet by generating a column with random numbers and
selecting the even ones for 50%.. Access can randomly number
records tho' I've never tried it.

James Silverton.