ABCDEFGHIJKLMNOPQRSTUVWXY
1
See column F for 10,000 randomly generated numbers from uniform [0,1] distribution
0.761
2
SEED 1234"For portability, I precondition the seed by applying the same modulus treatment that each RN has:
Zin = MOD(ROUND(MOD(IRUN*EXP(1),1)*M*A,0),M)/M"		0.142
3
M2147483647M = 2^31-10.413
4
A16807A = 7^50.124
5
0.943
6
Zin0.7605843846Zin uses the seed for the intial randomly generated value0.390
7
Zout0.142"Zout = MOD(ROUND(M*A*Zin,0),M)/M"0.926
8
Each subsequent Zin uses the previously generated random value as seed0.377
9
0.820
10
F1 to F10000
pseudo random generator statistics
0.770
11
average0.5003mean of uniform should be (max-min)/20.50000.560
12
stdev0.2888stdev of uniform should be (max-min)/sqrt(12)0.28870.741
13
N100000.238
14
Standard Error0.002887990979"=B12/sqrt(B13)"0.100
15
Z-score0.102075475"=(B11-E11)/(B14)"0.407
16
0.135
17
0.864
18
Based on paper: https://research.ssl.berkeley.edu/~mlampton/RandomSpreadsheet4.pdf
0.654
19
0.927
20
0.279
21
0.206
22
0.925
23
0.168
24
0.777
25
0.442
26
0.053
27
0.659
28
0.157
29
0.988
30
0.165
31
0.140
32
0.563
33
0.977
34
0.153
35
0.810
36
0.184
37
0.683
38
0.784
39
0.330
40
0.631
41
0.019
42
0.921
43
0.372
44
0.888
45
0.996
46
0.927
47
0.805
48
0.236
49
0.927
50
0.525
51
0.554
52
0.195
53
0.759
54
0.599
55
0.506
56
0.522
57
0.657
58
0.285
59
0.354
60
0.217
61
0.863
62
0.799
63
0.335
64
0.082
65
0.633
66
0.475
67
0.423
68
0.241
69
0.896
70
0.977
71
0.945
72
0.993
73
0.161
74
0.145
75
0.818
76
0.219
77
0.845
78
0.582
79
0.570
80
0.106
81
0.473
82
0.920
83
0.505
84
0.311
85
0.064
86
0.111
87
0.666
88
0.378
89
0.383
90
0.702
91
0.760
92
0.257
93
0.986
94
0.590
95
0.376
96
0.223
97
0.032
98
0.511
99
0.182
100
0.282