I’ve started a fun Excel project: Blackjack Odds Generator.
You’ve seen the blackjack charts that show you what to do if you have 6,6 and dealer shows a 4. I want to make a generator in Excel that allows you to see what choice you should make based on the odds.
I’d also like to see the real odds—not just the recommended action Hit, Stand, Double, Split. I’d like to see how the odds change with 1 deck, 2, 4, 6, auto-shuffle, etc… I’d also like to see how the odds change when different rules are in play such as “Dealer hits soft 17”, “can split 1 time with Aces”, “Can split 2 times with Aces”, etc….
The problem is, while my Excel skills rock, my stats do not. I vaguely remember “n choose k” binomial crap. I can even use PROB() function in Excel to some success.
Any of you Stats geniuses want to walk through steps involved here with me? Respond to this post and let's see what ya got.
Roger!
Bookmarks