摘要
城市排水工程中编制暴雨强度公式时,须对九种历时暴雨强度的样本系列进行参数估计。由于暴雨资料参差不齐,如果分别单独估计每一种样本的参数,则不同历时样本的频率曲线可能会出现相交的不合理现象,此时必须对参数进行调整,使它们符合暴雨的一般规律。针对以上问题,基于Excel的内置函数、表格及图形处理功能,运用Excel的VBA编写简单的程序,实现了九种历时样本同时优选参数和参数调整的简单化及图形输出的规范化。当暴雨分布服从P-Ⅲ型分布时,实例分析结果表明了该方法的可行性。
The parameters of nine duration rainstorm intensity samples must be estimated when formulating the rainstorm intensity in urban drainage engineering. Since there are great differences among the rain series, the estimated parameters of the samples may be unreasonable when the parameters of each sample are calculated respectively. Under these circumstances, the parameters above have to be adjusted to accord with the regularity of the rainstorm. Aiming at the above problem, a simple optimal program is presented by using VBA of Excel, based on the form and graph function of Excel. It realizes the simplification of the optimal parameter estimation and adjustment of the nine rainstorm samples at a time and standardization of output graph. The result of the example has verified its feasibility when the storm being P- Ⅲ distribution.
出处
《农业与技术》
2005年第5期93-95,112,共4页
Agriculture and Technology
基金
福建省自然科学基金项目(D0210008)
关键词
Exel函数
暴雨强度
P-Ⅲ型分布
多样本
参数估计
Excel function
rainstorm intensity
Pearson Type Ⅲ distribution
multi- samples
parameter estimation
