Development of calculation software on hydrologic frequency based on EXCEL
Yanrong Huang · Xibei Nong-Lin Keji Daxue xuebao. Ziran kexue ban · 2006
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.