regression analysis

A

angelajwms

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi,
I just got my first mac and I have no idea how to use excel to run a regression analysis. Any suggestions?
 
M

Mike Middleton

angelajwms -

I suggest you return Mac Excel 2008 to the vendor and get a refund. Then
purchase Mac Excel 2004 (eBay, ...).

Mac Excel 2004 has the Analysis ToolPak wizards with the Regression tool.

Mac Excel 2008 does not have the Analysis ToolPak (because the wizards are
written in VBA, and Mac Excel 2008 does not include VBA), so it does not
have the Regression tool wizard.

To do regression analysis in Mac Excel 2008, you can use worksheet
functions: INTERCEPT, SLOPE, RSQ, and STEYX for simple regression, and
LINEST for multiple regression.

Also, for simple regression in Mac Excel 2008, you can create an XY
(Scatter) chart type and use the Add Trendline feature.

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

Carl Witthoft

Hmf. If you REALLY want to do regression analysis, don't use any
version of Excel. Use a real tool, of which there are many , both free
and paid.

R
MatLab
Mathematica
Regress+
ProFit
Octave
FreeMat
SciLab


that's for starters.
 
S

Sebastian

The best way to get regression analysis is by
(1) graphing a scattered plot white the points you want to get a regression,
(2) then right click over a point and click "add trendline"

there you will be able to get any type of regression, be it linear, quadratic or any other...
 
M

Mike Middleton

Sebastian -

Yes, adding a trendline to an XY (Scatter) chart might be the "best way," as
long as you have only a single X variable and you do not need any
diagnostics other than R-squared.

But, if you have more than one explanatory variable or if you want more
diagnostics, then the Regression tool of the Analysis ToolPak (in Mac Excel
2004 and earlier versions) might be useful.

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

Carl Witthoft

A major drawback to using a graph to get regression coefficients is that
there's no automatic way to get those coefficients into something
useful, like, say, a spreadsheet.

Use LINEST for all polynomial fits, LOGEST for a variety of exponential
fits,
and as I keep suggesting, if you want to do some real regression, get
yourself one of the many excellent tools (apps) out there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top