2009
07.02
07.02
Adam A asked:
I need excel to output every possible sample of size n from a small population.
Eg from a population of three discrete numbers x, y and z there are 9 possible samples of size 2 (with replacement). I have tried the sampling tool in excel but this only draws random observation it does not give groups of possible samples. Any help on this would be much appreciated as i have spent a long time on this!!!
Thanks
Kristen
I need excel to output every possible sample of size n from a small population.
Eg from a population of three discrete numbers x, y and z there are 9 possible samples of size 2 (with replacement). I have tried the sampling tool in excel but this only draws random observation it does not give groups of possible samples. Any help on this would be much appreciated as i have spent a long time on this!!!
Thanks
Kristen
Darlene
Use the link below to get to a web page that has complete code to do what you want with only slight modification.