Random selection

Copper Contributor

Must make a selection from a list of landowners at random. There are different size landowners, some have 10 ha and up to 2000 ha. The selection must be area-weighted, ie a large one must have a greater chance of being drawn.

The number that will be raffled off is 100 out of 2000. My first thought was that every landowner gets a lottery ticket for every hectare. So then a large landowner has many lots and a small few. Then the chance of being drawn is greater due to the area.

But how to get a list of these 100 selected by the lottery is the question. The landowners should only be selected once, a large one with many lots should only be selected once.

How to do.

LAJ

1 Reply
Which Microsoft product is your topic exactly about?