regression analysis

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.



In article <OyZPXTeZIHA.1204 DeleteThis @TK2MSFTNGP03.phx.gbl>,
"Mike Middleton" <mike DeleteThis @mikemiddleton.com> wrote:

> 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
>
>
>
> "excelmania" <excelmania DeleteThis @discussions.microsoft.com> wrote in message
> news:31D4E4D0-918E-4EE6-BF92-7657B23848A2@microsoft.com...
> > 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.

--
Team EM to the rescue! http://www.team-em.com
 >> Stay informed about: regression analysis