电子表格在洪水频率分析中的应用——以淮河王家坝水文站年最大洪峰流量系列为例  

Application of Microsoft Excel Software to Flood Frequency Analysis for Wangjiaba Station in Huaihe River Basin

作　　者：郑希娟[1] 李岩[2] 

机构地区：[1]水利部东北勘测设计研究院,吉林长春130021 [2]水利部水文局,北京100053

出　　处：《水文》2002年第4期37-41,共5页Journal of China Hydrology

摘　　要：洪水频率(或重现期)是指一定时期内某种洪水出现的机率。目前我国对单个站点的洪水频率分析习惯于采用皮尔逊Ⅲ型分布。这种方法需要查表并用机率格纸进行手工适线,比较繁琐,而且受人为因素影响大。以淮河王家坝水文站年最大洪峰流量系列为例,应用电子表格,采用极值分布、皮尔逊Ⅲ型分布和三参数对数正态分布等多种洪水频率分析方法进行洪水频率计算并加以对比研究,得出该站的不同重现期的洪峰流量,以供广大水文工作者参考。Flood frequency(return period)is referring to recurrence probability of flood in certain period.At present,the Pearson TypeⅢdistribution is commonly adopted for flood frequency analysis in China.The method is required that data fitting need to be done manually.It is inconvenient for calculation and drawing.In this paper,flood magnitude corresponding to any return period was estimated and analysed using statistical distribution ways(e.g.Extreme Value(EV)distribution,Pearson TypeⅢdistribution and three-parameter lognormal distribution)for Wangjiaba station by Microsoft Excel software.It appears both practicable and feasible.

关 键 词：年最大洪峰流量 洪水频率分析 极值分布 皮尔逊Ⅲ型分布 三参数对数正态分布 电子表格 

分 类 号：P333.9[天文地球—水文科学]