摘要
基于最小二乘法原理,利用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 ±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.
出处
《当代化工》
CAS
2014年第4期636-638,共3页
Contemporary Chemical Industry