Mean 0.

01
Std dev 0.09

Log Return
(Continuous
Comp)

Date INFY (ADJ) INFY =1/($C$3*SQRT(2*PI())) =EXP(-(0.5*((C10-$C$2)/$C$3)^2))

6/30/2005 294.78
7/29/2005 283.56 -3.88% 4.669 0.8492
8/31/2005 297.01 4.63% 4.669 0.9137
9/30/2005 314.41 5.69% 4.669 0.8603
10/31/2005 315.24 0.26% 4.669 0.9962
11/30/2005 335.56 6.25% 4.669 0.8285
12/30/2005 374.61 11.01% 4.669 0.5039
1/31/2006 360.04 -3.97% 4.669 0.8443
2/28/2006 353.62 -1.80% 4.669 0.9476
3/31/2006 372.68 5.25% 4.669 0.8839
4/29/2006 397.17 6.36% 4.669 0.8214
5/31/2006 363.73 -8.80% 4.669 0.5180
6/30/2006 384.87 5.65% 4.669 0.8627
7/31/2006 413.89 7.27% 4.669 0.7643
8/31/2006 451.6 8.72% 4.669 0.6653
9/29/2006 462.41 2.37% 4.669 0.9874
10/31/2006 523.88 12.48% 4.669 0.4058
11/30/2006 544.92 3.94% 4.669 0.9428
12/29/2006 560.45 2.81% 4.669 0.9779
1/31/2007 561.83 0.25% 4.669 0.9961
2/28/2007 519.39 -7.85% 4.669 0.5842
3/30/2007 504.66 -2.88% 4.669 0.9020
4/30/2007 512.71 1.58% 4.669 0.9977
5/31/2007 480.88 -6.41% 4.669 0.6863
6/29/2007 482.26 0.29% 4.669 0.9965
7/31/2007 493.95 2.40% 4.669 0.9869
8/31/2007 463.64 -6.33% 4.669 0.6916
9/28/2007 473.19 2.04% 4.669 0.9927
10/31/2007 459.36 -2.97% 4.669 0.8976
11/30/2007 400.63 -13.68% 4.669 0.2284
12/31/2007 442.48 9.94% 4.669 0.5791
1/31/2008 374.76 -16.61% 4.669 0.1194
2/29/2008 387.05 3.23% 4.669 0.9668
3/31/2008 359.98 -7.25% 4.669 0.6271
4/30/2008 438.27 19.68% 4.669 0.0918
5/30/2008 490.7 11.30% 4.669 0.4839
6/30/2008 434.2 -12.23% 4.669 0.3012
7/31/2008 395.86 -9.24% 4.669 0.4871
8/29/2008 437.27 9.95% 4.669 0.5782
9/30/2008 349.51 -22.40% 4.669 0.0235
10/31/2008 347.24 -0.65% 4.669 0.9814
11/28/2008 310.96 -11.04% 4.669 0.3706
12/31/2008 278.86 -10.90% 4.669 0.3792
1/30/2009 326.66 15.82% 4.669 0.2224
2/27/2009 307.81 -5.94% 4.669 0.7185
3/31/2009 330.98 7.26% 4.669 0.7651
4/29/2009 377.31 13.10% 4.669 0.3672
5/29/2009 401.27 6.16% 4.669 0.8338
6/30/2009 444.13 10.15% 4.669 0.5641
7/31/2009 516.09 15.02% 4.669 0.2607
8/31/2009 532.79 3.18% 4.669 0.9680
9/30/2009 576.6 7.90% 4.669 0.7220
10/30/2009 551.55 -4.44% 4.669 0.8162
11/30/2009 594.84 7.56% 4.669 0.7453
12/31/2009 650.27 8.91% 4.669 0.6519
1/29/2010 618.88 -4.95% 4.669 0.7846
2/26/2010 650.49 4.98% 4.669 0.8974
3/31/2010 653.99 0.54% 4.669 0.9985
4/30/2010 684.54 4.57% 4.669 0.9168
5/31/2010 664.5 -2.97% 4.669 0.8974
6/30/2010 697.75 4.88% 4.669 0.9021
7/30/2010 697.1 -0.09% 4.669 0.9918
8/31/2010 678.46 -2.71% 4.669 0.9098
9/30/2010 762.63 11.69% 4.669 0.4572
10/29/2010 742.92 -2.62% 4.669 0.9140
11/30/2010 762.75 2.63% 4.669 0.9820
12/31/2010 860.69 12.08% 4.669 0.4317
1/31/2011 779.42 -9.92% 4.669 0.4417
2/28/2011 749.27 -3.95% 4.669 0.8455
3/31/2011 810.33 7.83% 4.669 0.7266
4/29/2011 726.56 -10.91% 4.669 0.3781
5/31/2011 696.41 -4.24% 4.669 0.8284
6/30/2011 727.61 4.38% 4.669 0.9248
7/29/2011 693.98 -4.73% 4.669 0.7982
8/30/2011 585.74 -16.96% 4.669 0.1098
9/30/2011 633.26 7.80% 4.669 0.7289
10/31/2011 719.39 12.75% 4.669 0.3887
11/30/2011 651.71 -9.88% 4.669 0.4442
12/30/2011 691.91 5.99% 4.669 0.8438
1/31/2012 686.5 -0.78% 4.669 0.9783
2/29/2012 720.86 4.88% 4.669 0.9021
3/30/2012 716.58 -0.60% 4.669 0.9826
4/30/2012 615.52 -15.20% 4.669 0.1655
5/31/2012 607.34 -1.34% 4.669 0.9631
6/29/2012 627.3 3.23% 4.669 0.9666
7/31/2012 556.74 -11.93% 4.669 0.3178
8/31/2012 590.41 5.87% 4.669 0.8503
9/28/2012 633.74 7.08% 4.669 0.7765
10/31/2012 590.75 -7.02% 4.669 0.6431
11/30/2012 609.21 3.08% 4.669 0.9710
12/31/2012 579.67 -4.97% 4.669 0.7831
 1/31/2013 697.38 18.49% 4.669 0.1233
2/28/2013 726.75 4.13% 4.669 0.9355
3/28/2013 722.34 -0.61% 4.669 0.9823
4/30/2013 558.86 -25.66% 4.669 0.0077
5/31/2013 602.92 7.59% 4.669 0.7432
6/28/2013 624.71 3.55% 4.669 0.9566
7/31/2013 742.41 17.26% 4.669 0.1637
8/30/2013 776.46 4.48% 4.669 0.9204
9/30/2013 753.25 -3.03% 4.669 0.8943
10/31/2013 827.48 9.40% 4.669 0.6172
11/29/2013 838.64 1.34% 4.669 0.9992
12/31/2013 871.41 3.83% 4.669 0.9467
1/31/2014 925.27 6.00% 4.669 0.8431
2/28/2014 956.21 3.29% 4.669 0.9649
3/31/2014 820.7 -15.28% 4.669 0.1626
4/30/2014 795.2 -3.16% 4.669 0.8882
5/30/2014 734.85 -7.89% 4.669 0.5815
6/30/2014 813.89 10.22% 4.669 0.5593
7/31/2014 841.91 3.38% 4.669 0.9620
8/28/2014 899.7 6.64% 4.669 0.8046
9/30/2014 936.94 4.06% 4.669 0.9382
10/31/2014 1012.81 7.79% 4.669 0.7298
11/28/2014 1089.96 7.34% 4.669 0.7596
12/31/2014 986.27 -10.00% 4.669 0.4366
1/30/2015 1070.95 8.24% 4.669 0.6989
2/28/2015 1148.22 6.97% 4.669 0.7840
3/31/2015 1109.18 -3.46% 4.669 0.8724
4/30/2015 971.13 -13.29% 4.669 0.2467
5/29/2015 1011.58 4.08% 4.669 0.9373
6/30/2015 984.35 -2.73% 4.669 0.9090
 f(x)

PDF(Probability Density Function) CDF(Cumulative Distribution Function)

=[Link](C10,$C$2,$C$3,FALSE) =[Link](C10,$C$2,$C$3,TRUE)

3.96485691089949 3.96485691089949 0.283750939154364

4.26611235308371 4.26611235308371 0.664491118843746
4.0163815611088 4.0163815611088 0.708389751738079
4.65130678953854 4.65130678953854 0.465440032498594
3.86803000803522 3.86803000803522 0.730212809006052
2.35278733182945 2.35278733182945 0.879147167806579
3.94177971454921 3.94177971454921 0.280332192852995
4.42410043988734 4.42410043988733 0.371397121176902
4.12683913163272 4.12683913163272 0.690330003453507
3.83509818984874 3.83509818984874 0.734748969414165
2.41866566789972 2.41866566789972 0.125710737153718
4.02764785331059 4.02764785331059 0.70662698998324
3.56851894270553 3.56851894270553 0.768268526643495
3.10594954566415 3.10594954566415 0.816703528589537
4.6100116592826 4.6100116592826 0.563262191043241
1.89456127399198 1.89456127399198 0.910375841313401
4.40176674139264 4.40176674139264 0.634287839598497
4.56578798847278 4.56578798847277 0.583664100423584
4.65046066607798 4.65046066607798 0.464616331598513
2.72763513816597 2.72763513816597 0.149915029125435
4.21108630165571 4.21108630165571 0.324810394550583
4.65817649402512 4.65817649402512 0.526953724668807
3.20427065912429 3.20427065912429 0.192787568984128
4.65237254224149 4.65237254224149 0.466506430870305
4.60744340873943 4.60744340873943 0.564625447708497
3.22918493708772 3.22918493708772 0.195253889815496
4.63477346743198 4.63477346743198 0.548161338307874
4.19091936168088 4.19091936168088 0.321060250305668
1.06636540615544 1.06636540615544 0.0428509910582017
2.70391878589198 2.70391878589198 0.852031694412762
0.557585809426085 0.557585809426085 0.0196240376837215
4.51361660137172 4.51361660137172 0.602584694619695
2.92768276645733 2.92768276645733 0.166990840080531
0.428656263481981 0.428656263481981 0.985570624578603
2.25941763787182 2.25941763787182 0.88586475576873
1.40621880779798 1.40621880779798 0.0606671976012876
2.27399988207705 2.27399988207704 0.115171741212748
2.69951092005704 2.69951092005704 0.852391785156561
0.109596903393949 0.109596903393949 0.00307859760308086
 4.58193477006367 4.58193477006366 0.423147355752996
1.73014932282822 1.73014932282822 0.0794111101943919
1.77024589346073 1.77024589346073 0.081856913735692
1.03834167603626 1.03834167603626 0.958536201031001
3.35440218471586 3.35440218471586 0.208055495747948
3.57217262271069 3.57217262271069 0.767842291507387
1.71416894348587 1.71416894348587 0.921555728870011
3.89286409947199 3.89286409947199 0.726723732167237
2.63369999274009 2.63369999274009 0.857705114380547
1.2170958027427 1.2170958027427 0.949474741550388
4.51936030730983 4.51936030730983 0.600679269601679
3.37071342183471 3.37071342183471 0.790224216725277
3.81054617535981 3.81054617535981 0.261933182611208
3.47989916328735 3.47989916328735 0.778367006027664
3.04350944833867 3.04350944833867 0.822541265541383
3.66297032354268 3.66297032354268 0.243022194323218
4.18964496575497 4.18964496575496 0.679173899596695
4.66183373663952 4.66183373663952 0.478152376013836
4.28056867439684 4.28056867439684 0.661555114632438
4.18979237448598 4.18979237448598 0.320853167572586
4.21198117907129 4.21198117907129 0.675021199895187
4.63044962171423 4.63044962171423 0.448877205140781
4.247760245956 4.247760245956 0.331860017283226
2.13474640929991 2.13474640929991 0.894541737002531
4.26741730410895 4.26741730410895 0.33577162296056
4.58471831106714 4.58471831106714 0.575615585437241
2.01549421590992 2.01549421590992 0.902543817350878
2.06229876637713 2.06229876637713 0.100563120509233
3.94766798846801 3.94766798846801 0.281198826383572
3.39230488733863 3.39230488733863 0.787927281702602
1.76545712583697 1.76545712583697 0.0815633055449703
3.86770103352207 3.86770103352207 0.269741373573187
4.31791924732621 4.31791924732621 0.653694143655525
3.72668412337531 3.72668412337531 0.25098188831397
0.512538053774259 0.512538053774259 0.0177747993996554
3.40299154702475 3.40299154702475 0.786781941730365
1.81458870543945 1.81458870543945 0.915404800810376
2.07404781108476 2.07404781108476 0.101349825531985
3.93936272631318 3.93936272631318 0.720022431340413
4.56753627647841 4.5675362764784 0.417046030629518
4.21169649914918 4.21169649914918 0.675074792184084
4.5876704082416 4.5876704082416 0.42571916968343
0.772706713583473 0.772706713583473 0.0289327209387364
4.49662621493346 4.49662621493346 0.391979880150727
4.51268028753206 4.51268028753206 0.602891888830896
1.4839376430006 1.4839376430006 0.0650034728089206
3.96969442581998 3.96969442581998 0.715524721973157
3.62546128612166 3.62546128612166 0.761531025623869
3.00239237684069 3.00239237684069 0.173690525690256
4.53354302805839 4.53354302805839 0.59580846832639
3.65616125630027 3.65616125630027 0.242188576733732
 0.575751199063437 0.575751199063437 0.979620169428416
4.36767349381073 4.36767349381073 0.642512719491034
4.58634241834179 4.58634241834179 0.425115755759539
0.0358639631331538 0.0358639631331538 0.000902552471719488
3.46972367384111 3.46972367384111 0.779498259161774
4.4661965211221 4.4661965211221 0.617110969622064
0.76423678249049 0.76423678249049 0.971448271572297
4.29734970102603 4.29734970102603 0.658074421692062
4.17519672000058 4.17519672000057 0.318194143921536
2.88176579678705 2.88176579678705 0.83703650742958
4.66525273836927 4.66525273836927 0.515630342062797
4.41995684195212 4.41995684195212 0.629677171363289
3.93622185428541 3.93622185428541 0.72048230944074
4.50493452736746 4.50493452736746 0.605398065011628
0.759115881872084 0.759115881872084 0.0283219461055234
4.14678083047321 4.14678083047321 0.313134194161861
2.71496168106026 2.71496168106026 0.148872794783535
2.6114156404716 2.6114156404716 0.859478040858939
4.49119995506615 4.49119995506615 0.609697948631478
3.75668456508697 3.75668456508697 0.745165405717741
4.38050657681183 4.38050657681183 0.63947615942973
3.40743666618641 3.40743666618641 0.78630386231819
3.54648559556173 3.54648559556173 0.770821856875874
2.0382333660073 2.0382333660073 0.0989602569563593
3.26321040170558 3.26321040170558 0.801335820424825
3.66014199174198 3.66014199174198 0.757324458190686
4.0732761648117 4.0732761648117 0.300688327340064
1.15172247831741 1.15172247831741 0.0471526596970656
4.37590428140129 4.37590428140129 0.640573033678005
4.24377813883082 4.24377813883082 0.331079345145514
 PDF CDF
Density Value
+1 SD 0.10 2.8318 0.841345
-1 SD -0.08 2.8318 0.158655
+2 SD 0.18 0.6319 0.97725
-2 SD -0.16 0.6319 0.02275
+3 SD 0.27 0.0519 0.99865
-3 SD -0.25 0.0519 0.00135
Returns PDF CDF
-0.038806 3.964857 0.283751
0.046342 4.266112 0.664491 PDF
0.056932 4.016382 0.70839 5
0.002636 4.651307 0.46544 4.5
0.062467 3.86803 0.730213 4
0.110085 2.352787 0.879147
3.5
-0.03967 3.94178 0.280332
3
-0.017992 4.4241 0.371397
2.5
0.052497 4.126839 0.69033
0.063644 3.835098 0.734749 2

-0.087953 2.418666 0.125711 1.5

0.056494 4.027648 0.706627 1
0.072695 3.568519 0.768269 0.5
0.087197 3.10595 0.816704 0
-0.3 -0.2 -0.1 0 0.1 0.2
0.023655 4.610012 0.563262
0.124811 1.894561 0.910376
0.039376 4.401767 0.634288
0.028101 4.565788 0.583664 CDF
0.002459 4.650461 0.464616 1.2
-0.078544 2.727635 0.149915
-0.02877 4.211086 0.32481 1
0.015825 4.658176 0.526954
-0.064093 3.204271 0.192788 0.8
0.002866 4.652373 0.466506
0.023951 4.607443 0.564625 0.6
-0.063326 3.229185 0.195254
0.4
0.020389 4.634773 0.548161
-0.029663 4.190919 0.32106
0.2
-0.136796 1.066365 0.042851
0.099357 2.703919 0.852032 0
-0.166109 0.557586 0.019624 -0.3 -0.2 -0.1 0 0.1 0.2
0.032268 4.513617 0.602585
-0.072505 2.927683 0.166991
0.196787 0.428656 0.985571
0.112998 2.259418 0.885865
-0.122328 1.406219 0.060667
-0.092445 2.274 0.115172
0.09949 2.699511 0.852392
-0.224019 0.109597 0.003079
-0.006516 4.581935 0.423147
-0.110352 1.730149 0.079411
-0.108954 1.770246 0.081857
0.15821 1.038342 0.958536
-0.059437 3.354402 0.208055
0.072575 3.572173 0.767842
0.131009 1.714169 0.921556
0.061567 3.892864 0.726724
 0.101483 2.6337 0.857705
0.150164 1.217096 0.949475
0.031846 4.51936 0.600679
0.079021 3.370713 0.790224
-0.044416 3.810546 0.261933
0.07556 3.479899 0.778367
0.089095 3.043509 0.822541
-0.049476 3.66297 0.243022
0.049815 4.189645 0.679174
0.005366 4.661834 0.478152
0.045655 4.280569 0.661555
-0.029712 4.189792 0.320853
0.048826 4.211981 0.675021
-0.000932 4.63045 0.448877
-0.027103 4.24776 0.33186
0.116947 2.134746 0.894542
-0.026185 4.267417 0.335772
0.026342 4.584718 0.575616
0.120804 2.015494 0.902544
-0.099184 2.062299 0.100563
-0.039451 3.947668 0.281199
0.078342 3.392305 0.787927
-0.109121 1.765457 0.081563
-0.042382 3.867701 0.269741
0.043827 4.317919 0.653694
-0.047322 3.726684 0.250982
-0.169567 0.512538 0.017775
0.078005 3.402992 0.786782
0.127523 1.814589 0.915405
-0.098804 2.074048 0.10135
0.059856 3.939363 0.720022
-0.00785 4.567536 0.417046
0.048839 4.211696 0.675075
-0.005955 4.58767 0.425719
-0.152022 0.772707 0.028933
-0.013379 4.496626 0.39198
0.032336 4.51268 0.602892
-0.119327 1.483938 0.065003
0.058719 3.969694 0.715525
0.070822 3.625461 0.761531
-0.070246 3.002392 0.173691
0.03077 4.533543 0.595808
-0.049704 3.656161 0.242189
0.184871 0.575751 0.97962
0.041252 4.367673 0.642513
-0.006087 4.586342 0.425116
-0.256597 0.035864 0.000903
0.075886 3.469724 0.779498
 0.035503 4.466197 0.617111
0.172614 0.764237 0.971448
0.044843 4.29735 0.658074
-0.030348 4.175197 0.318194
0.093988 2.881766 0.837037
0.013397 4.665253 0.51563
0.038331 4.419957 0.629677
0.059973 3.936222 0.720482
0.032892 4.504935 0.605398
-0.15282 0.759116 0.028322
-0.031564 4.146781 0.313134
-0.078927 2.714962 0.148873
0.102159 2.611416 0.859478
0.033848 4.4912 0.609698
0.066388 3.756685 0.745165
0.040558 4.380507 0.639476
0.077865 3.407437 0.786304
0.073412 3.546486 0.770822
-0.099966 2.038233 0.09896
0.082371 3.26321 0.801336
0.069667 3.660142 0.757324
-0.034592 4.073276 0.300688
-0.132916 1.151722 0.047153
0.040808 4.375904 0.640573
-0.027287 4.243778 0.331079
F

0.1 0.2 0.3

0.1 0.2 0.3