Spreadsheet: 266478d1379623850-data-interpolation-and-formulas-data-20interpolation-20-20excel-20forum-jp-
Sheet: Sheet1

Tabulated Data |  |  |  |  | Interpolated Data 1 |  |  | Interpolated Data 2
Daily Rainfall | No. of | % of | Cumulative |  | Cumulative | Daily Rainfall |  | Daily Rainfall | Cumulative
Depth (mm) | Events | total events | Frequency % |  | Frequency % | Depth (mm) |  | Depth (mm) | Frequency %
0 | 0 | 0 | 0 |  | 0 | 0 |  | 1 | 0.1187838819494891
6.35 | 4276 | 0.7542776503792556 | 0.7542776503792556 |  | 0.1 | 0.8418650608044901 |  | 2 | 0.2375677638989782
12.7 | 754 | 0.133004057152937 | 0.8872817075321927 |  | 0.2 | 1.68373012160898 |  | 3 | 0.3563516458484673
19.05 | 298 | 0.05256659022755336 | 0.9398482977597461 |  | 0.3 | 2.52559518241347 |  | 4 | 0.4751355277979563
25.4 | 147 | 0.02593049920620921 | 0.9657787969659553 |  | 0.4 | 3.36746024321796 |  | 5 | 0.5939194097474454
31.75 | 80 | 0.01411183630269889 | 0.9798906332686541 |  | 0.5 | 4.209325304022451 |  | 6 | 0.7127032916969346
38.1 | 55 | 0.009701887458105485 | 0.9895925207267596 |  | 0.6 | 5.05119036482694 |  | 7 | 0.7678922389067218
44.45 | 20 | 0.003527959075674722 | 0.9931204798024343 |  | 0.7 | 5.89305542563143 |  | 8 | 0.7888377597182078
50.8 | 19 | 0.003351561121890986 | 0.9964720409243253 |  | 0.75 | 6.313987956033675 |  | 9 | 0.8097832805296938
57.15000000000001 | 5 | 0.0008819897689186806 | 0.997354030693244 |  | 0.8 | 8.532917771883287 |  | 10 | 0.8307288013411802
63.50000000000001 | 9 | 0.001587581584053625 | 0.9989416122772976 |  | 0.85 | 10.92006299734748 |  | 11 | 0.8516743221526663
69.85000000000001 | 1 | 0.0001763979537837361 | 0.9991180102310814 |  | 0.9 | 14.23635906040268 |  | 12 | 0.8726198429641524
76.2 | 2 | 0.0003527959075674722 | 0.9994708061386488 |  | 0.93 | 17.86033389261744 |  | 13 | 0.8897651684878252
82.55 | 2 | 0.0003527959075674722 | 0.9998236020462162 |  | 0.95 | 21.53600340136051 |  | 14 | 0.8980433716732665
88.89999999999999 | 0 | 0 | 0.9998236020462162 |  | 0.97 | 27.29944374999997 |  | 15 | 0.9063215748587081
95.24999999999999 | 1 | 0.0001763979537837361 | 1 |  | 0.98 | 31.82158181818179 |  | 16 | 0.9145997780441496
101.6 | 0 | 0 | 1 |  | 0.99 | 38.83342499999988 |  | 17 | 0.9228779812295911
107.95 | 0 | 0 | 1 |  | 0.995 | 48.01101315789468 |  | 18 | 0.9311561844150326
114.3 | 0 | 0 | 1 |  | 1 | 95.25 |  | 19 | 0.939434387600474
120.65 | 0 | 0 | 1 |  |  |  |  | 20 | 0.9437276637827223
127 | 0 | 0 | 1 |  |  |  |  | 21 | 0.9478112069648024
133.35 | 0 | 0 | 1 |  |  |  |  | 22 | 0.9518947501468826
139.7 | 0 | 0 | 1 |  |  |  |  | 23 | 0.9559782933289628
146.05 | 0 | 0 | 1 |  |  |  |  | 24 | 0.960061836511043
152.3999999999999 | 0 | 0 | 1 |  |  |  |  | 25 | 0.9641453796931232
158.7499999999999 | 0 | 0 | 1 |  |  |  |  | 26 | 0.9671121988213285
165.0999999999999 | 0 | 0 | 1 |  |  |  |  | 27 | 0.9693345352469502
171.4499999999999 | 0 | 0 | 1 |  |  |  |  | 28 | 0.971556871672572
177.7999999999999 | 0 | 0 | 1 |  |  |  |  | 29 | 0.973779208098194
184.1499999999999 | 0 | 0 | 1 |  |  |  |  | 30 | 0.9760015445238159
190.4999999999999 | 0 | 0 | 1 |  |  |  |  | 31 | 0.9782238809494377
196.8499999999999 | 0 | 0 | 1 |  |  |  |  | 32 | 0.9802725973418078
203.1999999999999 | 0 | 0 | 1 |  |  |  |  | 33 | 0.9818004536344229
209.5499999999999 | 0 | 0 | 1 |  |  |  |  | 34 | 0.983328309927038
Totals | 5669 | 1 |  |  |  |  |  | 35 | 0.9848561662196531
 |  |  |  |  |  |  |  | 36 | 0.986384022512268
 |  |  |  |  |  |  |  | 37 | 0.9879118788048831
 |  |  |  |  |  |  |  | 38 | 0.9894397350974982
 |  |  |  |  |  |  |  | 39 | 0.9900925464225245
 |  |  |  |  |  |  |  | 40 | 0.9906481305289301
 |  |  |  |  |  |  |  | 41 | 0.9912037146353354
 |  |  |  |  |  |  |  | 42 | 0.991759298741741
 |  |  |  |  |  |  |  | 43 | 0.9923148828481464
 |  |  |  |  |  |  |  | 44 | 0.9928704669545518
 |  |  |  |  |  |  |  | 45 | 0.9934107724980311
 |  |  |  |  |  |  |  | 46 | 0.9939385773991164
 |  |  |  |  |  |  |  | 47 | 0.9944663823002016
 |  |  |  |  |  |  |  | 48 | 0.9949941872012869
 |  |  |  |  |  |  |  | 49 | 0.9955219921023719
 |  |  |  |  |  |  |  | 50 | 0.9960497970034572
 |  |  |  |  |  |  |  | 51 | 0.9964998201296456
 |  |  |  |  |  |  |  | 52 | 0.996638716156247
 |  |  |  |  |  |  |  | 53 | 0.9967776121828483
 |  |  |  |  |  |  |  | 54 | 0.9969165082094497
 |  |  |  |  |  |  |  | 55 | 0.9970554042360511
 |  |  |  |  |  |  |  | 56 | 0.9971943002626524
 |  |  |  |  |  |  |  | 57 | 0.9973331962892539
 |  |  |  |  |  |  |  | 58 | 0.9975665416139441
 |  |  |  |  |  |  |  | 59 | 0.9978165544618265
 |  |  |  |  |  |  |  | 60 | 0.9980665673097091
 |  |  |  |  |  |  |  | 61 | 0.9983165801575915
 |  |  |  |  |  |  |  | 62 | 0.998566593005474
 |  |  |  |  |  |  |  | 63 | 0.9988166058533564
 |  |  |  |  |  |  |  | 64 | 0.9989555018799577
 |  |  |  |  |  |  |  | 65 | 0.9989832810852781
 |  |  |  |  |  |  |  | 66 | 0.9990110602905983
 |  |  |  |  |  |  |  | 67 | 0.9990388394959185
 |  |  |  |  |  |  |  | 68 | 0.9990666187012389
 |  |  |  |  |  |  |  | 69 | 0.9990943979065592
 |  |  |  |  |  |  |  | 70 | 0.9991263439926775
 |  |  |  |  |  |  |  | 71 | 0.999181902403318
 |  |  |  |  |  |  |  | 72 | 0.9992374608139585
 |  |  |  |  |  |  |  | 73 | 0.999293019224599
 |  |  |  |  |  |  |  | 74 | 0.9993485776352395
 |  |  |  |  |  |  |  | 75 | 0.9994041360458802
 |  |  |  |  |  |  |  | 76 | 0.9994596944565207
 |  |  |  |  |  |  |  | 77 | 0.9995152528671611
 |  |  |  |  |  |  |  | 78 | 0.9995708112778019
 |  |  |  |  |  |  |  | 79 | 0.9996263696884424
 |  |  |  |  |  |  |  | 80 | 0.9996819280990829
 |  |  |  |  |  |  |  | 81 | 0.9997374865097234
 |  |  |  |  |  |  |  | 82 | 0.9997930449203639
 |  |  |  |  |  |  |  | 83 | 0.9998236020462162
 |  |  |  |  |  |  |  | 84 | 0.9998236020462162
 |  |  |  |  |  |  |  | 85 | 0.9998236020462161
 |  |  |  |  |  |  |  | 86 | 0.9998236020462163
 |  |  |  |  |  |  |  | 87 | 0.9998236020462161
 |  |  |  |  |  |  |  | 88 | 0.9998236020462162
 |  |  |  |  |  |  |  | 89 | 0.9998263799667483
 |  |  |  |  |  |  |  | 90 | 0.9998541591720685
 |  |  |  |  |  |  |  | 91 | 0.9998819383773888
 |  |  |  |  |  |  |  | 92 | 0.999909717582709
 |  |  |  |  |  |  |  | 93 | 0.9999374967880295
 |  |  |  |  |  |  |  | 94 | 0.9999652759933496
 |  |  |  |  |  |  |  | 95 | 0.99999305519867
 |  |  |  |  |  |  |  | 96 | 1
 |  |  |  |  |  |  |  | 97 | 1
 |  |  |  |  |  |  |  | 98 | 1
 |  |  |  |  |  |  |  | 99 | 1
 |  |  |  |  |  |  |  | 100 | 1