最小二乘法在水轮机曲线插值中的运用

摘要

∶采用最小二乘法对水轮机中某活动导叶和水力矩关系曲线进行插值，通过EXCEL中的MINVERSE和MMULT两个函数进行求解，该插值方法具有更加简单、易操作的特点，满足在相关水轮机计算中的工程需要。%The paper interpolates the relationship curve of turbine guide vane and hydraulic torque through least square method and solves the matrix results by using MINVERSE and MMULT functions in EXCEL. This method is easily operated,whose results meet the requirements of calculations of turbine.