摘要
为了拟合带有2个参数的一元非线性回归模型,提出了一种ExcelVBA程序算法。该算法根据"残差平方和最小"原则通过建立关于参数的For循环语句并利用最小值传递的思想,从而获得一元非线性回归模型的参数值。实例证明该算法简单实用。
In order to fit unitary non-linearity regress equation with two parameters, a VBA programmed algorithm was proposed. The method proposed acquired parameters of unitary non-linearity regress equation through setting up for statement and utilizing the function of minimum value transmission according to the principle of 'minimum sum of squared residuals~. The example showed that the method of fitting unitary non-linearity regress equation was not only simple and practical, but also higher in accuracy.
出处
《西北林学院学报》
CSCD
北大核心
2011年第3期147-151,共5页
Journal of Northwest Forestry University
基金
林业公益性行业项目(200804027)
"十一五"国家科技支撑重点项目(2006BAD23B-01)
关键词
一元非线性回归模型
“残差平方和最小”原则
ExcelVBA程序算法
unitary non-linearity regress equation
the principle of ' minimum sum of squared residuals'
ExcelVBA programmed algorithm