人民长江
人民長江
인민장강
YANGTZE RIVER
2015年
15期
10-13,25
,共5页
许定雄%黄清涛%王正勇%王春华
許定雄%黃清濤%王正勇%王春華
허정웅%황청도%왕정용%왕춘화
回归模型%曲线拟合%Excel%水文要素
迴歸模型%麯線擬閤%Excel%水文要素
회귀모형%곡선의합%Excel%수문요소
regression model%curve fitting%Excel%hydrological essential factor
为了增强水文观测资料的代表性,需要对其进行插补。基于已有历史实测水文资料,通过Excel内置图形函数及“规划求解”功能,分别建立了年降水量多元线性回归方程、天然河道水位流量、水库(电站)堰闸出流关系、水电站出力关系等函数模型。对模型中的关键参数进行率定,得到能够精确表达以上函数关系的拟合方程。在实际应用中,应注意将函数拟合与变量的物理意义相结合,并尽量扩大样本容量,以提高水文资料精度并实现水文信息化。
為瞭增彊水文觀測資料的代錶性,需要對其進行插補。基于已有歷史實測水文資料,通過Excel內置圖形函數及“規劃求解”功能,分彆建立瞭年降水量多元線性迴歸方程、天然河道水位流量、水庫(電站)堰閘齣流關繫、水電站齣力關繫等函數模型。對模型中的關鍵參數進行率定,得到能夠精確錶達以上函數關繫的擬閤方程。在實際應用中,應註意將函數擬閤與變量的物理意義相結閤,併儘量擴大樣本容量,以提高水文資料精度併實現水文信息化。
위료증강수문관측자료적대표성,수요대기진행삽보。기우이유역사실측수문자료,통과Excel내치도형함수급“규화구해”공능,분별건립료년강수량다원선성회귀방정、천연하도수위류량、수고(전참)언갑출류관계、수전참출력관계등함수모형。대모형중적관건삼수진행솔정,득도능구정학표체이상함수관계적의합방정。재실제응용중,응주의장함수의합여변량적물리의의상결합,병진량확대양본용량,이제고수문자료정도병실현수문신식화。
To improve the representativeness of hydrological measuring data by interpolation, on the basis of the existed histor-ic hydrological measuring data, the multiple linear regression equation of annual precipitation, the function models including the relationship between flow and level in natural river channel, reservoir sluice discharge and openness, relationship of output of power plants, are established through the graphic function and planning solution function of Excel. The key parameters of the models are calibrated and the fitting formula that can express the above relations accurately is obtained. In practical application, the fitting functions and the physical meaning of the variables should be combined and the sample number should be enlarged, which is helpful in improving the accuracy of the hydrological data and realizing the informatization of hydrology.