Spreadsheet: 98903d1297718527-lognormal-distribution-736783-lognormal-regression
Sheet: Sheet1

 |  |  |  | u | 2.761590646274634
 |  |  |  | s | 0.29839298696049
 |  |  |  | [NAME] | 0.0100781662653438 | 0.0100781662653438
Data |  |  | x | Data PMF | LN PDF | Data CDF | LN CDF
 | 3.999999999997428 |  | 1 | 0 | 3.364031537662369e-19 | 0 | 1.07237747745637e-20
8.224000000005915 |  |  | 2 | 0 | 2.459039047141592e-11 | 0 | 2.075481936165109e-12
8.614000000006072 |  |  | 3 | 0 | 8.025867911297054e-08 | 0 | 1.251123142602704e-08
8.999999999991815 |  |  | 4 | 0 | 8.150951027622749e-06 | 0 | 2.022953685232309e-06
9.000000000011 |  |  | 5 | 0 | 0.0001547908182290893 | 0 | 5.64175016051216e-05
9.95399999999087 |  |  | 6 | 0 | 0.001132653778289484 | 0 | 0.0005766581625290534
9.9889999999899 |  |  | 7 | 0 | 0.004554092300931976 | 0 | 0.003132514356326999
9.999999999998366 |  |  | 8 | 0 | 0.01225148225181763 | 0 | 0.01112490064838512
9.999999999998366 |  |  | 9 | 0.00847457627118644 | 0.02483690234752036 | 0.00847457627118644 | 0.02928870895425861
9.999999999998366 |  |  | 10 | 0.01694915254237288 | 0.0409542641271215 | 0.02542372881355932 | 0.06199270926239875
10.00000000000796 |  |  | 11 | 0.05367231638418079 | 0.05782790689104941 | 0.0790960451977401 | 0.111451149390281
10.23000000000707 |  |  | 12 | 0.115819209039548 | 0.07248361429755887 | 0.1949152542372881 | 0.176899157402802
10.2789999999942 |  |  | 13 | 0.1299435028248588 | 0.08277036741344554 | 0.3248587570621468 | 0.2549475503282554
10.51900000000536 |  |  | 14 | 0.06497175141242938 | 0.08777608163709258 | 0.3898305084745762 | 0.3406667644959183
10.75500000000211 |  |  | 15 | 0.05367231638418079 | 0.08770799170043396 | 0.443502824858757 | 0.4288003127884141
10.77899999999268 |  |  | 16 | 0.06214689265536723 | 0.08350384610918694 | 0.5056497175141242 | 0.5147007620229436
10.84900000000033 |  |  | 17 | 0.05084745762711865 | 0.07641206278468561 | 0.5564971751412429 | 0.5948457585804334
10.85400000000156 |  |  | 18 | 0.06779661016949153 | 0.06767097031300241 | 0.6242937853107344 | 0.6669774631003287
10.86399999998484 |  |  | 19 | 0.0903954802259887 | 0.0583216808354743 | 0.7146892655367232 | 0.7299880702587961
10.90300000000788 |  |  | 20 | 0.05649717514124294 | 0.04913495360595563 | 0.7711864406779662 | 0.7836780362398621
10.92299999999362 |  |  | 21 | 0.06497175141242938 | 0.04061391354686278 | 0.8361581920903955 | 0.8284823906371166
10.99900000000851 |  |  | 22 | 0.03389830508474576 | 0.03303653906563762 | 0.8700564971751413 | 0.8652222922422993
10.99999999999532 |  |  | 23 | 0.02542372881355932 | 0.02651179945386542 | 0.8954802259887007 | 0.8949076088719642
10.99999999999532 |  |  | 24 | 0.01977401129943503 | 0.02103390925417478 | 0.9152542372881357 | 0.9185956001325416
10.99999999999532 |  |  | 25 | 0.01129943502824859 | 0.01652736282363315 | 0.9265536723163843 | 0.9372995942938185
10.99999999999532 |  |  | 26 | 0.005649717514124294 | 0.01288067162802881 | 0.9322033898305085 | 0.9519370748176426
10.99999999999532 |  |  | 27 | 0.002824858757062147 | 0.009969567641085112 | 0.9350282485875707 | 0.9633061043254629
10.99999999999532 |  |  | 28 | 0 | 0.007671636975907298 | 0.9350282485875707 | 0.9720804829899252
10.99999999999532 |  |  | 29 | 0 | 0.005874591154899788 | 0.9350282485875707 | 0.9788161805721656
11.00000000000492 |  |  | 30 | 0.002824858757062147 | 0.004480153576652192 | 0.9378531073446329 | 0.9839636983018836
11.06400000000534 |  |  | 31 | 0 | 0.003405133949000043 | 0.9378531073446329 | 0.9878827981497761
11.09900000000437 |  |  | 32 | 0.002824858757062147 | 0.002580844364524283 | 0.9406779661016951 | 0.9908573974225052
11.13899999999504 |  |  | 33 | 0 | 0.001951649760195554 | 0.9406779661016951 | 0.993109393509317
11.1489999999975 |  |  | 34 | 0.002824858757062147 | 0.001473164928318195 | 0.9435028248587572 | 0.9948108292462239
11.1489999999975 |  |  | 35 | 0 | 0.001110407102475692 | 0.9435028248587572 | 0.9960942139758892
11.25799999999941 |  |  | 36 | 0 | 0.0008360742929366838 | 0.9435028248587572 | 0.9970610502674739
11.28900000000321 |  |  | 37 | 0.002824858757062147 | 0.0006290296029491833 | 0.9463276836158194 | 0.9977887380066218
11.29500000000085 |  |  | 38 | 0 | 0.0004730167676530932 | 0.9463276836158194 | 0.9983360779018859
11.30899999999855 |  |  | 39 | 0 | 0.0003556009079829301 | 0.9463276836158194 | 0.9987476044823872
11.32499999999865 |  |  | 40 | 0 | 0.0002673126223059504 | 0.9463276836158194 | 0.9990569637168498
11.38000000000261 |  |  | 41 | 0 | 0.0002009671465044942 | 0.9463276836158194 | 0.9992895247122244
11.43499999999698 |  |  | 42 | 0 | 0.0001511294163587559 | 0.9463276836158194 | 0.9994643858996861
11.47300000000442 |  |  | 43 | 0 | 0.0001136978878142481 | 0.9463276836158194 | 0.9995959077960326
11.48300000000688 |  |  | 44 | 0 | 8.558331557358915e-05 | 0.9463276836158194 | 0.9996948788932993
11.52900000000479 |  |  | 45 | 0 | 6.446242072991561e-05 | 0.9463276836158194 | 0.9997693992893337
11.53899999999766 |  |  | 46 | 0 | 4.858998086174027e-05 | 0.9463276836158194 | 0.999825548428205
11.57199999999428 |  |  | 47 | 0 | 3.665610188719598e-05 | 0.9463276836158194 | 0.9998678885027232
11.65899999999844 |  |  | 48 | 0 | 2.767818728526833e-05 | 0.9463276836158194 | 0.9998998432490961
11.68799999999983 |  |  | 49 | 0 | 2.091940170912422e-05 | 0.9463276836158194 | 0.9999239825584378
11.70499999999635 |  |  | 50 | 0 | 1.582727166248499e-05 | 0.9463276836158194 | 0.9999422360837367
11.72500000001087 |  |  | 51 | 0 | 1.198753366888453e-05 | 0.9463276836158194 | 0.9999560534263536
11.73199999999532 |  |  | 52 | 0 | 9.089492319049643e-06 | 0.9463276836158194 | 0.9999665241963155
11.73699999998696 |  |  | 53 | 0 | 6.900045371463441e-06 | 0.9463276836158194 | 0.9999744679696067
11.74399999999061 |  |  | 54 | 0 | 5.244222410324292e-06 | 0.9463276836158194 | 0.9999805016825214
11.76900000000636 |  |  | 55 | 0 | 3.990611103812408e-06 | 0.9463276836158194 | 0.9999850901258048
11.775000000004 |  |  | 56 | 0 | 3.040446669251459e-06 | 0.9463276836158194 | 0.9999885837843823
11.7889999999921 |  |  | 57 | 0 | 2.319444497202784e-06 | 0.9463276836158194 | 0.9999912472044954
11.84399999999606 |  |  | 58 | 0 | 1.771685738719826e-06 | 0.9463276836158194 | 0.9999932802694852
11.93200000000623 |  |  | 59 | 0 | 1.355038758670471e-06 | 0.9463276836158194 | 0.9999948341659778
11.94299999999551 |  |  | 60 | 0.002824858757062147 | 1.037729418892752e-06 | 0.9491525423728816 | 0.9999960233738258
11.95299999999797 |  |  | 61 | 0 | 7.957707016462508e-07 | 0.9491525423728816 | 0.9999969346771863
11.9579999999992 |  |  | 62 | 0 | 6.110352414398407e-07 | 0.9491525423728816 | 0.999997633941107
11.99999999999228 |  |  | 63 | 0 | 4.698089913139123e-07 | 0.9491525423728816 | 0.9999981712140595
11.99999999999228 |  |  | 64 | 0.002824858757062147 | 3.61705110228517e-07 | 0.9519774011299438 | 0.9999985845722843
11.99999999999228 |  |  | 65 | 0 | 2.788476882504436e-07 | 0.9519774011299438 | 0.9999989030188003
11.99999999999228 |  |  | 66 | 0.002824858757062147 | 2.152577305795476e-07 | 0.954802259887006 | 0.9999991486742743
11.99999999999228 |  |  | 67 | 0.002824858757062147 | 1.663908531485052e-07 | 0.9576271186440681 | 0.9999993384302195
11.99999999999228 |  |  | 68 | 0 | 1.287888634972604e-07 | 0.9576271186440681 | 0.9999994852017531
11.99999999999228 |  |  | 69 | 0 | 9.981690377413596e-08 | 0.9576271186440681 | 0.9999995988773398
11.99999999999228 |  |  | 70 | 0.002824858757062147 | 7.74649343068002e-08 | 0.9604519774011303 | 0.999999687036808
12.00000000000188 |  |  | 71 | 0.002824858757062147 | 6.019764543328626e-08 | 0.9632768361581925 | 0.9999997554984529
12.00000000000188 |  |  | 72 | 0.005649717514124294 | 4.684085667018983e-08 | 0.9689265536723167 | 0.9999998087329395
12.00000000000188 |  |  | 73 | 0.002824858757062147 | 3.649543479091068e-08 | 0.9717514124293789 | 0.9999998501816453
12.00000000000188 |  |  | 74 | 0.002824858757062147 | 2.847198878718361e-08 | 0.9745762711864411 | 0.9999998824960372
12.00000000000188 |  |  | 75 | 0.005649717514124294 | 2.224126853859667e-08 | 0.9802259887005653 | 0.9999999077218495
12.00000000000188 |  |  | 76 | 0 | 1.739644597441393e-08 | 0.9802259887005653 | 0.9999999274395079
12.00000000000188 |  |  | 77 | 0.002824858757062147 | 1.362439754715243e-08 | 0.9830508474576275 | 0.9999999428715418
12.00000000000188 |  |  | 78 | 0 | 1.068381331596403e-08 | 0.9830508474576275 | 0.9999999549648506
12.00000000000188 |  |  | 79 | 0.005649717514124294 | 8.388489400748472e-09 | 0.9887005649717517 | 0.9999999644537887
12.00000000000188 |  |  | 80 | 0 | 6.594560771794219e-09 | 0.9887005649717517 | 0.9999999719086022
12.00000000000188 |  |  | 81 | 0 | 5.190733013701896e-09 | 0.9887005649717517 | 0.9999999777726674
12.00000000000188 |  |  | 82 | 0.002824858757062147 | 4.090799345416227e-09 | 0.9915254237288139 | 0.9999999823911531
12.00000000001147 |  |  | 83 | 0 | 3.227901143761203e-09 | 0.9915254237288139 | 0.9999999860331132
12.00000000001147 |  |  | 84 | 0 | 2.550120267201581e-09 | 0.9915254237288139 | 0.9999999889085338
12.0040000000067 |  |  | 85 | 0.002824858757062147 | 2.017089937031114e-09 | 0.9943502824858761 | 0.9999999911815053
12.01600000000198 |  |  | 86 | 0 | 1.597385562557476e-09 | 0.9943502824858761 | 0.9999999929804126
12.01700000000798 |  |  | 87 | 0.002824858757062147 | 1.266513528232521e-09 | 0.9971751412429383 | 0.999999994405828
12.04000000000214 |  |  | 88 | 0 | 1.005358984492055e-09 | 0.9971751412429383 | 0.9999999955366328
12.05900000000106 |  |  | 89 | 0 | 7.98986408258941e-10 | 0.9971751412429383 | 0.9999999964347707
12.13099999999194 |  |  | 90 | 0.002824858757062147 | 6.357116186286795e-10 | 1 | 0.9999999971489435
12.1849999999899 |  |  | 91 | 0 | 5.063829320462822e-10 | 1 | 0.9999999977174875
12.18799999999831 |  |  | 92 | 0 | 4.038236432653254e-10 | 1 | 0.9999999981706156
12.2929999999954 |  |  | 93 | 0 | 3.223991010942412e-10 | 1 | 0.9999999985321665
12.39200000000444 |  |  | 94 | 0 | 2.576801276834565e-10 | 1 | 0.9999999988209719
12.39799999999249 |  |  | 95 | 0 | 2.061810259950888e-10 | 1 | 0.9999999990519252
12.39899999999849 |  |  | 96 | 0 | 1.651554021990078e-10 | 1 | 0.9999999992368187
12.42400000000465 |  |  | 97 | 0 | 1.324368553875284e-10 | 1 | 0.999999999385
12.43299999999152 |  |  | 98 | 0 | 1.063145281367572e-10 | 1 | 0.9999999995038872
12.45700000000127 |  |  | 99 | 0 | 8.543577526162225e-11 | 1 | 0.9999999995993738
12.48500000000625 |  |  |  | 0 |  | 1
12.48599999999307
12.52800000000533
12.53300000000657
12.55700000000672
12.6289999999976
12.6289999999976
12.72199999999941
12.75399999999962
12.84499999999902
12.93299999999959
12.93899999998764
12.99999999999883
12.99999999999883
12.99999999999883
12.99999999999883
12.99999999999883
13.00000000000843
13.00000000000843
13.00000000000843
13.00000000000843
13.00000000000843
13.00000000000843
13.03900000000269
13.08899999999582
13.24500000000164
13.2689999999922
13.2690000000018
13.27899999999467
13.32299999999975
13.47099999999593
13.47900000000557
13.51899999999624
13.58200000000984
13.70200000000104
13.73900000000248
13.7719999999991
13.9999999999862
13.99999999999579
13.99999999999579
14.00000000000539
14.00000000000539
14.14900000000756
14.30000000000256
14.31999999999789
14.40399999999364
14.43399999999144
14.44499999999032
14.50800000000392
14.55699999999105
14.68800000000989
14.75900000000436
14.82199999999878
14.90900000000295
14.92899999999828
14.93399999998992
14.95900000001527
14.99999999999275
14.99999999999275
15.00000000000234
15.00000000000234
15.00000000000234
15.00000000000234
15.00000000001194
15.10399999999343
15.19400000000601
15.19700000000483
15.84200000000067
15.85899999999718
15.98900000001002
15.99999999998971
15.99999999998971
15.9999999999993
15.9999999999993
15.9999999999993
15.9999999999993
15.9999999999993
15.9999999999993
15.9999999999993
15.9999999999993
15.9999999999993
16.0000000000089
16.13899999999902
16.23400000000323
16.26499999999744
16.28900000000719
16.30900000000253
16.30900000001212
16.3200000000014
16.35500000001002
16.44899999999865
16.65400000001078
16.66899999999529
16.8240000000047
16.99999999999626
16.99999999999626
16.99999999999626
16.99999999999626
16.99999999999626
17.00000000000585
17.00000000000585
17.00000000000585
17.03999999999652
17.05899999999545
17.06899999999791
17.15399999999967
17.1740000000046
17.21499999999168
17.27400000001005
17.30699999999707
17.35199999999857
17.52899999999613
17.60399999999542
17.60700000000384
17.60900000000625
17.60999999999306
17.74799999999637
17.75799999998924
17.84899999999823
17.93900000000122
17.99999999999322
17.99999999999322
17.99999999999322
18.00000000000281
18.00000000000281
18.00000000000281
18.00000000000281
18.00000000000281
18.00000000001241
18.00000000001241
18.00000000001241
18.06700000000205
18.07899999999734
18.10299999999749
18.2419999999972
18.24299999998402
18.35699999999676
18.4089999999923
18.41899999999477
18.42700000000441
18.4560000000058
18.59900000000074
18.61200000000203
18.65399999999511
18.76899999999466
18.81900000000698
18.84400000000355
18.89400000001586
18.99999999999018
18.99999999999018
18.99999999999018
18.99999999999018
18.99999999999977
18.99999999999977
18.99999999999977
19.00000000000936
19.00000000000936
19.02300000000352
19.05899999998937
19.09099999999917
19.24899999999781
19.26499999998832
19.28399999999684
19.33399999999956
19.51500000000195
19.60600000001094
19.63399999999673
19.71700000000567
19.78900000000614
19.88499999998758
19.96900000000252
19.99999999999673
19.99999999999673
19.99999999999673
19.99999999999673
20.00000000000632
20.00000000000632
20.00000000000632
20.00000000000632
20.00000000000632
20.00899999999319
20.16899999999424
20.17299999999906
20.18699999999676
20.25700000000441
20.41700000000546
20.48599999998792
20.51599999999532
20.52300000000855
20.53300000000142
20.53300000001101
20.57300000000168
20.59000000000779
20.5910000000042
20.68899999999765
20.73800000000396
20.85999999998798
20.99999999999369
21.00000000000328
21.00000000000328
21.00000000000328
21.00000000000328
21.07500000000258
21.48700000000048
21.54199999999484
21.63499999999665
21.67999999999815
21.77699999999518
21.80200000000134
21.94999999999752
22.00000000000024
22.18999999999909
22.23499999999099
22.27800000000926
22.41900000000179
22.74999999999316
22.93799999999919
22.99999999998761
22.9999999999972
23.00000000000679
23.14199999999573
23.32199999999212
23.63000000000852
23.72899999998879
23.75399999999495
23.90700000000194
24.00000000000375
24.00000000000375
24.99999999999112
24.99999999999112
25.16399999999699
25.99999999999767
26.00000000000726
29.00000000000773
31.142999999987
33.21299999998857
36.50900000000057
59.99999999999979
63.00000000000026
65.66900000000935
66.99999999999768
69.99999999999815
70.99999999999511
71.29700000000305
71.870000000008
72.89399999999553
73.99999999999558
74.08600000000334
74.43600000000323
76.68399999998918
78.99999999998997
78.99999999999956
81.71000000001492
84.64400000000296
86.93499999999759
89.16799999999903
 | 146.4690000000015 | << deleted three outliers
 | 195.9999999999987
 | 1938.000000000005