To acquire the regression equation for chemical experiment data with Excel
Yan Min Zhao · 2004
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.