摘要
多元回归和多项式回归在生物统计中具有重要地位,但当自变量超过3个时,相关参数的计算十分复杂。本文通过实例详细介绍了利用Microsoft Excel内部函数LINEST对多项式及多元回归分析的方法,该方法具有快速、简单、准确的特点。
Multiple and polynomial regression plays an important role in biological Statistic. But it is very difficult for coefficient calculation when independent variables are over 3. In this paper a method of multiple and polynomial regression procedure analysis by Inner Function-LINEST of Microsoft Excel was introduced clearly.
出处
《草业与畜牧》
2007年第8期48-52,共5页
Pruataculture & Animal Husbandry
基金
云南省自然基金项目(2004C0063M)"德宏狼尾草特性及栽培技术研究"资助