LINEST函数在离心泵流量-扬程性能曲线拟合中的应用

Application of LINEST Function in the Fitting of Centrifugal Pump Flow-Head Performance Curve

基于最小二乘法原理,利用EXCEL软件中的LINEST多元线性回归函数,对泵产品样本上给定的离心泵流量-扬程(Q-H)性能数据进行了拟合。结果表明:由回归方程所得到的扬程拟合值与实际泵样本值的误差均在±0.5%以内,且在利用LINEST函数对离心泵Q-H性能曲线进行拟合时,操作上简单、便捷,还能对回归效果进行显著性检验。

Based on least square method, LINEST multiple linear regression function in Excellsoftware was used into the fitting of centrifugal pump Q-H performance data given by the pump sample. The results show that,the errors between the fitted values obtained from the regression equation and the actual pump sample value are within ＆#177;0.5%,and when LINEST function is used into the fitting of centrifugal pump Q-H performance curve, the operation is simple and convenient ,and the method can also be used for significant test of the regression effect.