> Sometime in the last year I recall seeing some discussion about the
> use/abuse of linear regression using Microsoft Excel. I was
> recently asked if there are any excel add-ins that would allow
> linear regression of 40+ independent variables.
You might want to take a look at "Analyse-it for Microsoft Excel". The
General statistics module includes linear regression, capable of analysing
upto 254 independent variables (254 is the limitation imposed by Excel's
worksheet column capacity).
Analyse-it uses a _very_ stable algorithm for matrix decomposition during
the linear regression calculations. That means the results are much more
accurate than Excel, more accurate than any other Excel add-in (we've
tested them all), and more accurate than even Minitab.
For more information, or to download a free 14-day evaluation, please
stop-by our web-site at http://www.analyse-it.com/info/genmod.htm.
Regards,
_____________________________________
James Huntington
ANALYSE-IT SOFTWARE LTD
.............................................................
Analyse-It! powerful accurate statistical analysis for Microsoft Excel
Download a free no-obligation 14-day evaluation, and get more info at:
http://www.analyse-it.com
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|