Excel Random Sampling

J

Justin

I need to create a spreadsheet that will take a random sampling of 6.25% of
items located on 6 different sheets. The 6.25% needs to be random on each
sheet and not include items already chosen for the sampling. This result
sheet should list the number of items sampled from each of the 6 different
spreadsheets.

Thanks,

Justin
 
T

tom_n_ape

Is the number of items on each of the six sheets fixed? For example,
do you have 100 items on each sheet and then you would like to
randomly sample 6.25% of 100 (or any other fixed number)? If so, then
just use the random number generator to generate unique, integer
numbers from 1 to 100 (or any other fixed number), then sample the
data at those locations and store in the results sheet, then do this
procedure 5 more times to sample all six sheets. The unique, integer
numbers would correspond to the row numbers where the data is found on
each of the six sheets.

~tom
 
J

Justin

No, each sheet contains different number of items. Also what I am sampling is
host names of computers so they are non-numeric.
 
Top