Home |
Search |
Today's Posts |
#1
|
|||
|
|||
monte carlo simulation
Hello,
I have some real data of inflation per month for the UK. How can I simulate this, using random numbers that were generated using normal distribution. regards |
#2
|
|||
|
|||
monte carlo simulation
Do a google search. There are tons of hits on the topic.
-- HTH RP (remove nothere from the email address if mailing direct) "unique" wrote in message ... Hello, I have some real data of inflation per month for the UK. How can I simulate this, using random numbers that were generated using normal distribution. regards |
#3
|
|||
|
|||
monte carlo simulation
If X and Y are randomly distributed,
Z = (-2 ln(X) )^(1/2) cos(2 pi Y) is normally randomly distributed with mean 0 and variance 1. The Excel equivalent is =SQRT(-2*LN(RAND()))*COS(2*PI()*RAND()) "unique" wrote in message ... Hello, I have some real data of inflation per month for the UK. How can I simulate this, using random numbers that were generated using normal distribution. regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Monte Carlo Simulation | Excel Discussion (Misc queries) | |||
can excel do Monte Carlo simulation? | Excel Discussion (Misc queries) | |||
How can i set up a MONTE CARLO SIMULATION macro in Excel? thx | Excel Worksheet Functions | |||
How can i made a monte Carlo simulation with Excel ? | Excel Discussion (Misc queries) | |||
How do I perform a Monte Carlo simulation in Excel? | Excel Discussion (Misc queries) |