All articles with 'Pi' Tag

CP045: Introduction to Monte Carlo Simulations in Excel

Published on Sep 24, 2015 in Chandoo.org Podcast Sessions
CP045: Introduction to Monte Carlo Simulations in Excel

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
Continue »

Calculate Pi by throwing Frozen Hotdogs !

Published on Nov 28, 2014 in Huis, Posts by Hui, simulation, VBA Macros
Calculate Pi by throwing Frozen Hotdogs !

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.

Continue »