I'm looking for help to build a statistic in excel or just mathematically. What I want to figure is the chance of another player (villain) increase his stack with X BBs when I estimate his BB/100 to be Y against me, with the standard deviation BB/100 being Z and the maximum number of hands we play being A.
An example: I play HU and a player sits down. He's a fish so I estimate his BB/100 vs me to be -30BB/100. The problem is he will quit whenever he's 100BBs up. I know the standard dev to be 100BB/100 and we play a maximum of 200 hands. What is the chance of him reaching a 100BB increase vs me with these numbers?
I figured this was the community to post this in, please let me know if I rather should post this in a more general methematical community.