Monte Carlo simulation

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.
.

Relevant Pages

  • 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: Random Number Generator Problem
    ... I think there's another article explaining that Excel 2004 has further ... refinements to the random number generator. ... Jim Gordon MVP wrote: ... >>Note, however, that for serious statistical work, the ATP RNG is pretty ...
    (microsoft.public.mac.office.excel)
  • Re: Random Number Generation Dialog Box
    ... >> Am using Excel 2001 and want to generate some random numbers from a normal ... >> distribution. ... A help search tells me about what looks like a wonder dialog ... > Be aware, however, that the ATP's pseudorandom number generator is not ...
    (microsoft.public.mac.office.excel)
  • Bad random number generator : Microsoft Excel (office XP)
    ... Actually it does not look really a good random number generator ... The precision is suppossedly of 15 digits but according to the ... I suspected that Excel and Microsoft are not so advanced ...
    (sci.math)
  • Re: Bad random number generator : Microsoft Excel (office XP)
    ... >random number generator of Excel. ... >It has some limitations of course since a column can hardly ... >- The precision is suppossedly of 15 digits but according to the ...
    (sci.math)