欢迎访问《中国农学通报》,

中国农学通报 ›› 2005, Vol. 21 ›› Issue (3): 306-306.

• 目次 • 上一篇    下一篇

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

汤在祥,高清松,徐辰武   

  • 出版日期:2005-03-05 发布日期:2005-03-05

Nonlinear Equation Fitting by Microsoft Office Excel and Its Application

Tang Zaixiang, Gao Qingsong, Xu Chenwu   

  • Online:2005-03-05 Published:2005-03-05

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

Abstract: 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.