Spreadsheet: 17da2615-c439-41b1-8284-3485455692d9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Cell [NAME] | Unnamed: 10 | Unnamed: 11
r | 0.05 |  |  | 50 |  |  |  |  |  | B8
T | 0.75 |  |  | 75 |  |  |  |  |  | B9
sigma | 0.35 |  |  | 70 |  |  |  |  |  | B10
X | 40 |  |  | 40 |  |  |  |  |  | B11
N | 60 |  |  | 60
 |  |  |  |  |  |  |  |  |  | A15
u | 1.039906899678481 |  |  |  |  |  |  |  |  | B15
d | 0.9616245457253725 |  |  |  |  |  |  |  |  | C15
p | 0.4982048655714331 |  |  |  |  |  |  |  |  | -B$5*EXP(-B$2*B$3)*(BINOMDIST(B$6,B$6,B$10,TRUE) | -B$5*EXP(-B$2*B$3)*(BINOMDIST(B$6,B$6,B$10,TRUE)
p' | 0.5177629741556242 |  |  |  |  |  |  |  |  | -BINOMDIST(B15,B$6,B$10,TRUE)) | -BINOMDIST(B15,B$6,B$10,TRUE))
 |  |  |  |  |  |  |  |  |  | D15
S | a | c(Binom) | d1 | d2 | c(BS) | c(max) | c(min) | c(min0) |  | E15
0 |  | 0 |  |  | 0 | 0 | 0 | 0 |  | F15
5 | 56 | 3.308775773835271e-14 | -6.585105547242482 | -6.888214438567036 | 4.805389075907846e-12 | 5 | 0 | 0 |  | [NAME]
10 | 47 | 2.57757662582629e-06 | -4.298312911332112 | -4.601421802656666 | 5.217046865123559e-06 | 10 | 0 | 0 |  | H15
15 | 42 | 0.001584602644083676 | -2.960624972399259 | -3.263733863723813 | 0.001844672822365046 | 15 | 0 | 0 |  | [NAME]
20 | 38 | 0.04277159497301186 | -2.011520275421744 | -2.314629166746298 | 0.04522896870392229 | 20 | 0 | 0
25 | 36 | 0.3116223412540398 | -1.275337478740669 | -1.578446370065223 | 0.3223683494346514 | 25 | 0 | 0 |  | A15:[NAME]   copied to A15:I34
30 | 33 | 1.180968449548979 | -0.6738323364888901 | -0.9769412278134435 | 1.176188716605496 | 30 | 0 | 0
35 | 31 | 2.892945566750374 | -0.1652669850944249 | -0.4683758764189784 | 2.88328097791916 | 35 | 0 | 0
40 | 30 | 5.481966010059157 | 0.2752723604886251 | -0.02783653083592835 | 5.501773918785826 | 40 | 1.472223291167126 | 0
45 | 28 | 8.924135622000442 | 0.6638556024439639 | 0.3607467111194104 | 8.906647060723227 | 45 | 6.472223291167126 | 5
50 | 27 | 12.89830870609896 | 1.0114551571697 | 0.7083462658451467 | 12.89946359452232 | 50 | 11.47222329116713 | 10
55 | 25 | 17.28119656716781 | 1.325897202692777 | 1.022788311368224 | 17.29080363214782 | 55 | 16.47222329116713 | 15
60 | 24 | 21.93105685848094 | 1.612960299421479 | 1.309851408096926 | 21.9345090802421 | 60 | 21.47222329116713 | 20
65 | 23 | 26.72742455041308 | 1.877032749832809 | 1.573923858508256 | 26.73060756886008 | 65 | 26.47222329116713 | 25
70 | 22 | 31.6116026386585 | 2.121525650815944 | 1.81841675949139 | 31.6157247157254 | 70 | 31.47222329116713 | 30
75 | 21 | 36.54667588418217 | 2.349143096102554 | 2.046034204778 | 36.5516593719746 | 75 | 36.47222329116713 | 35
80 | 21 | 41.51395962800067 | 2.562064996398994 | 2.258956105074441 | 41.5161553778096 | 80 | 41.47222329116713 | 40
85 | 20 | 46.49565490686815 | 2.762074377686068 | 2.458965486361515 | 46.49654206370833 | 85 | 46.47222329116713 | 45
90 | 19 | 51.484842665535 | 2.950648238354333 | 2.647539347029779 | 51.48571622517118 | 90 | 51.47222329116713 | 50
95 | 18 | 56.4786137533888 | 3.129023808381354 | 2.825914917056801 | 56.47973505907662 | 95 | 56.47222329116713 | 55
100 | 18 | 61.47598685602071 | 3.298247793080069 | 2.995138901755515 | 61.476422850447 | 100 | 61.47222329116713 | 60
Cell [NAME]
 | B2    =E2/1000
 | B3    =E3/100
 | B4    =E4/200
 | B5    =E5
 | B6    =E6