Excel绘制的海森几率格纸

1、876543210020406080100120Series1876543210020406080100120Series1海森机率格纸参数设置纵坐标最大值100最小值0机率格纸网线频率至P=50%处水平距离X轴Y轴年份洪峰流量Q（m3/s)年份0.01 -3.71901648500196015.519610.01 -3.719016485010019616219670.02 -3.540083799 0.178933100196216.919700.02 -3.540083799 0.1789330196317.919640.03 -3.431614404 0.2874020196439.7

2、19790.03 -3.431614404 0.287402100196512.919820.04 -3.352794781 0.366222100196632.119660.04 -3.352794781 0.3662220196752.419730.05 -3.2905267310.428490196813.219690.05 -3.2905267310.42849100196931.319750.06 -3.238880118 0.480136100197047.619760.06 -3.238880118 0.4801360197127.319800.07 -3.194651054 0

3、.5243650197212.719710.07 -3.194651054 0.52436510019733219770.08 -3.1559067580.5631110019741619810.08 -3.1559067580.563110197529.519630.09 -3.121389149 0.5976270197628.119620.09 -3.121389149 0.597627100197725.919740.1 -3.090232306 0.62878410019788.4419600.1 -3.090232306 0.6287840197938.619680.12 -3.0

4、35672367 0.6833440198027.719650.12 -3.035672367 0.683344100198119.219720.14 -2.988882267 0.730134100198234.719780.14 -2.988882267 0.7301340总计0.16 -2.947842552 0.7711740Q平均0.16 -2.947842552 0.7711741000.18 -2.911237726 0.807779100Cv0.18 -2.911237726 0.8077790Cs0.2 -2.878161739 0.84085500.2 -2.8781617

5、39 0.840855100皮尔逊曲线各个指定频率流量值0.3 -2.747781385 0.971235100P(%)10.3 -2.747781385 0.97123502.890.4 -2.652069808 1.0669470Q67.575790.4 -2.652069808 1.0669471000.5 -2.575829304 1.1431871000.5 -2.575829304 1.1431870耿贝尔曲线各个指定流量平均值0.6 -2.512144328 1.2068720P(%)10.6 -2.512144328 1.206872100Sx13.427763980.7-2.

6、45726339 1.261753100pn3.76750.7-2.45726339 1.2617530Q78.486490.8 -2.408915546 1.31010100.8 -2.408915546 1.3101011000.9 -2.365618127 1.353398100趋势线Cv0.4921450.9 -2.365618127 1.3533980Cs0.7994991 -2.326347874 1.39266901 -2.326347874 1.392669100P(%)0.010.11.2 -2.257129244 1.4618871005.54.241.2 -2.25712

7、9244 1.4618870Q103.41 86.110731.4 -2.1972863771.5217301.4 -2.1972863771.52173100Cv0.51.6 -2.144410621 1.574606100Cs1.21.6 -2.144410621 1.57460601.8 -2.096927429 1.6220890P(%)0.010.11.8 -2.096927429 1.6220891006.414.812 -2.053748911 1.665268100Q117.3085 94.990622 -2.053748911 1.66526803 -1.880793608

8、1.83822303 -1.880793608 1.8382231004 -1.7506860711.968331004 -1.7506860711.9683305 -1.644853627 2.07416305 -1.644853627 2.0741631006 -1.554773595 2.1642431006 -1.554773595 2.16424307 -1.475791028 2.24322507 -1.475791028 2.2432251008-1.40507156 2.3139451008-1.40507156 2.31394509 -1.340755034 2.378261

9、09 -1.340755034 2.37826110010 -1.281551566 2.43746510010 -1.281551566 2.437465011-1.22652812 2.492488011-1.22652812 2.49248810012 -1.1749867922.5440310012 -1.1749867922.54403013 -1.126391129 2.592625013 -1.126391129 2.59262510014 -1.080319341 2.63869710014 -1.080319341 2.638697015 -1.036433389 2.682

10、583015 -1.036433389 2.68258310016 -0.994457883 2.72455910016 -0.994457883 2.724559017 -0.954165253 2.764851017 -0.954165253 2.76485110018 -0.915365088 2.80365110018 -0.915365088 2.803651019 -0.8778962952.84112019 -0.8778962952.8411210020 -0.841621234 2.87739510020 -0.841621234 2.877395022 -0.7721932

11、14 2.946823022 -0.772193214 2.94682310024 -0.706302563 3.01271410024 -0.706302563 3.012714026 -0.643345405 3.075671026 -0.643345405 3.07567110028 -0.582841507 3-0.582841507 3.13617500.010.050.20.51251020508090959899 99.5 99.899.95 99.9902040608010012014030 -0.524400513 3.194616030 -0.52

12、4400513 3.19461610032 -0.467698799 3.25131810032 -0.467698799 3.251318034 -0.412463129 3.306553034 -0.412463129 3.30655310036 -0.358458793 3.36055810036 -0.358458793 3.360558038 -0.305480788 3.413536038 -0.305480788 3.41353610040 -0.253347103 3.46566910040 -0.253347103 3.465669042 -0.201893479 3.517

13、123042 -0.201893479 3.51712310044 -0.150969215 3.56804710044 -0.150969215 3.568047046 -0.100433721 3.618583046 -0.100433721 3.61858310048 -0.050153583 3.66886310048 -0.050153583 3.668863050 -1.39214E-16 3.719016050 -1.39214E-16 3.719016100520.0501535833.76917100520.0501535833.769170540.1004337213.81

14、9450540.1004337213.81945100560.150969215 3.869986100560.150969215 3.8699860580.2018934793.920910580.2018934793.92091100600.253347103 3.972364100600.253347103 3.9723640620.305480788 4.0244970620.305480788 4.024497100640.358458793 4.077475100640.358458793 4.0774750660.4124631294.131480660.4124631294.1

15、3148100680.467698799 4.186715100680.467698799 4.1867150700.524400513 4.2434170700.524400513 4.243417100720.582841507 4.301858100720.582841507 4.3018580740.643345405 4.3623620740.643345405 4.362362100760.706302563 4.425319100760.706302563 4.4253190780.7721932144.491210780.7721932144.49121100800.84162

16、1234 4.560638100800.841621234 4.5606380810.877896295 4.5969130810.877896295 4.596913100820.915365088 4.634382100820.915365088 4.6343820830.954165253 4.6731820830.954165253 4.673182100840.994457883 4.713474100840.994457883 4.7134740851.0364333894.755450851.0364333894.75545100861.080319341 4.799336100

17、861.080319341 4.7993360871.126391129 4.8454080871.126391129 4.845408100881.174986792 4.894003100881.174986792 4.8940030891.22652812 4.9455450891.22652812 4.945545100901.281551566 5.000568100901.281551566 5.0005680911.340755034 5.0597720911.340755034 5.059772100921.40507156 5.124088100921.40507156 5.

18、1240880931.475791028 5.1948080931.475791028 5.194808100941.5547735955.27379100941.5547735955.273790951.6448536275.363870951.6448536275.36387100961.750686071 5.469703100961.750686071 5.4697030971.8807936085.599810971.8807936085.59981100982.053748911 5.772765100982.053748911 5.772765098.22.096927429 5

19、.815944098.22.096927429 5.81594410098.42.144410621 5.86342710098.42.144410621 5.863427098.62.197286377 5.916303098.62.197286377 5.91630310098.82.257129244 5.97614610098.82.257129244 5.9761460992.326347874 6.0453640992.326347874 6.04536410099.12.365618127 6.08463510099.12.365618127 6.084635099.22.408

20、915546 6.127932099.22.408915546 6.12793210099.32.457263396.1762810099.32.457263396.17628099.42.512144328 6.231161099.42.512144328 6.23116110099.52.575829304 6.29484610099.52.575829304 6.294846099.62.652069808 6.371086099.62.652069808 6.37108610099.72.747781385 6.46679810099.72.747781385 6.466798099.

21、82.878161739 6.597178099.82.878161739 6.59717810099.822.911237726 6.63025410099.822.911237726 6.630254099.842.947842552 6.666859099.842.947842552 6.66685910099.862.988882267 6.70789910099.862.988882267 6.707899099.883.035672367 6.754689099.883.035672367 6.75468910099.93.090232306 6.80924910099.93.09

22、0232306 6.809249099.913.121389149 6.840406099.913.121389149 6.84040610099.923.155906758 6.87492310099.923.155906758 6.874923099.933.194651054 6.913668099.933.194651054 6.91366810099.943.238880118 6.95789710099.943.238880118 6.957897099.953.290526731 7.009543099.953.290526731 7.00954310099.963.352794

23、781 7.07181110099.963.352794781 7.071811099.973.431614404 7.150631099.973.431614404 7983.5400837997.259110099.983.5400837997.2591099.993.719016485 7.438033099.993.719016485 7.4380331004.166667 -1.731664396 1.987352628.333333 -1.382994127 2.33602252.412.5-1.15034938 2.56866747.616.66667

24、-0.967421566 2.75159539.720.83333 -0.812217801 2.90679938.625-0.67448975 3.04452734.729.16667 -0.548522283 3.17049432.133.33333 -0.430727299 3.2882893237.5 -0.318639364 3.40037731.341.66667 -0.210428394 3.50858829.545.83333 -0.104633456 3.61438328.150 -1.39214E-16 3.71901627.754.166670.1046334563.82

25、36527.358.333330.210428394 3.92944525.962.50.318639364 4.03765619.266.666670.430727299 4.14974417.970.833330.548522283 4.26753916.9750.67448975 4.3935061679.166670.812217801 4.53123415.583.333330.967421566 4.68643813.287.51.15034938 4.86936612.991.666671.382994127 5.10201112.795.833331.731664396 5.4

26、506818.440.01-3.7190164850103.410.1-3.090232306 0.628784 86.110730.2-2.878161739 0.84085580.75620.33-2.716380583 1.002636 76.637340.5-2.575829304 1.143187 73.342241-2.326347874 1.392669 67.575822-2.053748911 1.665268 61.534825-1.644853627 2.074163 53.1597810-1.281551566 2.43746546.29520-0.841621234

27、2.877395 38.6064550-1.39214E-16 3.719016 26.11255750.67448975 4.393506 17.87481901.281551566 5.00056811.8338951.6448536275.36387 8.950596992.326347874 6.045364 4.0079540.01-3.7190164850 117.30850.1-3.090232306 0.628784 94.990620.2-2.878161739 0.840855 88.155760.33-2.716380583 1.002636 82.994740.5-2.

28、575829304 1.143187 78.949621-2.326347874 1.392669 71.835782-2.053748911 1.665268 64.442975-1.644853627 2.07416354.539410-1.281551566 2.437465 46.5886420-0.841621234 2.877395 38.0799450-1.39214E-16 3.719016 25.24714750.67448975 4.393506 17.57536901.281551566 5.00056812.8328951.6448536275.36387 10.601

29、01992.326347874 6.045364 7.671783洪峰流量Q（m3/s)累计频率P（%）Ki(Ki-1)2 (Ki-1)3Qi2621 4.1666672.22243 1.4943351.83384452.42 8.333333 1.878312 0.7714320.682745.7647.6312.5 1.706253 0.4987930.352265.7639.74 16.66667 1.4230720.178990.081576.0938.65 20.83333 1.383642 0.1471810.061489.9634.7625 1.2438440.059460.011204.0932.17 29.16667 1.150645 0.0226940.001030.41328 33.33333 1.147061 0.0216270.00102431.3937.5 1.121969 0.0148760.00979.6929.510 41.66667 1.0574470.00330.00870.2528.111 45.83333 1.007263 5.27E-050.00789.6127.71250 0.992924 5.01E-050.00767.2927.313 54.16667 0.978586 0.000459