| 摘要: |
| 以Windows XP，Microsoft EXCEL和VBA为开发环境，研制了一套集绘图与计算于一体的水文频率分析软件，其中包含了常用的Г分布、极值分布、正态分布和对数正态分布4种频率分布线型。该软件采用矩法初估水文系列的均值和变差系数（Cv）。采用权函数法初估偏态系数（Cs），既可进行单水文要素的频率分析，也可进行多水文要素的频率曲线合成。 |
| 关键词: 水文频率计算 软件开发 频率曲线 参数估计 |
| DOI： |
| 分类号: |
| 基金项目:西北农林科技大学“水文水利计算多媒体教学课件开发”基金项目 |
|
| Development of calculation software on hydrologic frequency based on EXCEL |
|
|
| Abstract: |
| Taking WindowsXP,Microsoft EXCEL and VBA as tools,a series of software system on hydrologic frequency analysis which integrated the ability of graph and calculation was developed.And it contained four kinds of frequency distributions：Γ-distribution,extreme value distribution,normal distribution and logarithmic normal distribution.In its operation,one can get mean value and coefficient of variation of hydrologic series from the square methods,and coefficient of skewness from weight function method.The software can be used to analyse either single factor frequency or multi-factors frequency. |
| Key words: hydrology frequency calculation Software Development EXCEL VBA frequency distribution curve parameter estimation |
