# Calculating the Probability of Reaching a Certain Amount of BB vs Hero

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.

• This is a rather unusual calculation, but poker does involve a lot of mathematics. So yes, you posted in the right place :) May 27, 2014 at 21:31
• Good Q. I can't answer it, but I tweeted & Facebooked it ;) May 27, 2014 at 22:08

``````=1-NORMDIST(X, Y * A / 100, Z * SQRT(A / 100), TRUE)