CLT and Excel Rand
CLT and Excel Rand
CLT and Excel Rand
The Central Limit Theorem (CLT) predicts: first, the mean of sample means will approa
second, the standard deviation of sample means will approach the standard deviation
Note: to generate a draw from uniform [a,b,) use "= ((b-a)*Rand()) + a"
1 0.0277890117
2 0.8936419042
3 0.2081190692
4 0.6924147046
5 -0.491868128
6 0.8017798842
7 0.2918195606
8 -0.956979543
9 -0.501611841
10 -0.468345013
11 -0.468345013
12 -0.120400255
13 0.8023779888
14 -0.98771243
15 0.3227930781
16 -0.327759447
17 0.4311231692
18 -0.081957034
19 0.1924070008
20 0.1628793978
21 -0.297689568
22 -0.740819661
23 -0.835049254
24 0.5423691593
25 0.0742072073
26 -0.181732889
27 0.1351855783
28 0.0755619188
29 0.3250252527
30 -0.808108993
31 0.3395720131
32 0.4005032558
33 -0.433297208
34 0.8187017787
35 -0.704009672
36 0.9788269625
37 -0.282018243
38 0.467580717
39 0.9462977476
40 0.9363977925
41 0.5183840793
42 -0.56872363
43 -0.59904017
44 -0.936593444
45 0.4128262643
46 0.7585058681
47 -0.32001974
48 -0.811791652
49 -0.193607702
50 -0.913781088
51 -0.019010385
52 -0.329340574
53 0.5030961885
54 -0.027426646
55 0.074326995
56 -0.655525413
57 0.5789588836
58 0.4113871479
59 0.070513121
60 0.4585686125
61 -0.831894523
62 0.7628806507
63 -0.594083529
64 -0.641866418
65 0.3446299551
66 0.9022240182
67 0.6799196133
68 -0.575480816
69 0.8365640166
70 -0.083769895
71 -0.427868653
72 -0.361714567
73 0.9739822575
74 0.021536571
75 0.3743712087
76 0.1246539984
77 -0.412364885
78 0.414140105
79 -0.921925536
80 -0.277369406
81 -0.67086277
82 0.0271941408
83 0.7685872579
84 -0.980315239
85 -0.26304824
86 0.1383764479
87 -0.855435471
88 -0.843481754
89 -0.315063766
90 0.5206668133
91 0.9950823856
92 0.017461417
93 0.2089727106
94 0.1146714221
95 -0.318462198
96 -0.435282422
97 -0.613988478
98 -0.991558235
99 -0.340975013
100 -0.756525044
-1 and b = 1
100
7.0%
Excel/Preferences/Calculation and change "Automatically" to "Manually"
-0.007
5
-0.082
-0.082
0.070
0.012
-0.556412381143155
0.154097237336109
-0.494544461868539
0.312628712076957
0.340488611500626
0.656274235670357
-0.59330315658465
-0.463663272760721
0.86273640720475
0.142806730322473
0.763872931301002
0.558652193167733
-0.898866780803535
0.724593998611143
-0.086011866522406
-0.857202491174829
-0.394161947090739
-0.926674190398383
0.70674436611742
0.927740268020168
0.636063837295152
0.746801951170155
0.764180334636461
-0.460903568268502
-0.233803081632231
0.716954018101211
0.932010044015323
0.930801606174544
-0.76404694876612
0.829583880705558
0.223530421650718
-0.674695531201565
0.510956293849601
-0.216399844379274
-0.143248786307472
0.826288513109648
0.857754712698986
0.342237911523925
0.645536965900818
-0.997713748393581
-0.590608315031523
0.32922439379362
-0.941289870977344
0.500535294944684
0.022958572458332
0.344028966628816
-0.975973588446654
0.230412580015976
-0.347548460777982
0.114174857221743
0.835837340623101
-0.991693263715319
-0.953946898942144
0.413302342199034
-0.863998397622578
0.899690890088079
-0.991840844923143
0.857643797268029
-0.71008292775948
-0.644243209611943
0.134346385186132
-0.695431743029406
0.591042289204833
-0.671621896582296
0.166488805996441
0.815870208622264
0.610773215129851
-0.620054238624743
-0.514097033326552
0.427616344715598
-0.830167052755136
-0.796996203699335
0.561375437665774
0.668769155908355
-0.957494755358481
-0.765172958954015
-0.330607950336269
-0.364471489469186
-0.421798877602888
-0.909252338281632
0.2177992771152
-0.510650721779502
-0.332976431190518
0.812517330718099
-0.245571339610601
-0.126034361473296
-0.180080665463956
0.98994337799843
-0.090745145321166
-0.807827588225763
0.180957569410365
-0.095227700771388
0.018449378677732
0.166163191288138
-0.000892328082523
0.062839143852267
0.119600148999684
-0.676419882249161
0.51659887200811
0.322574923184673
Formula - Uniform distribution has mean = (a+b)/2 = 0
0.0577
0.000 -0.059
6 7
-0.069 -0.067
-0.069 -0.067
0.071 0.065
0.013 0.008
0.117487437492602 -0.435754459006
0.133178315829737 0.472574608104
-0.677257988292366 0.444472350689
-0.283120154427512 -0.860712161141
-0.289422137474705 0.414369794674
-0.625867461981073 0.525275687512
-0.258647341761179 -0.472763365547
-0.286416269517934 -0.518402865454
0.242055508378407 0.906717588321
-0.828532004775463 0.772122881742
-0.345231782385598 -0.786876089489
-0.479906500808088 0.101385353799
0.451707606213517 -0.622648519601
0.807091064548725 -0.053550064445
-0.007011410032441 0.282929233814
-0.857610597576073 0.789955433646
0.218694324421205 0.337626193001
-0.038933712422875 0.0061176122
-0.152474235533527 0.613678158887
0.064824301703841 0.824963001347
0.064824301703841 -0.181950323509
-0.33891729604922 -0.689426357058
-0.992659789012132 -0.707070936307
0.293203291231922 -0.006888280925
-0.349316850803978 0.826641140175
0.995283193725976 -0.700084524453
-0.200121377881906 -0.505310670294
-0.415147414447352 -0.099501419005
0.583911766973461 -0.87827051189
0.160030225163333 -0.749656290892
-0.442969903830312 0.623398394403
-0.908652596390131 0.46541911313
0.118407442463117 -0.893258180639
-0.575264714875333 -0.372394666526
-0.335480586761394 -0.208641551327
0.768443506512378 -0.961396827085
-0.285062236928024 0.870167932955
0.080690584727959 -0.020709156291
-0.17753886986109 0.754848151193
-0.458392611714913 0.82130723018
0.147620392256452 -0.901631013231
-0.038644886168788 -0.426912667443
-0.2874921902418 0.392593623939
-0.357839918601918 -0.704062045209
-0.791190891621768 0.587147768498
-0.580977339430939 0.351338517091
-0.505426725897552 -0.823965381232
0.502512346452803 0.847107774421
0.325203470658934 -0.071246797711
-0.234055575220097 -0.518575754608
0.651352969339676 0.717803198555
0.796705181817037 0.027041483015
0.337161759509027 -0.026210630317
0.928721691554159 -0.427980431732
-0.041924368736637 0.158334522208
-0.570709540724422 0.590180190342
0.755381503287608 -0.725921621676
0.246092093145815 0.469012306517
0.866236881972504 0.795718496008
-0.362122528478717 0.514017705162
-0.070659805450433 -0.159096803769
0.532212735573357 -0.573563121725
-0.392810476779498 -0.45343549462
-0.239589526342739 -0.886232471737
0.531108085902449 -0.063566465937
0.916528699222021 -0.271356823351
-0.934336398136978 -0.816141045467
0.769209623385558 0.407371402761
0.126480146948923 -0.647495155896
0.572013259936726 -0.762608595272
0.502918442793253 -0.690353107057
-0.253188544981435 -0.667775535926
-0.724707084171487 -0.249864079021
0.436388132413629 -0.512209283239
-0.859809492464955 -0.137935369559
0.897127627800506 0.762670518558
0.905218577311642 0.267923793679
0.363212106026597 -0.886381747211
0.746247025047035 -0.91510617527
-0.384115190001007 -0.04464287093
-0.497839578130959 -0.170317144231
0.170694829684005 -0.635977093027
-0.706765924449087 0.218439856725
0.613024341015203 -0.017136618563
-0.721333785650638 -0.121801040126
-0.519117218609449 -0.345558338773
0.853422385013566 0.41623452301
0.44357383100667 -0.567616875979
-0.2377325454152 -0.208187980935
-0.681076298311541 0.360173510529
-0.999001841614979 -0.168120375537
0.829507607103928 -0.741902265185
0.374118117600627 0.570370273526
0.711065717759362 0.283171211051
0.720513515593495 -0.646491564905
0.328599322748477 0.554399145557
0.198626734425926 0.778012289273
-0.375176374689378 -0.117872675081
0.111771616698456 0.023532408913
-0.351940026881304 0.937910688361
Formula - Variance of a continuous uniform distribution = (b-a)^2 / 12 =
Standard deviation of a uniform distribution = sqrt((b-a)^2)/12) =