非线性方程的Excel拟合及其应用

介绍了如何利用Excel软件中的“规划求解”工具进行非线性方程的最优拟合以及应用注意事项。采用Gause的4组草履虫数据，研究了用Excel的“规划求解”工具进行非线性方程拟合的有效性，并以莫惠栋的《农业试验统计》一书中的12个非线性方程实例，比较了用Excel拟合与用常规线性转换方法拟合的差异，结果表明：用Excel进行非线性方程的拟合不仅简单易行、获得更优的参数估计，而且可以拟合各种复杂的非线性方程。

Nonlinear Equation Fitting by Microsoft Office Excel and Its Application

A nonlinear equation fitting method by the Programming Tool of the Microsoft Office Excel software was introduced in detail and its application in real data analysis was discussed. The experiment data of paramecium from Gause was used to investigate the efficiency of the method. And the twelve nonlinear real examples from "Agricultural Experimental Statistics" written by Mo Huidong were used to compare the difference between results fit by the Excel and the linear transformation method, respectively. The result showed that the Excel fitting method is not only simple and efficient for the parameter estimation but can fit various complex nonlinear equations also.