Spreadsheet: 266464d1379619427-data-interpolation-and-formulas-data-interpolation-excel-forum
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 |  |  | 1
6.35 | 4276 | 0.7542776503792556 | 0.7542776503792556 |  | 0.1 |  |  | 2
12.7 | 754 | 0.133004057152937 | 0.8872817075321927 |  | 0.2 |  |  | 3
19.05 | 298 | 0.05256659022755336 | 0.9398482977597461 |  | 0.3 |  |  | 4
25.4 | 147 | 0.02593049920620921 | 0.9657787969659553 |  | 0.4 |  |  | 5
31.75 | 80 | 0.01411183630269889 | 0.9798906332686541 |  | 0.5 |  |  | 6
38.1 | 55 | 0.009701887458105485 | 0.9895925207267596 |  | 0.6 |  |  | 7
44.45 | 20 | 0.003527959075674722 | 0.9931204798024343 |  | 0.7 |  |  | 8
50.8 | 19 | 0.003351561121890986 | 0.9964720409243253 |  | 0.75 |  |  | 9
57.15000000000001 | 5 | 0.0008819897689186806 | 0.997354030693244 |  | 0.8 |  |  | 10
63.50000000000001 | 9 | 0.001587581584053625 | 0.9989416122772976 |  | 0.85 |  |  | 11
69.85000000000001 | 1 | 0.0001763979537837361 | 0.9991180102310814 |  | 0.9 |  |  | 12
76.2 | 2 | 0.0003527959075674722 | 0.9994708061386488 |  | 0.93 |  |  | 13
82.55 | 2 | 0.0003527959075674722 | 0.9998236020462162 |  | 0.95 |  |  | 14
88.89999999999999 | 0 | 0 | 0.9998236020462162 |  | 0.97 |  |  | 15
95.24999999999999 | 1 | 0.0001763979537837361 | 1 |  | 0.98 |  |  | 16
101.6 | 0 | 0 | 1 |  | 0.99 |  |  | 17
107.95 | 0 | 0 | 1 |  | 0.995 |  |  | 18
114.3 | 0 | 0 | 1 |  | 1 |  |  | 19
120.65 | 0 | 0 | 1 |  |  |  |  | 20
127 | 0 | 0 | 1 |  |  |  |  | 21
133.35 | 0 | 0 | 1 |  |  |  |  | 22
139.7 | 0 | 0 | 1 |  |  |  |  | 23
146.05 | 0 | 0 | 1 |  |  |  |  | 24
152.3999999999999 | 0 | 0 | 1 |  |  |  |  | 25
158.7499999999999 | 0 | 0 | 1 |  |  |  |  | 26
165.0999999999999 | 0 | 0 | 1 |  |  |  |  | 27
171.4499999999999 | 0 | 0 | 1 |  |  |  |  | 28
177.7999999999999 | 0 | 0 | 1 |  |  |  |  | 29
184.1499999999999 | 0 | 0 | 1 |  |  |  |  | 30
190.4999999999999 | 0 | 0 | 1 |  |  |  |  | 31
196.8499999999999 | 0 | 0 | 1 |  |  |  |  | 32
203.1999999999999 | 0 | 0 | 1 |  |  |  |  | 33
209.5499999999999 | 0 | 0 | 1 |  |  |  |  | 34
Totals | 5669 | 1 |  |  |  |  |  | 35
 |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  | 89
 |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  | 99
 |  |  |  |  |  |  |  | 100