regression analysis

[excelmania]

Can anyone tell me if I can do multiple regression analysis (two independent
variables) using Excel version : Office Home and Student 2007?

NOTE: I already have Excel 2003 but this version appears to only have the
capability for single variable regression analysis.

 

[Mike Middleton]

excelmania -

You posted in microsoft.public.mac.office.excel, which is primarily
Macintosh Excel.

Excel 2003 and Excel 2007 (both Windows, not Mac) have the Analysis ToolPak,
which includes a Regression tool (which can be used for simple and multiple
regression).

Analysis ToolPak is an add-in, so it may not be installed, but you can add
it from the installation CD.

Or, you can always use Excel's built-in array-entered LINEST worksheet
function.

You can get more information about the Analysis ToolPak Regression tool and
the LINEST function from Excel's Help or from google searches.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Carl Witthoft]

Yep. While I never recommend using Excel to do regression analysis,
because it's clunky, and because things like Regress+ and ProFit are
much better at it, here is the trick:

Set up a formula like

=LINEST([yarray],[xarray]^{1,2,3},true,true)

where yarray and xarray are either names or contiguous data areas. That
example, of course, is for a 3rd-order polynomial. Read the
documentation for info on entering an array variable (since there is a
LOT of output from this formula).

Also, in Excel 2004 (but not in ExcelX) there's a nasty formula bug.
You have to enter TRANSPOSE(yarray), TRANSPOSE(xarray)^{1;2;3}
or something close to that. I don't have the reference available right
now, but if you Google for "excel mac linest polynomial" or something
similar, you'll find some forum topics that are very helpful.


Or you could use the regression tools in FreeMat, Octave, etc.