The Dice Roller and the Coupon Collector
For this post I will be showing you how to build a dice rolling simulator and, more largely, how to calculate then simulate problems known as “coupon collector” problems, all using Excel and VBA. Starting off with the question, how many rolls of a die would you expect to need in…