最小二乘法处理环境监测数据及Excel建模探索

Dealing with the Data of Environmental Monitoring by Least Square Method and the Exploration of Excel Modeling

通过分析最小二乘法回归方程计算的理论基础,阐述了最小二乘法在环境监测工作中的应用,建立了Excel环境监测数据处理模板,为提升监测工作效率,提高监测结果准确度,缓解监测人员工作压力提供了技术支持.图3,表3,参4.

By analyzing the theoretic basis of least squares regression equation,this paper describes the application of the least square method in environmental monitoring work and establishes its Excel date processing template,which provides a technical support in enhancing the monitoring efficiency,improving the accuracy of the monitoring results and alleviating work stress of the monitor. 3figs.,3tabs.,4refs.