Hi guys, currently I am working on a probability of game to keep winning after a win streak. Right now, probability of game winning after lose streak is working nicely. Please check excel sheet for more clarification.
10th game shows 75% probability to win based on past records, but 75% is for all first games after a win, and after wins.
Should show 67% as in 2 wins in a row based on past data yields only 67%. Likewise, if the 10th game wins, the 11th game should show 50% as is the case with past data.
How can the game no. formula be tweaked to record both games lost in a row streak and games won in a row streak so as to differentiate between games won in a row from games won after a streak lose?
Apologize for my language as I am still learning!!
Bookmarks