drainase (excel gumbel)

5 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.51195712.008.426.345.378595041320.366514.15196641992195815.924.436.75459.265.572.572.772.772.7219586.0015.923.70.583140495951.449922.1647083006319628.817.622.430.333.237.240.843.94444319624.008.823.640.1495041322102.256228.12804019874196314.921.630.237.141.844.247474747419633.0014.919.60.0558677686202.460629.6397666528519658.312.521.431.840.140.240.340.340.340.3519652.408.315.946.7358677686253.198535.097217487619669.411.214.92124.827.131.836.438.538.5619662.009.414.932.9058677686503.901440.2958110516719677.61010.41118.922.327.428.429.630.5719671.717.69.456.79677685951004.600145.46334174398197419.626.430.54458.67178.178.178.578.3819741.5019.68.819.92404958689197523.736.443.872.38093.4103.2104.6105.7105.7919751.3323.78.473.335867768610197626.32722.559.762.86964.764.967.467.51019761.2026.38.3124.626776859511197723.63039.54347.759.999119.5149.8246.21119771.0923.67.671.6331404959mmx15.1363636364n11Sx166.5Periode ulang51015204560120180360720menit(xi-x)2512.1254545455214.151966419920.538244722126.342082011537.732131270744.879521392950.228886609856.458122428259.236581808262.778601275168.1528303167sx7.1562941146522.164708300629.846640561837.987168983957.227970895464.951587339574.043002255585.436096455891.4977934464102.1715506391135.8746662455Yn0.49961028.128040198736.774238462546.653805153371.737381537279.889843544891.7662083152107.0024066444115.5075912532131.4890096313186.2753643343Sn0.96762029.639766652838.530409876348.850829130775.415570220383.676746147396.259105895112.4695451817121.5941628416138.9210927492199.05212570022535.09721748744.870326149256.782257667788.694119287297.3477609728112.4788178527132.2063432571143.5671627196165.7514945728245.17723436915040.295811051650.90952813964.3374834688101.3428415248110.370333572127.9291980331151.0069874734164.4979414352191.3092794241289.114541434210045.463341743956.912644414971.8475649416113.9159845428123.3150931039143.2872584001169.6952932266185.3036536113216.7143502388332.789312306951015204560120180360720menit169.8235970388123.2294683325105.3683280459113.196393812159.839361857250.228886609828.229061214119.745527269410.46310021255.6794025264265.976499607179.079843371151.9486759357171.683912686186.602116452774.043002255542.718048227930.499264482117.028591773211.3228888538337.5364823841220.6454307751186.6152206131215.2121446117106.519791393191.766208315253.501203322238.502530417721.914834938515.5229470279355.6771998337231.1824592575195.4033165229226.246710661111.56899486396.25910589556.234772590840.531387613923.153515458216.5876771417421.166609844269.2219568954227.1290306708266.0823578616129.7970146305112.478817852766.103171628547.855720906527.625249095520.4314361974483.5497326197305.4571688343257.3499338752304.0285245744147.1604447626127.929198033175.503493736754.832647145131.88487990424.0928784528545.5601009272341.4758664892287.3902597665341.7479536285164.4201241386143.287258400184.847646613361.767884537136.119058373127.7324426922

10 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.5119571221.436.40.079421487620.366520.53824472212195815.924.436.75459.265.572.572.772.772.721958624.4307.388512396751.449929.8466405618319628.817.622.430.333.237.240.843.9444431962417.62716.6612396694102.256236.77423846254196314.921.630.237.141.844.24747474741963321.626.40.0066942149202.460638.5304098763519658.312.521.431.840.140.240.340.340.340.3519652412.524.484.305785124253.198544.8703261492619669.411.214.92124.827.131.836.438.538.561966211.221.6109.8685123967503.901450.909528139719677.61010.41118.922.327.428.429.630.5719671.711021.4136.46487603311004.600156.91264441498197419.626.430.54458.67178.178.178.578.3819741.526.417.622.26123966949197523.736.443.872.38093.4103.2104.6105.7105.7919751.3336.412.5216.624876033110197626.32722.559.762.86964.764.967.467.51019761.22711.228.283057851211197723.63039.54347.759.999119.5149.8246.21119771.09301069.1921487603mmx21.6818181818n11Sx238.5Periode ulang51015204560120180360720menit(xi-x)2691.13636363642=sx8.31346115435Yn0.499610Sn0.9676202550100

15 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.5119571233.243.829.455289256220.366526.34208201152195815.924.436.75459.265.572.572.772.772.721958636.739.579.696198347151.449937.9871689839319628.817.622.430.333.237.240.843.9444431962422.436.728.8661983471102.256246.65380515334196314.921.630.237.141.844.24747474741963330.233.25.8916528926202.460648.8508291307519658.312.521.431.840.140.240.340.340.340.3519652421.430.540.6116528926253.198556.7822576677619669.411.214.92124.827.131.836.438.538.561966214.930.2165.707107438503.901464.3374834688719677.61010.41118.922.327.428.429.630.5719671.7110.422.5301.81165289261004.600171.84756494168197419.626.430.54458.67178.178.178.578.3819741.530.522.47.43801652899197523.736.443.872.38093.4103.2104.6105.7105.7919751.3343.821.4256.873471074410197626.32722.559.762.86964.764.967.467.51019761.222.514.927.801652892611197723.63039.54347.759.999119.5149.8246.21119771.0939.510.4137.5289256198mmx27.7727272727n11Sx305.5Periode ulang51015204560120180360720menit(xi-x)21081.68181818182=sx10.40039334925Yn0.499610Sn0.9676202550100

20 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.5119571237.272.38.568925619820.366537.73213127072195815.924.436.75459.265.572.572.772.772.72195865459.7192.452561983551.449957.2279708954319628.817.622.430.333.237.240.843.9444431962430.35496.5752892562102.256271.73738153724196314.921.630.237.141.844.24747474741963337.1449.1643801653202.460675.4155702203519658.312.521.431.840.140.240.340.340.340.3519652431.84369.3434710744253.198588.6941192872619669.411.214.92124.827.131.836.438.538.56196622137.2365.8525619835503.9014101.3428415248719677.61010.41118.922.327.428.429.630.5719671.711137.1848.39801652891004.6001113.91598454288197419.626.430.54458.67178.178.178.578.3819741.54431.814.99801652899197523.736.443.872.38093.4103.2104.6105.7105.7919751.3372.330.31035.084380165310197626.32722.559.762.86964.764.967.467.51019761.259.721383.091652892611197723.63039.54347.759.999119.5149.8246.21119771.0943118.2525619835mmx40.1272727273n11Sx441.4Periode ulang51015204560120180360720menit(xi-x)23031.78181818182=sx17.41201257235Yn0.499610Sn0.9676202550100

45 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.5119571253.78040.380247933920.366544.87952139292195815.924.436.75459.265.572.572.772.772.721958659.262.8140.530247933951.449964.9515873395319628.817.622.430.333.237.240.843.9444431962433.259.2200.0938842975102.256279.88984354484196314.921.630.237.141.844.24747474741963341.858.630.7520661157202.460683.6767461473519658.312.521.431.840.140.240.340.340.340.3519652440.153.752.4966115702253.198597.3477609728619669.411.214.92124.827.131.836.438.538.561966224.847.7508.2975206612503.9014110.370333572719677.61010.41118.922.327.428.429.630.5719671.7118.941.8809.14388429751004.6001123.31509310398197419.626.430.54458.67178.178.178.578.3819741.558.640.1126.66479338849197523.736.443.872.38093.4103.2104.6105.7105.7919751.338033.21066.31933884310197626.32722.559.762.86964.764.967.467.51019761.262.824.8238.842975206611197723.63039.54347.759.999119.5149.8246.21119771.0947.718.90.1257024793mmx47.3454545455n11Sx520.8Periode ulang51015204560120180360720menit(xi-x)23213.64727272732=sx17.92664852325Yn0.499610Sn0.9676202550100

60 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.5119571254.993.43.046611570220.366550.22888660982195815.924.436.75459.265.572.572.772.772.721958665.571152.410247933951.449974.0430022555319628.817.622.430.333.237.240.843.9444431962437.269254.5475206612102.256291.76620831524196314.921.630.237.141.844.24747474741963344.265.580.1838842975202.460696.259105895519658.312.521.431.840.140.240.340.340.340.3519652440.259.9167.8202479339253.1985112.4788178527619669.411.214.92124.827.131.836.438.538.561966227.154.9678.839338843503.9014127.9291980331719677.61010.41118.922.327.428.429.630.5719671.7122.344.2952.00297520661004.6001143.28725840018197419.626.430.54458.67178.178.178.578.3819741.57140.2318.46024793399197523.736.443.872.38093.4103.2104.6105.7105.7919751.3393.437.21619.696611570210197626.32722.559.762.86964.764.967.467.51019761.26927.1251.078429752111197723.63039.54347.759.999119.5149.8246.21119771.0959.922.345.5011570248mmx53.1545454545n11Sx584.7Periode ulang51015204560120180360720menit(xi-x)24523.58727272732=sx21.2687265085Yn0.499610Sn0.9676202550100

120 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.5119571255.4103.221.327603305820.366556.45812242822195815.924.436.75459.265.572.572.772.772.721958672.599155.79578512451.449985.4360964558319628.817.622.430.333.237.240.843.9444431962440.878.1369.3385123967102.2562107.00240664444196314.921.630.237.141.844.2474747474196334772.5169.4730578512202.4606112.4695451817519658.312.521.431.840.140.240.340.340.340.3519652440.364.7388.8066942149253.1985132.2063432571619669.411.214.92124.827.131.836.438.538.561966231.855.4796.265785124503.9014151.0069874734719677.61010.41118.922.327.428.429.630.5719671.7127.4471063.9457851241004.6001169.69529322668197419.626.430.54458.67178.178.178.578.3819741.578.140.8326.95214876039197523.736.443.872.38093.4103.2104.6105.7105.7919751.33103.240.31864.669421487610197626.32722.559.762.86964.764.967.467.51019761.264.731.821.919421487611197723.63039.54347.759.999119.5149.8246.21119771.099927.41519.5821487603mmx60.0181818182n11Sx660.2Periode ulang51015204560120180360720menit(xi-x)26698.07636363642=sx25.88064211655Yn0.499610Sn0.9676202550100

180 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.5119571259.4119.514.4420.366559.23658180822195815.924.436.75459.265.572.572.772.772.721958672.7104.690.2551.449991.4977934464319628.817.622.430.333.237.240.843.9444431962443.978.1372.49102.2562115.50759125324196314.921.630.237.141.844.2474747474196334772.7262.44202.4606121.5941628416519658.312.521.431.840.140.240.340.340.340.3519652440.364.9524.41253.1985143.5671627196619669.411.214.92124.827.131.836.438.538.561966236.459.4718.24503.9014164.4979414352719677.61010.41118.922.327.428.429.630.5719671.7128.4471211.041004.6001185.30365361138197419.626.430.54458.67178.178.178.578.3819741.578.143.9222.019197523.736.443.872.38093.4103.2104.6105.7105.7919751.33104.640.31713.9610197626.32722.559.762.86964.764.967.467.51019761.264.936.42.8911197723.63039.54347.759.999119.5149.8246.21119771.09119.528.43169.69mmx63.2n11Sx695.2Periode ulang51015204560120180360720menit(xi-x)28301.862=sx28.81294847815Yn0.499610Sn0.9676202550100

360 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.5119571270.3149.87.192148760320.366562.77860127512195815.924.436.75459.265.572.572.772.772.721958672.7105.725.824876033151.4499102.1715506391319628.817.622.430.333.237.240.843.944443196244478.5557.8185123967102.2562131.48900963134196314.921.630.237.141.844.2474747474196334772.7425.1094214876202.4606138.9210927492519658.312.521.431.840.140.240.340.340.340.3519652440.370.3746.2830578512253.1985165.7514945728619669.411.214.92124.827.131.836.438.538.561966238.567.4847.8685123967503.9014191.3092794241719677.61010.41118.922.327.428.429.630.5719671.7129.6471445.38214876031004.6001216.71435023888197419.626.430.54458.67178.178.178.578.3819741.578.544118.41396694219197523.736.443.872.38093.4103.2104.6105.7105.7919751.33105.740.31450.224876033110197626.32722.559.762.86964.764.967.467.51019761.267.438.50.047603305811197723.63039.54347.759.999119.5149.8246.21119771.09149.829.66753.8512396694mmx67.6181818182n11Sx743.8Periode ulang51015204560120180360720menit(xi-x)212378.01636363642=sx35.182405215Yn0.499610Sn0.9676202550100

720 menitanData (tahun)tahun51015204560120180360720menitData (tahun)tahuntrxXurut(x1-x)2TrYtXtrpeluang119578.421.433.237.253.754.955.459.470.370.5119571270.5246.235.673471074420.366568.15283031672195815.924.436.75459.265.572.572.772.772.721958672.7105.714.233471074451.4499135.8746662455319628.817.622.430.333.237.240.843.944443196244478.31054.4780165289102.2562186.27536433434196314.921.630.237.141.844.2474747474196334772.7868.6416528926202.4606199.0521257002519658.312.521.431.840.140.240.340.340.340.3519652440.370.51308.4661983471253.1985245.1772343691619669.411.214.92124.827.131.836.438.538.561966238.567.51441.9280165289503.9014289.1145414342719677.61010.41118.922.327.428.429.630.5719671.7130.5472113.49165289261004.6001332.78931230698197419.626.430.54458.67178.178.178.578.3819741.578.3443.33892561989197523.736.443.872.38093.4103.2104.6105.7105.7919751.33105.740.3854.233471074410197626.32722.559.762.86964.764.967.467.51019761.267.538.580.509834710711197723.63039.54347.759.999119.5149.8246.21119771.09246.230.528807.347107438mmx76.4727272727n11Sx841.2Periode ulang51015204560120180360720menit(xi-x)236582.34181818182=sx60.48333805125Yn0.499610Sn0.9676202550100

Sheet2Data (tahun)tahuntrxXurut(x1-x)2119571221.436.4457.9621958624.430595.3631962417.627309.7641963321.626.4466.56519652412.524.4156.2561966211.221.6125.44719671.711021.4100819741.526.417.6696.96919751.3336.412.51324.961019761.22711.27291119771.093010900x21.6818181818n11Sx238.5(xi-x)25862.25sx8.3134611543Yn0.4996Sn0.9676

Sheet3