I have recorded the number of caramels pulled from each trial set.

I found that 18.25% of the time, I would pull out 6 caramels from

a set of 30 pieces of candy pulled.

**Now Comparing the results from the last 20 trials of how many caramels were pulled out of each set of 30 pieces of candy,**

What function do I use to return the probability

that 6 caramels will be pulled from the next set of 30 pulled?

What function do I use to return the probability

that 6 caramels will be pulled from the next set of 30 pulled?

Sample data:

last 20 trials (# of caramels pulled from each set of 30):

A1:A20=11,2,7,7,12,8,7,7,7,5,12,8,5,9,

**6**,4,10,8,7,7

In the current example 6 caramels pulled has only occurred

once in the last 20 trials.

Im not sure if the HYPGEOMDIST function is the closet solution type.