How can i set up a MONTE CARLO SIMULATION macro in Excel? thx

[Guest]

I'm looking for a simple macro for Monte carlo sim? I'd apprectiate any help.

many thanks

 

[Mike Middleton]

Please see a reply in your multiple-post in
microsoft.public.excel.programming.

 

[Bob Phillips]

Don't know about a simple formula, my understanding of Monte Carlo
simulations is that it is not simple, but the a search on Google using
'monte carlo excel vba' threw up 6,000+ entries. Take a look
http://tinyurl.com/axzsg

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[michael.stringfellow]

I've used the Crystal Ball addin to run MC simulations. I don't
think std Excel has the capability. Crystal Ball is pretty sweet but
it ain't cheap.

Check the following web site:
http://www.decisioneering.com/

 

[Guest]

Hi Excel provides all the formulas for you to be able to do the Simulation
but you have to put them together yourself. For instance if you want to
simulate 10 tosses of a coin, you enter the formula to generate a random
number in A1 (=rand()) and another formula in B1 (=if(A1<=.5,"T","H")) and
copy A1:B1 in A2:B10. Then each time you recalculate, you get a result of 10
tosses of a coin.
You can generate random numbers in any range based on Normal and other
probablilty distributions as all those formulas are there.
Alok Joshi