Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Sample with proportions
I want to create a random sample for employee focus groups. In the
final sample, I want to have a representative number of gender, city/state, job level and ethnicity (all fields in the spreadsheet). So for example if there are 50% males and 50% females, I want 50% males and 50% females in the final random sample. If the process involves a macro or VBA, I would appreciate it if you would let me know how to insert it into a file then run it. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I random sample from a set until every sample is selected? | Excel Discussion (Misc queries) | |||
Random Sample | Excel Worksheet Functions | |||
Select a random sample | Excel Discussion (Misc queries) | |||
random sample | Excel Worksheet Functions | |||
Binomial Proportions: Two-Sample Test | Excel Worksheet Functions |