+ Reply to Thread
Results 1 to 1 of 1

Risk Analysis Question

  1. #1
    Registered User
    Join Date
    06-03-2014
    Posts
    14

    Risk Analysis Question

    Hey,
    I'm trying to create a Monte Carlo simulation for this excel sheet. Essentially in this excel, I have a number of different risks, with a different likelihood. Each likelihood corresponds to a particular probability of occurrence. And each risk is associated with a cost.

    So what i'm trying to do is create a simulation for each risk where if I put in the likelihood (probability) and the cost, the excel runs a formula/function or VBA that gives me let's say 100 iterations different costs that fall within the probability range. Then graphically it graphs's the the iterations on the x-axis and the all costs on the y-axis.

    Not to make it more complicated but if it can do different distributions like below that'd be great!
    1= Uniform
    2= Normal
    3= Bernoulli
    4= Binomial
    5= Poisson
    6= Patterned
    7= Discrete

    And unfortunately, this has to be run in Excel alone without any add-ons like @RISK, etc. Thank you in advance for the help!!
    Attached Files Attached Files
    Last edited by superdrno; 11-06-2014 at 06:15 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Analysis Question
    By EnigmaMatter in forum Excel General
    Replies: 6
    Last Post: 07-17-2014, 04:32 PM
  2. @RISK-question: RiskTriang(), do new simulation if X < 1,2%
    By Jooakim in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2014, 04:31 PM
  3. @Risk for Excel question
    By minhiub in forum Excel General
    Replies: 0
    Last Post: 03-05-2009, 03:14 AM
  4. Analysis Toolpak Question
    By mphell0 in forum Excel General
    Replies: 2
    Last Post: 02-13-2006, 09:49 AM
  5. [SOLVED] Data Analysis Question
    By BRUZER in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1