The Monty Hall Problem in Excel


I remember this problem from watching an episode of numbers. You’re a contestant on a game show–and you’re given 3 doors to choose from. Behind one door is a shiny new sports car–behind the other 2 are goats. Your goal is to get the sportscar, by choosing a door. But after you choose a door the host reveals one of doors with the goats. Leaving you with you just two doors...