Excel Worksheets for Teaching Probability

Listed below are two illustrative Excel worksheets I designed and used in a course on the theory and practice of teaching probability I co-taught for the Harvard Extension School (2004).

• Buffon's Needle

  This Excel worksheet runs a Monte Carlo procedure which gives an estimate for the value of pi via the classic Buffon's needle problem. The worksheet takes advantage of Excel's random number generator.

  Instructions [PDF]
  Excel Worksheet [XLS]

• The Monty Hall Problem

  This Excel worksheet runs a Monte Carlo procedure which sheds light on the classic Monty Hall problem. The worksheet takes advantage of Excel's random number generator.

  Instructions [PDF]
  Excel Worksheet [XLS]

Page maintained by Derek Bruff (derek.bruff [at] vanderbilt.edu).

Last updated September 3, 2006.

Back to DerekBruff.com