This video provides a simple introduction to how to run a Monte Carlo Simulation (MCS) in Excel. The example is for estimating profits given uncertainty in costs and revenue.
Пікірлер: 93
@nachtalp75003 жыл бұрын
It is always unbelievable what gold nuggets one can find in KZbin. Thanks a lot! I thought about to programm something in VBA but I had no clue how build the routines. Very easy approach - GREAT!
@tbaerg3 жыл бұрын
Fantastic tutorial. I deployed this in a manufacturing scenario within 30 minutes. Much appreciated!
@chuckbecker49834 жыл бұрын
A simpy wonderful tutorial. I now grasp the fundamental concepts of a Monte Carlo simulation and I learned some new-to-me features of Excel. Thank you!
@MrSeropamine2 жыл бұрын
Best explanation for this I have found on KZbin, thank you. I even did a course where this was taught in an engineering risk analysis context- I did the thing but I didn't understand the nuts and bolts, whereas this explains it very clearly.
@zakirkassam73213 жыл бұрын
Videos like these are saving me during online school
@jhonthestampede2 жыл бұрын
And saving a lot of money with a monte carlo software haha xD
@luvsketchimprovvv17814 жыл бұрын
thank you very helpful for my corporate finance course! our teacher chose this video specifically.
@serkankaraman1711 Жыл бұрын
Fantastic! Thank you very much Maggie for creating a clear and precise tutorial.
@patrickbhirdo2869 Жыл бұрын
Great and simple explanation. Agree with some other comments on here that it's one of the most concise explanations I've seen on youtube and on hte internet.
@thelegolegend12 жыл бұрын
This actually worked for my NPV calculation and now I can apply it for my group project, thanks very much!
@Eng_Kitumesh Жыл бұрын
The best explanation out there. Thank you
@delicious99302 жыл бұрын
Wow you’re amazing - All this is a short straightforward video TYVM
@brigittaadinda4 жыл бұрын
this is very simple yet answers most of my questions. thank you so much!
@joerinaldi34182 жыл бұрын
Very clear and easy to follow explanation. Thank you for putting this together.
@moosesnWoop3 жыл бұрын
Simple and straightforward. I'm self-learning to assist my own investments so I thank you for a simple tutorial.
@kishan95064 жыл бұрын
I don't know about Monte carlo but I have learned some cool Excel tricks in this video.
@ANJA-mj1to9 ай бұрын
What to say or thank you for valuable information how to imply Monte Carlo method in Excel. Despite development of modern numerial and stohastiv methods with many desirable properties, most of hydraulic problems are based on Monte Carlo method BASED ON FINITE ELEMENT AND FINITE VOLUMEN APPROACH + adding yours Content we can assume many desirable concepts. Thank you for all good Excel workout!
@viktorvondoom91192 жыл бұрын
Thanks! I think you just explained my whole assignment
@1MRNICKER Жыл бұрын
Thanks Maggie!
@Liberty_Freedom_Brotherhood3 жыл бұрын
I did a Monte Carlo simulation for the risk of me taking about 100x times longer than the video to do a successful simulation: risk = 100%😂
@junal27 Жыл бұрын
Thank you, very usefull and clearly explained!
@megalallulal3 жыл бұрын
Thanks a lot....you made my day...pretty helpful
@jessica386m3 жыл бұрын
I wished my professor taught this quickly and cleared!
@HarshitSharma-lb3ul3 жыл бұрын
ohhh, thank you so much for this example! I finally get it!
@sijokuriakose38953 жыл бұрын
wow awesome video. Learned a lot. even some shortcuts in excel lol
@peakfeeling73112 жыл бұрын
Thank you very much
@MrGroganmeister2 жыл бұрын
That was very helpful. Thanks.
@QueenChanise Жыл бұрын
BLESS YOU!!! THANK YOU SO MUCH
@deepaktimsina1119 ай бұрын
Hi. Very nice tutorial. I have district wise immunization coverage for 60 months (5 yrs). Can I apply Monte Carlo to forecast the coverage for next year?
@hyunchulkim97073 жыл бұрын
Thanks for a nice video. It's helpful.
@nikhilverma64574 жыл бұрын
Really very nice example and explanation. Thanks.
@longjohnsilverin24683 жыл бұрын
Great ! Found it helpful ... Thanks
@stellaunya5192 Жыл бұрын
thank you so much
@kingka03123 жыл бұрын
thank you so much for this! instruction makes perfect sense to me 👍
@FaRosVPL4 жыл бұрын
This was helpful, thanks!
@vahidvahdat71304 жыл бұрын
Pretty helpful, and amazingly simple, Thank you so much for your help
@DanaJomaa2 жыл бұрын
Thank you for the video
@steveadams50853 жыл бұрын
Thanks for this! Super helpful.
@bigfriki3 жыл бұрын
Awesome video. Simple and clear :)
@hawaiisunkissselftanner48904 жыл бұрын
Thanks! It is very clear!
@Gracethedog1012 жыл бұрын
Maggie, do you offer formal training? I found your approach easy to learn from.
@tomatosquare40122 жыл бұрын
amazing explanation! 😃
@laskuri13932 жыл бұрын
good demonstration.
@konalsharma60404 жыл бұрын
Thanks a lot, Very well explained , It was really Helpful
@nikhilverma64573 жыл бұрын
Very helpful. Thanks.
@mikechapman25934 жыл бұрын
This is amazing! Love your work!
@ApoorvaDixit14884 жыл бұрын
Very nicely explained. But should it give possible negative value of profits when there is no chance of it, if we adjust the Std. Deviation in that way?
@abrarkhan98065 жыл бұрын
It was quite helpful. Thanks
@guybolt23462 жыл бұрын
at 2:34, why does typing the word "Trial" in cell H2 cause the values in row 8 to change when none of the formula you typed are looking at that cell!?
@6toolbaseball2 жыл бұрын
Because of the rand() function that is in the worksheet
@Liberty_Freedom_Brotherhood3 жыл бұрын
great video, nice work!
@dex4614 жыл бұрын
Awesome video! I have a follow up question. So when you are recalculating to pull another random set of values, would you collect all the different randomly calculated values, and pull average, std, etc. on those random simulated values? Or would the better option be to either increase or decease the amount of trials?
@BalochistanWatan6 ай бұрын
Anybody got the answer?
@iniyavankarthikkaran85754 жыл бұрын
Hey, really well explained, just wanted to know why you took in risk of loss calculation denominator as 500 please, am I missing something here, sorry if obvious, really appreciate your video :)
@SamerBajaber4 жыл бұрын
She had 500 trials total.
@maggiewinslow21624 жыл бұрын
It's because we used 500 trials. We wanted to know what percent showed a lost, not the total number that showed a lost.
@JalanJalanAjah Жыл бұрын
@@maggiewinslow2162 Thank you so much!
@kostasspanos19844 жыл бұрын
very helpful to start ..many thanks
@Hemzees4 жыл бұрын
Hi, thank you for this video. I would like to use this in my research and I am using it to simulate vulnerability due to climate change. I wonder what would be more valid; to simulate responses to a questionnaire or to simulate the final score of vulnerability? I hope you can answer my question. Thanks
@wctyna4 жыл бұрын
very helpful. thank you!
@firmanmuntako98864 жыл бұрын
hi. thank you.. keep up the good work
@TheAPUSH4 жыл бұрын
Amazing! Thank you so much.
@jj-wz1im2 жыл бұрын
Hi Maggie, On Risk of Loss, excel does not seem to read cell B12 when I use COUNTIF. It only gives me a % if I hardcode the mean number. Any ideas why that is?
@smallhousesdesign66633 жыл бұрын
Thank you so much
@chisomnneke86674 жыл бұрын
I tried running the simulation on my system,all is working except the risk of loss is changing.the value is just 100% even tho I have tried recalculating ,what do you think it’s the problem ?
@xlingdai1003 жыл бұрын
Well, I have a Q for MCS. The calculated mean st min max keeps changing. So how can it apply to work?
@alangecastelly31374 жыл бұрын
Great video!
@FlywithZahanat4 жыл бұрын
Good and helpful
@appknow82532 жыл бұрын
How did you come up or find the standard diviation
@maestro70584 жыл бұрын
THANK YOU SO VERY MUCH!!!!!!!
@sidharthmohanty64342 жыл бұрын
Thank you
@Asoville183 жыл бұрын
Thank you 😊
@hamzatarq70004 жыл бұрын
izi n simple ty
@khadijasajid14904 жыл бұрын
Thank you!
@jiabinchen19342 жыл бұрын
Nice!
@suryakantyadav84275 жыл бұрын
when do we use pert distribution?
@bonzaiii73 жыл бұрын
brilliant!
@sennikau3 жыл бұрын
Great!
@ensys10004 жыл бұрын
Thanks
@mariner7353 жыл бұрын
i got lost at "what if "' sosimply do not understand what is being done and I am looking for a new basic tutorial for the PC not the max
@ngzhenyiaiden73843 жыл бұрын
Thank you (:
@cx54423 жыл бұрын
5:16 Why did you divided the term by 500?
@maggiewinslow21623 жыл бұрын
Because I ran 500 trials.
@cx54423 жыл бұрын
@@maggiewinslow2162 understood, thanks
@jasontoo5 жыл бұрын
How is this useful? Your Mean and Std Dev would just converge to the input parameters. e.g. 34500 for the mean.
@bradk12954 жыл бұрын
The mean isn’t very interesting, it’s the other information that makes the simulation useful, such as modeling the number/percentage of times the investment loses money. This was a very simple example, but you can build very complex simulations. It’s a very powerful tool in that has quite a few applications.
@daviddewis22863 жыл бұрын
Jason, it was meant to be a tutorial to explain the basics. It was an excellent tutorial, short and informed, it provides what is required to use the process as we wish. I look forward to your tutorial that incorporates probability density functions.