用Excel求取化工数据组回归方程

To acquire the regression equation for chemical experiment data with Excel

在化工问题研究中,经常需要把实验数据整理为方程式,以定量描述过程或现象自变量与因变量之间的关系,回归分析是求取这种关系方程的主要数理统计方法。本文介绍了用 Excel 软件求取回归方程的几种方法,通过举例对趋势线预测法、多元线性回归法、非线性回归法与误差判定的方法进行了介绍,说明通过 Excel 可实现大部分实验数据的拟合,达到节约数据处理时间,提高回归方程精度的目的。

It's often necessary to put the experimental data into equation in the research of chemical issues so as to describe the relationbetween independent variable and dependent variable in the procedure or phenomenon quantitatively.Regression analysis is one of themajor mathematical statistics to acquire such relation equation.Several methods to acquire the regression equations by means of Excelare listed in this paper.By way of examples the paper gives a brief introduction to the methods of trend line forecast method,multivari-ate linear regression and nonlinear regression,showing that by Excel the fit of most experimental data can be realized,so that the timespent on experimental data procession can be economized and the precision of the regression equations can be improved.