摘要
为了保证水文要素的计算精度并提高程序开发的效率，针对某流域1980—1985年降雨、径流资料，尝试分别采用Excel直接计算和在水文应用程序中嵌入Excel库函数的方法进行水文多元线性回归分析，并对两种计算方法进行了对比。结果表明，在水文应用程序中嵌入Excel库函数的计算方法，具有计算精度高、数据成果可靠、开发程序效率高、语法错误少等优点。
In order to guarantee calculation accuracy of hydrological factors and improve the efficiency of program develop ment, taking multiple linear regression analysis as example and selecting the precipitation and runoff data in a basin, the methods and procedures of direct calculation by Excel and hydrological application program embedded with Excel library functions are studied and the results are compared. The comparison results shows that the calculation by hydrological application program em bedded with Excel library functions has the advantages of high calculation accuracy, reliable calculation result, high development efficiency and less grammar mistakes etc.
出处
《人民长江》
北大核心
2014年第2期78-81,共4页
Yangtze River
关键词
Excel库函数
多元线性回归
水文应用程序
Excel library function
multiple linear regression
hydrological application program
