This paper uses the game of roulette in a simulation setting to teach students in an introductory Stats course some basic issues in theoretical and empirical probability. Using an Excel spreadsheet with embedded VBA (Visual Basic for Applications), one can simulate the empirical return and empirical standard deviation for a range of bets in Roulette over some predetermined number of plays. In particular, the paper illustrates the difference between different playing strategies by contrasting a low payout bet (say a bet on “red”) and a high payout bet (say a bet on a particular number) by considering the expected return and volatility associated with the bets. The paper includes an Excel VBA based simulation of the Roulette wheel where students can make bets and monitor the return on the bets for one play or multiple plays. In addition it includes a simulation of the casino house advantage for repeated multiple plays; that is, it allows students to see how casinos may derive a new certain return equal to the house advantage by entertaining large numbers of bets which will systematically drive the volatility of the house advantage down to zero. This simulation has been shown to be especially effective at theUniversityofCape Townfor teaching first year Statistics students the subtler points of probability, as well as encouraging discussions around the risk-return trade-off facing gamblers. The program has also been shown to be useful for teaching students the principles of theoretical and empirical probabilities as well as an understanding of volatility.

Roulette simulation.xlsm (107 kB)
Roulette simulation