Re: Monte Carlo simulation

On 21 June, 20:13, Hubert <hubert.ruyp...@xxxxxxxxx> wrote:
I want to use Excel to perform a Monte Carlo simulation. Therefore I
use the RAND()-function, the random number generator of Excel. This
gives me random numbers between 0 and 1. This number is multiplied
with the difference between the highest and lowest value for a
variable.

However I want to simulate a variables that variate according to a
Weibull-distribution between that min and max value. Other variables
follow a normal distribution.

Can some-one help me out how to perform that in Excel ?

Thanks in advance.

For the normal distribution you can use

=NORMINV(RAND(),0,1)

and if necessary replace 0 by the mean and 1 by the standard deviation
.

Relevant Pages

  • Re: Normal Random Variable Generator
    ... Excel, PowerPoint, and VBA add-ins, tutorials ... > random variables in Excel: ... > differ from a normal distribution. ... but I don't know how to use in my VBA code. ...
    (microsoft.public.excel.programming)
  • Re: Random Number Generator Problem
    ... The random number feature in Excel 2004 works differently from all other ... >> Number Generator, then select Normal Distribution, Mean 0, Standard ... the generator will use a different seed every time (probably ... > Note, however, that for serious statistical work, the ATP RNG is pretty ...
    (microsoft.public.mac.office.excel)
  • Re: How do I graph normal probability distributions in excel?
    ... If you want to know how to plot a normal distribution curve for a known ... > To anyone that will listen...I need serious help with excel and graphing. ... > am taking statistics, and our instructor wants us to graph normal probability ... > excel tutorials. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Average or "Harmonic Mean" calculation
    ... Have a look at the reply from David Lloyd to a post "Normal Distribution" in ... this newsgroup; it gives details on how to set up ... an Access function to use an Excel function. ... run the HARMEAN() function against the list of values ...
    (microsoft.public.access.queries)
  • Re: Normal Random Variable Generator
    ... You can create quasi ... differ from a normal distribution. ... >> variable generator in my VBA code in Excel? ... but I don't know how to use in my VBA code. ...
    (microsoft.public.excel.programming)