Monte Carlo Simulations: Run 10,000 Simulations At Once

Run Monte Carlo simulations in Excel with this simple workaround.

Produced by Sara Silverstein
----------------------------------------­----------

----------------------------------------­----------

Business Insider is the fastest growing business news site in the US. Our mission: to tell you all you need to know about the big world around you. The BI Video team focuses on technology, strategy and science with an emphasis on unique storytelling and data that appeals to the next generation of leaders – the digital generation.

[americanexpat]

Amazing what this woman taught in 3 minutes. Honestly, spectacular! Used what she taught successfully.

[ibarix]

absolutely brilliant, can't believe so much was stuffed in in just 3 minutes

[nelsonchan]

This woman is able to demonstrate complex calculations using simple methods, which is stunning.

[mattgreene]

Thanks! Half the internet said you couldn't do this, but I knew there had to be an easy way. This was perfect!

[erikbennacer]

There is a saying in Russian "коротко и ясно", meaning "clear and concise". This is about this video.

[dennisombaka]

Just the exact tutorial I have been looking for. She is the best.

[jaychandran]

Thank you for taking the time out to explain this in such simple terms.

[fredg]

This was VERY helpful…and all in less than 4 minutes! Now can I get back the 2+ hrs I spent watching the other MCS videos? 🤔

[sleepyr]

really love this video. finally understand the meaning of Monte Carlo

[mozzarella]

Thankyou for helping out with the school project

[MySpreadsheetLab]

Very nice use of Excel's Data Table! Thanks for sharing Sara.

[Tyokok]

Thanks for great video! One question, in your example, you simulate weekly return actually, is it equivalent to use weekly return mean and weekly return stdev to proceed? ( is it equivalent to scale daily parameters to weekly then proceed ?) Thank you!

[JrnLodahlDK]

very much to the point explanation. thank you!

[sogaita]

Quite interesting. You should doubled the trials to see if your outcome was approximately the same. 📊

[jimparsons]

Clever girl. Liked the direct approach. Thanks.

[DiazIvar]

Nice video! Just why are u using (A+1)*(B+1)-1 instead of simply adding (A+B). Is an error to simply add the percentages in the cumulative?

[manuelmusa]

I have been waiting for this day.. hurray. I was looking for how to save all your videos on the BI website.. the opportunity is here.

[yvesdelombaerde]

Speed everything up with VBA code, VBA formulas, Excel formulas through VBA, freeze the screen (screen.updating=false) first then compute everything then unfreeze the screen. Your computer can generate several hundreds of millions of pseudorandom numbers in a second and this was 15 years ago when I built simulation for bootstrapping confidence intervals for forecasts.

[OfficialCaddyGPT]

Hey! Could anyone please explain to me what she did for cell "Tuesday" x "Cumulative"? Thanks y'all!

[whatsup]

double A++ on the Excell, but I have serious reservations about the math. Since ever percent comes from a different base, growing bases shrinks returns and shrinking bases increase returns thus cycling produces growth estimates which probably are not real