Spreadsheet: 35423d1233013277-graphing-lognormal-distrbution-for-stock-prices-probabilitydistribution
Sheet: Sheet1

Increment | 0 | #N/A | 0 | Spot Price | 15
0.25 | 0.25 | 5.996767802479387e-06 | 0.01661770545362674 | 3-mo Libor | 0.0118375
 | 0.5 | 0.0001535398289128677 | 0.03323541090725348 | Future Price | 15.04419492195528
 | 0.75 | 0.0007302514576032189 | 0.04985311636088022 | Volatility (annualized) | 0.3
 | 1 | 0.0018983879935256 | 0.06647082181450696 | Time | 0.25
 | 1.25 | 0.00365354169832211 | 0.0830885272681337
 | 1.5 | 0.0058980218377113 | 0.09970623272176045
 | 1.75 | 0.00850152598540076 | 0.1163239381753872
 | 2 | 0.01133467341998897 | 0.1329416436290139
 | 2.25 | 0.01428402721408308 | 0.1495593490826407
 | 2.5 | 0.01725693995174951 | 0.1661770545362674
 | 2.75 | 0.02018141729479372 | 0.1827947599898941
 | 3 | 0.02300384469055266 | 0.1994124654435209
 | 3.25 | 0.02568602995117121 | 0.2160301708971476
 | 3.5 | 0.0282022540782931 | 0.2326478763507744
 | 3.75 | 0.03053662573191135 | 0.2492655818044011
 | 4 | 0.03268083554175706 | 0.2658832872580278
 | 4.25 | 0.03463231181409084 | 0.2825009927116546
 | 4.5 | 0.03639273852182059 | 0.2991186981652814
 | 4.75 | 0.03796688285499542 | 0.3157364036189081
 | 5 | 0.03936167891470553 | 0.3323541090725348
 | 5.25 | 0.04058551905489094 | 0.3489718145261616
 | 5.5 | 0.04164771123802494 | 0.3655895199797883
 | 5.75 | 0.04255806780336239 | 0.3822072254334151
 | 6 | 0.04332659747093338 | 0.3988249308870418
 | 6.25 | 0.0439632779424612 | 0.4154426363406685
 | 6.5 | 0.04447789107701481 | 0.4320603417942953
 | 6.75 | 0.04487990638839637 | 0.448678047247922
 | 7 | 0.04517840164704193 | 0.4652957527015488
 | 7.25 | 0.0453820117920597 | 0.4819134581551755
 | 7.5 | 0.04549889928059242 | 0.4985311636088022
 | 7.75 | 0.04553674051900767 | 0.515148869062429
 | 8 | 0.04550272421477026 | 0.5317665745160557
 | 8.25 | 0.04540355842580721 | 0.5483842799696824
 | 8.5 | 0.04524548381945453 | 0.5650019854233091
 | 8.75 | 0.04503429122860822 | 0.581619690876936
 | 9 | 0.04477534204257495 | 0.5982373963305627
 | 9.25 | 0.0444735903212709 | 0.6148551017841895
 | 9.5 | 0.04413360579508706 | 0.6314728072378162
 | 9.75 | 0.04375959712562869 | 0.6480905126914429
 | 10 | 0.04335543496777204 | 0.6647082181450696
 | 10.25 | 0.04292467450137177 | 0.6813259235986964
 | 10.5 | 0.04247057719958789 | 0.6979436290523231
 | 10.75 | 0.04199613167653656 | 0.7145613345059498
 | 11 | 0.04150407351479174 | 0.7311790399595766
 | 11.25 | 0.04099690401709082 | 0.7477967454132034
 | 11.5 | 0.0404769078595042 | 0.7644144508668301
 | 11.75 | 0.03994616964773182 | 0.7810321563204569
 | 12 | 0.039406589395987 | 0.7976498617740836
 | 12.25 | 0.03885989696061112 | 0.8142675672277103
 | 12.5 | 0.03830766546929933 | 0.830885272681337
 | 12.75 | 0.03775132379252966 | 0.8475029781349638
 | 13 | 0.03719216810719118 | 0.8641206835885905
 | 13.25 | 0.0366313726040678 | 0.8807383890422172
 | 13.5 | 0.03606999939119211 | 0.897356094495844
 | 13.75 | 0.03550900764448099 | 0.9139737999494708
 | 14 | 0.0349492620557704 | 0.9305915054030975
 | 14.25 | 0.03439154062658566 | 0.9472092108567243
 | 14.5 | 0.03383654185387645 | 0.963826916310351
 | 14.75 | 0.03328489135163443 | 0.9804446217639777
 | 15 | 0.0327371479498881 | 0.9970623272176045
 | 15.25 | 0.03219380931010565 | 1.013680032671231
 | 15.5 | 0.03165531709358264 | 1.030297738124858
 | 15.75 | 0.03112206171698604 | 1.046915443578485
 | 16 | 0.03059438672689672 | 1.063533149032111
 | 16.25 | 0.03007259282295652 | 1.080150854485738
 | 16.5 | 0.02955694155709753 | 1.096768559939365
 | 16.75 | 0.02904765873431421 | 1.113386265392992
 | 17 | 0.02854493753854075 | 1.130003970846618
 | 17.25 | 0.02804894140541327 | 1.146621676300245
 | 17.5 | 0.02755980666203052 | 1.163239381753872
 | 17.75 | 0.0270776449522725 | 1.179857087207499
 | 18 | 0.0266025454647912 | 1.196474792661125
 | 18.25 | 0.02613457697944568 | 1.213092498114752
 | 18.5 | 0.02567378974671001 | 1.229710203568379
 | 18.75 | 0.02522021721343168 | 1.246327909022006
 | 19 | 0.02477387760725487 | 1.262945614475632
 | 19.25 | 0.02433477539103995 | 1.279563319929259
 | 19.5 | 0.02390290259770566 | 1.296181025382886
 | 19.75 | 0.02347824005508459 | 1.312798730836513
 | 20 | 0.02306075850961358 | 1.329416436290139
 | 20.25 | 0.02265041965697255 | 1.346034141743766
 | 20.5 | 0.02224717708713319 | 1.362651847197393
 | 20.75 | 0.02185097715067949 | 1.379269552651019
 | 21 | 0.0214617597527107 | 1.395887258104646
 | 21.25 | 0.02107945908013016 | 1.412504963558273
 | 21.5 | 0.02070400426765734 | 1.4291226690119
 | 21.75 | 0.02033532000747211 | 1.445740374465526
 | 22 | 0.01997332710700644 | 1.462358079919153
 | 22.25 | 0.01961794299903688 | 1.47897578537278
 | 22.5 | 0.01926908220789868 | 1.495593490826407
 | 22.75 | 0.01892665677533669 | 1.512211196280034
 | 23 | 0.0185905766492275 | 1.52882890173366
 | 23.25 | 0.0182607500381491 | 1.545446607187287
 | 23.5 | 0.01793708373453706 | 1.562064312640914
 | 23.75 | 0.01761948340894822 | 1.57868201809454
 | 24 | 0.01730785387775256 | 1.595299723548167
 | 24.25 | 0.01700209934638936 | 1.611917429001794
 | 24.5 | 0.01670212363015468 | 1.628535134455421
 | 24.75 | 0.01640783035433102 | 1.645152839909047
 | 25 | 0.01611912313532698 | 1.661770545362674
 | 25.25 | 0.01583590574436286 | 1.678388250816301
 | 25.5 | 0.01555808225511673 | 1.695005956269928
 | 25.75 | 0.01528555717663423 | 1.711623661723554
 | 26 | 0.01501823557270234 | 1.728241367177181
 | 26.25 | 0.0147560231687931 | 1.744859072630808
 | 26.5 | 0.0144988264475962 | 1.761476778084434
 | 26.75 | 0.01424655273407925 | 1.778094483538061
 | 27 | 0.01399911027094068 | 1.794712188991688
 | 27.25 | 0.01375640828525261 | 1.811329894445315
 | 27.5 | 0.01351835704702815 | 1.827947599898942
 | 27.75 | 0.01328486792039 | 1.844565305352568
 | 28 | 0.0130558534079643 | 1.861183010806195
 | 28.25 | 0.01283122718907457 | 1.877800716259822
 | 28.5 | 0.01261090415226545 | 1.894418421713449
 | 28.75 | 0.01239480042264449 | 1.911036127167075
 | 29 | 0.01218283338449183 | 1.927653832620702
 | 29.25 | 0.01197492169955223 | 1.944271538074329
 | 29.5 | 0.01177098532139138 | 1.960889243527955
 | 29.75 | 0.01157094550616834 | 1.977506948981582
 | 30 | 0.0113747248201481 | 1.994124654435209
 | 30.25 | 0.01118224714425295 | 2.010742359888836
 | 30.5 | 0.01099343767592733 | 2.027360065342462
 | 30.75 | 0.01080822292856953 | 2.043977770796089
 | 31 | 0.01062653072876307 | 2.060595476249716
 | 31.25 | 0.01044829021152228 | 2.077213181703343
 | 31.5 | 0.01027343181374952 | 2.093830887156969
 | 31.75 | 0.0101018872660854 | 2.110448592610596
 | 32 | 0.009933589583319202 | 2.127066298064223
 | 32.25 | 0.0097684730535127 | 2.143684003517849
 | 32.5 | 0.009606473225978749 | 2.160301708971476
 | 32.75 | 0.009447526898243968 | 2.176919414425103
 | 33 | 0.009291572102114648 | 2.19353711987873
 | 33.25 | 0.009138548088955058 | 2.210154825332356
 | 33.5 | 0.008988395314278322 | 2.226772530785983
 | 33.75 | 0.008841055421741646 | 2.24339023623961
 | 34 | 0.00869647122663018 | 2.260007941693237
 | 34.25 | 0.008554586698906408 | 2.276625647146863
 | 34.5 | 0.008415346945895586 | 2.29324335260049
 | 34.75 | 0.008278698194671724 | 2.309861058054117
 | 35 | 0.008144587774202836 | 2.326478763507744
 | 35.25 | 0.008012964097309208 | 2.343096468961371
 | 35.5 | 0.007883776642483646 | 2.359714174414997
 | 35.75 | 0.007756975935618099 | 2.376331879868624
 | 36 | 0.007632513531677291 | 2.392949585322251
 | 36.25 | 0.007510341996356046 | 2.409567290775878
 | 36.5 | 0.007390414887753613 | 2.426184996229504
 | 36.75 | 0.007272686738095131 | 2.442802701683131
 | 37 | 0.007157113035527444 | 2.459420407136758
 | 37.25 | 0.007043650206013784 | 2.476038112590385
 | 37.5 | 0.006932255595349343 | 2.492655818044011
 | 37.75 | 0.006822887451317485 | 2.509273523497638
 | 38 | 0.006715504906004208 | 2.525891228951265
 | 38.25 | 0.006610067958286597 | 2.542508934404891
 | 38.5 | 0.006506537456509174 | 2.559126639858518
 | 38.75 | 0.006404875081360405 | 2.575744345312145
 | 39 | 0.006305043328960164 | 2.592362050765772
 | 39.25 | 0.006207005494167572 | 2.608979756219398
 | 39.5 | 0.006110725654117287 | 2.625597461673025
 | 39.75 | 0.006016168651991268 | 2.642215167126652
 | 40 | 0.005923300081031858 | 2.658832872580279
 | 40.25 | 0.005832086268801184 | 2.675450578033905
 | 40.5 | 0.005742494261690843 | 2.692068283487532
 | 40.75 | 0.005654491809685113 | 2.708685988941159
 | 41 | 0.005568047351380181 | 2.725303694394785
 | 41.25 | 0.005483129999261184 | 2.741921399848412
 | 41.5 | 0.00539970952523817 | 2.758539105302039
 | 41.75 | 0.00531775634644171 | 2.775156810755666
 | 42 | 0.005237241511278169 | 2.791774516209292
 | 42.25 | 0.005158136685744301 | 2.808392221662919
 | 42.5 | 0.005080414140000391 | 2.825009927116546
 | 42.75 | 0.005004046735200825 | 2.841627632570173
 | 43 | 0.004929007910580488 | 2.858245338023799
 | 43.25 | 0.00485527167079529 | 2.874863043477426
 | 43.5 | 0.004782812573514685 | 2.891480748931053
 | 43.75 | 0.004711605717263831 | 2.90809845438468
 | 44 | 0.004641626729512909 | 2.924716159838306
 | 44.25 | 0.004572851755010827 | 2.941333865291933
 | 44.5 | 0.004505257444360376 | 2.95795157074556
 | 44.75 | 0.004438820942831827 | 2.974569276199187
 | 45 | 0.004373519879411726 | 2.991186981652814
 | 45.25 | 0.004309332356083631 | 3.00780468710644
 | 45.5 | 0.004246236937337374 | 3.024422392560067
 | 45.75 | 0.004184212639903338 | 3.041040098013694
 | 46 | 0.004123238922708249 | 3.057657803467321
 | 46.25 | 0.004063295677048855 | 3.074275508920947