Excel Curah Hujan Dan Idf.xlsx

Metode Gumbel

periode 2 th

Log pearson 3

X

(X-Xr)^2 320.41 34.81 102.01 259.21 778.41 82.81 37.21 681.21 26.01 436.81 2758.9

X

X-Xr 95 83 67 61 105 68 71 51 72 98

17.9 5.9 -10.1 -16.1 27.9 -9.1 -6.1 -26.1 -5.1 20.9

X rata2 77.1 periode 2 jumlah dat 10 S 17.50841 K -0.16436 X

74.2224

95 83 67 61 105 68 71 51 72 98

-2.44949 -0.78009 0.5772 -0.36651

ln X Ln x - Ln Xr 4.553877 0.2320878 4.418841 0.0970515 4.204693 -0.1170965 4.110874 -0.2109153 4.65396 0.3321712 4.219508 -0.1022814 4.26268 -0.0591092 3.931826 -0.3899635 4.276666 -0.045123 4.584967 0.2631784

Ln Xr 4.321789 periode 2 jumlh data 10 S 0.228314 Cs -0.03926

IDF curve (Ln x - Ln Xr)^2 (Ln x - Ln Xr)^3 0.0538647362 0.0125013469 0.0094189923 0.0009141273 0.01371159 -0.001605579 0.0444852429 -0.0093826161 0.1103377297 0.03665102 0.0104614867 -0.0010700156 0.003493902 -0.0002065219 0.1520715172 -0.0593023383 0.0020360847 -9.187424E-05 0.0692628513 0.0182284839 0.4691441323 -0.0033639671

X t

99.9524 jam a 10 0.166667 20 0.333333 30 0.5 60 1120 2180 3240 4-

b 73.8 228 524 -

R 254 20.84034 636 30.96552 1272 38.17556 52.34604 66.40679 74.39048 79.63839

I 125.042 92.89655 76.35113 52.34604 33.20339 24.79683 19.9096