Creating a formula via VBA

Anyone know what kinda of statistic function i should be using? The "If" "then" functions??

Okay, so I asked a University professor at what kind of formula I should use to figure this type of issue out and he said this:

In this instance, the intuitive answer is the
correct one. In particular, the probability
that 5 is included in your set of four numbers
given that 6 is included is 3/9 = 1/3.

This can be verified by the calculation

(8 choose 2)/(9 choose 3).

The numerator being the number of ways to select
two numbers from eight (the 5 and 6 being
prescribed) and the denominator being the
number of ways to select three numbers from nine
(the 6 being prescribed). I hope this is
helpful to you. Often the unintuitive solution
is the correct one, but not in this case.

So I was wondering if anyone can help me make a excel macro/script that will do this calculation. =D

bumping for love =)

anyone have a clue what i am talking about?

I do understand what you are asking, but, unfortunately, I didn't take enough statistics classes to get a real grasp of anything more than basic probability calculations. (Aside: I often wish I had taken more statistics classes. This kind of thing is really interesting). This is evidenced by the fact that I barely understood your university professors response.

Perhaps if I understood his notation (8 choose 2)/(9 choose 3), I could understand what he's saying better.

I did a quick google search. I think this is a problem that falls under combinatorials and permutations. Excel has functions for these kinds of things (see Excel help for statistical functions), but I don't know how to put them together to get the solution to the problem. When you figure it out, share with the rest of us so we can all learn.