Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sampling
Choose a random sample of size 20 from 1,2,3,...,100
Using excel 2003: enter 1 2 3 ... 100 in column A from analysis tools, select sampling enter A1:A100 in input range select random enter 20 in number of samples enter B1 in output range OK the number 14 appeared twice in column B Who is at fault: me or excel? John Adams Bethlehem, PA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sampling
Nobody's at fault - the random sampling is done with replacement.
Here's a way to do sampling without replacement: http://www.mcgimpsey.com/excel/udfs/...noreplace.html In article , John Adams wrote: Choose a random sample of size 20 from 1,2,3,...,100 Using excel 2003: enter 1 2 3 ... 100 in column A from analysis tools, select sampling enter A1:A100 in input range select random enter 20 in number of samples enter B1 in output range OK the number 14 appeared twice in column B Who is at fault: me or excel? John Adams Bethlehem, PA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sampling Program | Excel Worksheet Functions | |||
A Sampling Program | Excel Discussion (Misc queries) | |||
Random Sampling rows | Excel Discussion (Misc queries) | |||
Random Sampling | Excel Discussion (Misc queries) | |||
Sampling | Excel Discussion (Misc queries) |