Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Random Sampling
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Random Sampling
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 On Oct 31, 8:33*am, Justin wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Random Sampling
No, each sheet contains different number of items. Also what I am sampling is
host names of computers so they are non-numeric. " wrote: 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 On Oct 31, 8:33 am, Justin wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
random sampling | Excel Discussion (Misc queries) | |||
Random Sampling - Please Help! | Excel Worksheet Functions | |||
Random Sampling | Excel Discussion (Misc queries) | |||
Random Sampling | Excel Discussion (Misc queries) | |||
how to use excel to do random sampling | Excel Discussion (Misc queries) |