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

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

作　　者：郝敬雷 姜永明[1] 马彦金 张龙[1] 刘福领 万人杰[1] 

机构地区：[1]海洋石油工程股份有限公司,天津300452

出　　处：《当代化工》2014年第4期636-638,共3页Contemporary Chemical Industry

摘　　要：基于最小二乘法原理,利用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.

关 键 词：离心泵 性能曲线 最小二乘法 拟合 LINEST函数 

分 类 号：TQ056[化学工程]