利用Excel内部函数LINEST进行多元回归和多项式回归分析

Analysis of Multiple and Polynomial Regression Procedure by Inner Function-LINEST of Excel

多元回归和多项式回归在生物统计中具有重要地位,但当自变量超过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.