Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Monte Carlo simulations

Latest post Thu, May 27 2010 7:44 AM by Chandni. 0 replies.
  • Thu, May 27 2010 7:44 AM

    • Chandni
    • Not Ranked
    • Joined on Thu, May 27 2010
    • Posts 1
    • Points 5

    Monte Carlo simulations

    Hi,

    I want to create a simulation based on one "seed" number so it can not be totally random.  How do I do this?

    Do I have to assume a probability distribution and then simulate?

    For example: if I have a 50% prevalence rate for a disease, I want to know the risk levels of that 50 % (say in deciles) and I thought that I could do this by simulating numbers based on that 50 % and do a frequency distribution to see the number (frequencies) that appear in each decile. This could tell me the probability of someone lying in that prevalence rate bracket.

    Filed under:
    • Post Points: 5
Page 1 of 1 (1 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.