The Applied Research of Excel Functions in Experimental Data Processing
Xiong Ze-ben · Physical Experiment of College · 2010
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.