Simple Monte Carlo to Integrate any Function in Excel

[@itissrinivasan]

lovely ! explained in a very simple and concise manner

[@1991lauratjeuh]

you cn pres F4 instead of typing in the doller signs yourself

[@laramie123]

Laura Truyen I was not aware that F4 can be used :) Thanks

[@danielschwegler5220]

thanks

[@ricardofraser4243]

nice method for sharing the area under a curve or segments of intersecting curves by putting constraints :)

[@gmartirosyan]

Good technique! Thanks!

[@ankitknight6304]

can i use this for forecasting, if i have a data base !

[@thehangoveralan]

How can i use a Monte Carlo Simulation for my forecast sales if their have a totally random consume?

[@realestateinvestmentsindia9268]

Almost most of the events in this world are random including stock market or sales in your case. Just put all the numbers in excel, put them in ascending order and plot them on x-axis with y-axis going from 0-1. That will be the probability distribution.

[@vijay1968jadhav]

enjoyed a lot

[@laramie123]

[@mohammedalaamri3447]

Thanks

[@santiabedin5741]

what condition about other function for examples: y=4/1+x^2

[@tanzeelfarooqi2872]

hi everyone and stat teacher, i wana ask how to calculate mean of each "n" number? if we only know the population mean and total number of population, let mean=243 and n=09, i wana calculate mean of each sample by using Monte Carlo method, is that possible? if yes, how to perform it please explain it with simple example? if its not possible what will be other method if any?Tnks

[@OptionTrader]

You can calculate it. There is no other information and no bias and therefore means for all nine populations will be same. So, it would not make any sense. If you have additional conditions that would be intresting.

[@maxmclune3520]

how to use Monte Carlo to simulate the future price of metal?

[@laramie123]

Check out my video on predicting stock price statistically.

[@teresamina6920]

thank you very much for this very valuable information. i really learned a lot from this.

[@shahrulconstitutional261]

Superb

[@unicornland7267]

I need a little help

[@jimhewett100]

Thanks

[@laramie123]