Monte Carlo Simulation and Risk Analysis Flashcards

1
Q

What is risk analysis?

A

The process of quantifying the likelihood of undesirable and desirable outcomes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a deterministic investment model?

A

This model does not change as it does not involve randomness and allows you to calculate future events exactly.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a stochastic investment model?

A

This model forecasts the probability of various outcomes under different conditions using random variables. It predicts outcomes that account for certain levels of unpredictability/randomness.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Does the stochastic model give the same results?

A

No, every recalculation of the model gives a slightly different result.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Where are simulation models used?

A

1) Finance- investment planning
2) Marketing- product development
3) Management- project management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the Monte Carlo simulation?

A

This is a stats technique in which a quantity is calculated repeatedly using randomly selected what-if scenarios for each calculation. The simulation results in a full range of possible outcomes and the likelihood of each.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the Monte Carlo simulation useful for?

A

It is often used to assess the impact of uncertainty on a decision. This can include the prob of incurring a financial loss, prob.of running out of inventory etc.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Steps for the Monte Carlo simulation

A

1) Construct a spreadsheet simulation model to express the relationship between the inputs and outputs using appropriate formulas.
2) Represent the uncertain/variable inputs using probability distributions.
3) An iteration/trial is run which generates a random variable and inputs the variable to produce values of interest.
4) Repeat step 3 thousands of times.
5) This produces a distribution for the output variables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the two main ways to represent step 2?

A

1)You can use real-life historical data to construct an empirical distribution (frequency histogram).
2) Use of a known statistical distribution such as binomial or normal that fits the real-life data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is top-hat sampling?

A

This is often used for empirical discrete or continuous distributions. It uses random numbers to sample values from the distribution so that the proportion of values in the sample matches the probabilities of each value occurring in the distribution,

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What does [ show?

A

This means that it includes the number following.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What does ( show?

A

This means that it does not include the number that follows.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Steps for top-hat sampling

A

1) Calculate the cumulative frequency.
2) Then using the calculated cumulative frequency and (), [] we create the interval of random numbers.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the inverse transformation method?

A

This method works for the probability distributions where you can find the inverse of their cumulative distribution function.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Steps for inverse transformation method

A

1) Put u equal to the CDF to make the equation u= F(x).
2) Rearrange the equation to make x the subject x= G(u)
3) Let u take the value of the random number in the interval [0,1)
4) Sub u into G(u) which gives us the randomly generated value from our chosen probability distribution.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the Excel function for a random number and how to generate more random numbers?

A

=rand()
F9 to generate again.

17
Q

How to find the sampled data for the tophat method in Excel?

A

=vlookup( rand(), the table with the data, column for cost e.g. 1 or 2, TRUE)

18
Q

What is the Excel formula for the uniform distribution?

A

= cell for lower bound+ (rand()* (upper bound-lower bound))

19
Q

What is the Excel formula for the exponential distribution?

A

= -ln(rand())/ cell for mean value

20
Q

What is the Excel formula for normal distribution?

A

=MAX( ROUND(NORM.INV(RAND(), mean, standard deviation),0),0)

21
Q
A