实验数据处理的excel函数解法研究

回归分析是一类数学模型,其研究对象是一个随机变量同一个或多个非随机变量的关系问题,在提出一元和多元线性回归的基础上,通过比较最小二乘法解法和Excel函数解法,指出Excel函数解法可以简化复杂的数学运算,并配以图表,给求解过程带来方便。

The Applied Research of Excel Functions in Experimental Data Processing

Regression analysis is a process of constructing mathematical model which focuses on the relation between stochastic variable and non-stochastic variable.Based on the analysis of linearity return problem,this article works out the solution to it-least squares method and the Excel solution law.With the comparison of these two methods,it can be found that Excel,with the aid of graphs,can clearly display data relations when solving return problems,so that office eficiency will be achieved greatly.