How to Run a Monte Carlo Simulation in Excel
In this video, I show you how to build a Monte Carlo Simulation in Excel. We will stop guessing and start calculating. By running 1,000 different scenarios in seconds, we will calculate the exact mathematical probability of losing money on your next project.
Functions used:
NORM.INV(probability,mean,std_dev)
RAND()
COUNTIF(range,criteria)
CALCULATORS | Amazon Affiliate Links
Best Overall:TI-84 Plus CE (Approved for SAT/ACT/College Exams): https://amzn.to/4s95fPn
Pro Choice: TI-Nspire CX II CAS (Advanced graphing & color screen): https://amzn.to/49rav9r
Budget King: Casio-fx-CG50 PRIZM (3D graphing at a lower price): https://amzn.to/4jdbvkV
Scientific (Non-Graphing): TI-36X Pro (Perfect if your prof bans graphing models): https://amzn.to/4jdXQtW
Stuff I use | Amazon Affiliate Links
Keyboard-Corsair K70: https://amzn.to/3LQDhay
Mouse-Logitech G502: https://amzn.to/3NMPNbE
Headset-HypercloudX: https://amzn.to/49zJnp7
Microphone-Audio Technica AT2020: https://amzn.to/4bAjoyT
Microphone Stand-Neewer Mic Arm: https://amzn.to/4pEBuDn
Audio Interface-M-Track Duo: https://amzn.to/4sHfLxg
Disclosure: As an Amazon Associate, I earn from qualifying purchases. These links help support the channel at no extra cost to you!
#Excel #MonteCarlo #RiskAnalysis #DataScience #Finance #Oblixarr