Excel绘制的海森几率格纸

1、 5/5Excel绘制的海森几率格纸 最大值 100最小值 频率至P=50%处水平距离X轴Y轴年份 洪峰流量Q （m3/s) 年份0.01-3.71901648500196015.519610.01-3.7190164850 10019616219670.02-3.5400837990.178933100196216.919700.02-3.5400837990.1789330196317.919640.03-3.4316144040.2874020196439.719790.03-3.4316144040.287402100196512.919820.04-3.3527947810.3662

2、22100196632.119660.04-3.3527947810.3662220196752.419730.05-3.2905267310.428490196813.219690.05-3.2905267310.42849100196931.319750.06-3.2388801180.480136100197047.619760.06-3.2388801180.4801360197127.319800.07-3.1946510540.5243650197212.719710.07-3.1946510540.52436510019733219770.08-3.1559067580.5631

3、110019741619810.08-3.1559067580.563110197529.519630.09-3.1213891490.5976270197628.119620.09-3.1213891490.597627100197725.919740.1-3.0902323060.62878410019788.4419600.1-3.0902323060.6287840197938.619680.12-3.0356723670.6833440198027.719650.12-3.0356723670.683344100198119.219720.14-2.9888822670.730134

4、1001982 34.7 19780.14-2.9888822670.7301340总计0.16-2.9478425520.7711740Q平均0.16-2.9478425520.7711741000.18-2.9112377260.807779100Cv 0.18-2.9112377260.8077790Cs 0.2-2.8781617390.84085500.2-2.8781617390.840855100皮尔逊曲线 0.3-2.7477813850.971235100P(%)10.3-2.7477813850.9712350 2.890.4-2.652069808 1.0669470Q

5、67.57579 0.4-2.652069808 1.0669471000.5-2.575829304 1.1431871000.5-2.575829304 1.1431870耿贝尔曲线 0.6-2.512144328 1.2068720P(%)1 0.6-2.512144328 1.206872100Sx 0.7-2.45726339 1.261753100pn 3.76750.7-2.45726339 1.2617530Q 78.48649 0.8-2.408915546 1.31010100.8-2.408915546 1.3101011000.9-2.365618127 1.35339

6、8100趋势线 Cv 0.4921450.9-2.365618127 1.3533980Cs 0.799499 1-2.326347874 1.39266901-2.326347874 1.392669100P(%) 0.010.11.2 -2.257129244 1.461887 100 5.5 4.24 13.42776海森机率格纸参数设置 纵坐标 机率格纸网线各个指定频率流量各个指定流量平均 1.2- 2.257129244 1.4618870Q10 3.4186.11073 1.4- 2.197286377 1.521730 1.4- 2.197286377 1.52173100Cv0

7、.5 1.6-2.144410621 1.574606100Cs 1.2 1.6-2.144410621 1.5746060 1.8- 2.096927429 1.6220890P(%)0.010.1 1.8-2.096927429 1.622089100 6.41 4.81 2-2.053748911 1.665268100Q117.308594.99062 2-2.053748911 1.6652680 3-1.880793608 1.8382230 3-1.880793608 1.838223100 4-1.750686071 1.96833100 4-1.750686071 1.968

8、330 5-1.644853627 2.0741630 5-1.644853627 2.074163100 6-1.554773595 2.164243100 Array 6-1.554773595 2.1642430 7-1.475791028 2.2432250 7-1.475791028 2.243225100 8-1.40507156 2.313945100 8-1.40507156 2.3139450 9-1.340755034 2.3782610 9-1.340755034 2.378261100 10-1.281551566 2.437465100 10-1.281551566

9、2.4374650 11-1.22652812 2.4924880 11-1.22652812 2.492488100 12-1.174986792 2.54403100 12-1.174986792 2.544030 13-1.126391129 2.5926250 13-1.126391129 2.592625100 14-1.080319341 2.638697100 14-1.080319341 2.6386970 15-1.036433389 2.6825830 15-1.036433389 2.682583100 16-0.994457883 2.724559100 16-0.99

10、4457883 2.7245590 17-0.954165253 2.7648510 17-0.954165253 2.764851100 18-0.915365088 2.803651100 18-0.915365088 2.8036510 19-0.877896295 2.841120 19-0.877896295 2.84112100 20-0.841621234 2.877395100 20-0.841621234 2.8773950 22-0.772193214 2.9468230 22-0.772193214 2.946823100 24-0.706302563 3.0127141

11、00 24-0.706302563 3.0127140 26-0.643345405 3.0756710 26-0.643345405 3.075671100 28-0.582841507 3.136175100 28-0.582841507 3.1361750 30-0.524400513 3.1946160 30-0.524400513 3.194616100 32-0.467698799 3.251318100 32-0.467698799 3.2513180 34-0.412463129 3.3065530 34-0.412463129 3.306553100 36-0.3584587

12、93 3.360558100 36-0.358458793 3.3605580 38-0.305480788 3.4135360 38-0.305480788 3.413536100 40-0.253347103 3.465669100 40-0.253347103 3.4656690 42-0.201893479 3.5171230 42-0.201893479 3.517123100 44-0.150969215 3.568047100 44-0.150969215 3.5680470 46-0.100433721 3.6185830 46-0.100433721 3.618583100

13、48-0.050153583 3.668863100 48-0.050153583 3.6688630 50-1.39214E-16 3.7190160 50-1.39214E-16 3.719016100 520.050153583 3.76917100 520.050153583 3.769170 540.100433721 3.819450 540.100433721 3.81945100 560.150969215 3.869986100 560.150969215 3.8699860 580.201893479 3.920910 580.201893479 3.92091100 60

14、0.253347103 3.972364100 600.253347103 3.9723640 620.305480788 4.0244970 620.305480788 4.024497100 640.358458793 4.077475100 640.358458793 4.0774750 660.412463129 4.131480 660.412463129 4.13148100 680.467698799 4.186715100 680.467698799 4.1867150 700.524400513 4.2434170 700.524400513 4.243417100 720.

15、582841507 4.301858100 720.582841507 4.3018580 740.643345405 4.3623620 740.643345405 4.362362100 760.706302563 4.425319100 760.706302563 4.4253190 780.772193214 4.491210 780.772193214 4.49121100 800.841621234 4.560638100 800.841621234 4.5606380 810.877896295 4.5969130 810.877896295 4.596913100 820.91

16、5365088 4.634382100 820.915365088 4.6343820 830.954165253 4.6731820 830.954165253 4.673182100 840.994457883 4.713474100 840.994457883 4.7134740 85 1.036433389 4.755450 85 1.036433389 4.75545100 86 1.080319341 4.799336100 86 1.080319341 4.7993360 87 1.126391129 4.8454080 87 1.126391129 4.845408100 88

17、 1.174986792 4.894003100 88 1.174986792 4.8940030 89 1.22652812 4.9455450 89 1.22652812 4.945545100 90 1.281551566 5.000568100 90 1.281551566 5.0005680 91 1.340755034 5.0597720 91 1.340755034 5.059772100 92 1.40507156 5.124088100 92 1.40507156 5.1240880 93 1.475791028 5.1948080 93 1.475791028 5.1948

18、08100 94 1.554773595 5.27379100 94 1.554773595 5.273790 95 1.644853627 5.363870 95 1.644853627 5.36387100 96 1.750686071 5.469703100 96 1.750686071 5.4697030 97 1.880793608 5.599810 97 1.880793608 5.59981100 98 2.053748911 5.772765100 98 2.053748911 5.7727650 98.2 2.096927429 5.8159440 98.2 2.096927

19、429 5.815944100 98.4 2.144410621 5.863427100 98.4 2.144410621 5.8634270 98.6 2.197286377 5.9163030 98.6 2.197286377 5.916303100 98.8 2.257129244 5.976146100 98.8 2.257129244 5.9761460 99 2.326347874 6.0453640 99 2.326347874 6.045364100 99.1 2.365618127 6.084635100 99.1 2.365618127 6.0846350 99.2 2.4

20、08915546 6.1279320 99.2 2.408915546 6.127932100 99.3 2.45726339 6.17628100 99.3 2.45726339 6.176280 99.4 2.512144328 6.2311610 99.4 2.512144328 6.231161100 99.5 2.575829304 6.294846100 99.5 2.575829304 6.2948460 99.6 2.652069808 6.3710860 99.6 2.652069808 6.371086100 99.7 2.747781385 6.466798100 99.

21、7 2.747781385 6.4667980 99.8 2.878161739 6.5971780 99.8 2.878161739 6.597178100 99.82 2.911237726 6.630254100 99.82 2.911237726 6.6302540 99.84 2.947842552 6.6668590 99.84 2.947842552 6.666859100 99.86 2.988882267 6.707899100 99.86 2.988882267 6.7078990 99.88 3.035672367 6.7546890 99.88 3.035672367

22、6.754689100 99.9 3.090232306 6.809249100 99.9 3.090232306 6.8092490 99.91 3.121389149 6.8404060 99.91 3.121389149 6.840406100 99.92 3.155906758 6.874923100 99.92 3.155906758 6.8749230 99.93 3.194651054 6.9136680 99.93 3.194651054 6.913668100 99.94 3.238880118 6.957897100 99.94 3.238880118 6.9578970 99.95 3.2905267317.0095430 99.95 3.2905267317.009543100 99.96 3.3527947817.071811100 99.96 3.3527