Scribd
Upload
2 views3 pages

Rainfall Data Analysis and Formulas

no

Uploaded by

someshkumarnih
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
2 views3 pages

Rainfall Data Analysis and Formulas

no

Uploaded by

someshkumarnih
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Rainfall (mm) ln(Rainfall)

110 4.700480366
125 4.828313737
98 4.584967479
150 5.010635294
140 4.941642423
180 5.192956851
200 5.298317367
165 5.105945474
130 4.867534450
220 5.393627546
Quantity Value (Live Formula)
n (number of years) 10.000000000
Mean(ln) μ 4.992442099
StdDev(ln) σ #NAME?
z(50 yr) #NAME?
z(100 yr) #NAME?
y(50 yr) = μ + z50*σ #NAME?
y(100 yr) = μ + z100*σ #NAME?
X(50 yr) = EXP(y50) #NAME?
X(100 yr) = EXP(y100) #NAME?

T (years) z(T)
2 #NAME?
5 #NAME?
10 #NAME?
25 #NAME?
50 #NAME?
100 #NAME?
200 #NAME?

Legend
μ (Mean(ln)) Results!B2
σ (StdDev(ln)) Results!B3
z(T) = [Link](1-1/T)
y(T) = μ + z(T)*σ
X(T) = EXP(y(T))
Explanation / Cell Formula
Counts non-empty rainfall values in Data!A2:A...
AVERAGE of ln(Rainfall) from B2 down to last data row
Sample standard deviation of ln(Rainfall)
Standard normal deviate for exceedance probability 1/50
Standard normal deviate for exceedance probability 1/100
μ + z(50)*σ (uses cells B2=μ, B3=σ, B4=z50)
μ + z(100)*σ (uses cells B2=μ, B3=σ, B5=z100)
Back-transform to rainfall units: EXP(y50)
Back-transform to rainfall units: EXP(y100)

y(T) X(T)
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?

You might also like