如何在Excel中进行多元回归？

I've been searching the web for possibilities to conduct multivariate regressions in Excel, where I've seen that Analysis ToolPak can make the job done.

我一直在网上搜索在Excel中进行多变量回归的可能性,在那里我看到Analysis ToolPak可以完成工作。

However it seems that Analysis ToolPak can handle multivariable linear regression but not multivariate linear regression (where the latter is that one may have more than one dependent variable Y1,...,Yn = x1+x2..+xn and the former that a dependent variable can have multiple independent variables Y = x1+x2+..+xn).

然而,似乎Analysis ToolPak可以处理多变量线性回归,但不能处理多元线性回归(其中后者是一个可能有多个因变量Y1,...,Yn = x1 + x2 .. + xn,而前者是a因变量可以有多个自变量Y = x1 + x2 + .. + xn)。

Is there a way to conduct multivariate regressions in Excel or should I start looking for other programs like R?

有没有办法在Excel中进行多变量回归,还是应该开始寻找像R这样的其他程序?

Thanks in advance

提前致谢

1 个解决方案

#1

Is this what you are looking for? http://smallbusiness.chron.com/run-multivariate-regression-excel-42353.html

这是你想要的? http://smallbusiness.chron.com/run-multivariate-regression-excel-42353.html