All articles with 'Pi' Tag
{ 1 Comment }
CP045: Introduction to Monte Carlo Simulations in Excel
Published on Sep 24, 2015 in Chandoo.org Podcast Sessions
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 45th session of Chandoo.org podcast, let’s get in to Monte Carlo simulations.
What is in this session?
In this podcast,
- Quick personal updates – 200km BRM and book delay
- History of Monte Carlo simulations
- Monte Carlo simulations – an example
- How to do simulations in Excel
- Formulas
- VBA
- Data Tables
- Using data tables to run simulations – case study – estimating Pi value
- Things to keep in mind when setting up your simulation models
- Resources on Monte Carlo simulations in Excel
- Conclusions
Did you know you can Calculate Pi by throwing Frozen Hotdogs !
No ?
Learn how to calculate Pi by throwing Frozen Hotdogs with this Excel Simulation of Buffon’s Needle.