HI,
I am trying to calculate probabilities of a frequency of occurance; what I'm looking for is probably best described by roulette: Say you are playing based on the first 3rd that has a 12/38 chance every time you play. If you use a specific betting strategy 5,10,15,20,30,45,70 etc what is the overall % chances for each; obviously it is 12/38 for the first try, but the next try you win if you hit the first or second time b/c of the betting etc...
Where my problem lies is every time I try to replicate (F9) and count failures or successes I can't figure out how to keep continually adding successes every time a diffferent random number generates. I'm sure there's a simple way to do that but I am hoping ya'll can help me out.
Thanks,
Keith
I am trying to calculate probabilities of a frequency of occurance; what I'm looking for is probably best described by roulette: Say you are playing based on the first 3rd that has a 12/38 chance every time you play. If you use a specific betting strategy 5,10,15,20,30,45,70 etc what is the overall % chances for each; obviously it is 12/38 for the first try, but the next try you win if you hit the first or second time b/c of the betting etc...
Where my problem lies is every time I try to replicate (F9) and count failures or successes I can't figure out how to keep continually adding successes every time a diffferent random number generates. I'm sure there's a simple way to do that but I am hoping ya'll can help me out.
Thanks,
Keith