Excel Random Sampling

  • Thread starter Thread starter Justin
  • Start date Start date
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
 
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
 
No, each sheet contains different number of items. Also what I am sampling is
host names of computers so they are non-numeric.
 
Back
Top