random number generator
Normal
m 0
s 150
Uniform x
0.154291 -152.730 =NORMINV(B9,$B$5,$B$6)
=RAND()
random number generator
LogNormal
m 8.2
s 0.6
Uniform x
0.001016 571.732 =LOGINV(B9,$B$5,$B$6)
random number generator
Exponential
l 0.0005
Uniform x
0.263239 610.984 =-LN(1-B9)/B5
random number generator
Gamma
a 25
b 50
Uniform x
0.925004 1625.765 =GAMMAINV(B9,$B$5,$B$6)
random number generator
Pareto
K 300
a 5
Uniform x
0.702554 382.331 =$B$5/((1-B9)^(1/$B$6))
random number generator
Poisson
l 0.5 F(x)
0
0.6065307
y x 0.9097960
0.439485 0 =VLOOKUP(B9,$F$6:$G$27,2,TRUE) 0.9856123
0.9982484
0.9998279
0.9999858
0.9999990
0.9999999
1.0000000
1.0000000
1.0000000
1.0000000
1.0000000
1.0000000
1.0000000
1.0000000
1.0000000
1.0000000
1.0000000
1.0000000
1.0000000
x
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
random number generator
Bernoulli
1
p 0.3 F(x)
0
0.7000000
y x 1.0000000
0.067987 0 =VLOOKUP(B9,$F$6:$G$8,2,TRUE)
x
0
1