View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] FortisChet@gmail.com is offline
external usenet poster
 
Posts: 8
Default Sampling in excel

Hi Folks

I'm trying to WRITE down all possible sample sizes from a single toss
of 3 dice. The sample space I have is 216.(6*6*6).

I have the data listed as follows in excel :


1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6


What I want to do is write a code that picks up all possible samples
of size 3. Sampling is with replacement. The code would go through the
list and say pick up 1,1,1 as sample 1, 1,2,1 as sample 2. It would
also recognize that 1,2,1 is not the same as 1,1,2 etc. The ultimate
goal is to add up the components of each of the samples and see what
distribution I will get as the sample size gets larger( Central Limit
Theorem).

Any suggestions on how to get started?

thanks
Chet