Regression Analysis in Numbers '09

Question

Regression Analysis in Numbers '09

Is it possible to do multiple regression analysis in the new Numbers? I downloaded the demo but couldn't figure out if it has been added. If so, how do you do it?

iMac Core 2 Duo, Mac OS X (10.5.6)

Posted on Jan 7, 2009 2:26 PM

Reply

Answer 1

Best reply

GBH

Level 1

73 points

Jan 8, 2009 9:20 AM in response to brownsburgbulldog

It looks like it can do regression, but you have to individually do each statistic, unlike the data analysis toolpak in excel (windows) that does the entire thing in one click of a button. You can also try NeoOffice or OpenOffice for regression when you need to do that. They're free. Then you go add the add ons at the stat site below which largely run on them and do the functional equivalent of the data analysis toolpak:

http://www.coventry.ac.uk/ec/~nhunt/oatbran/

Reply

Answer 2

Jan 7, 2009 3:16 PM in response to brownsburgbulldog

There is no multiple regression statistical formula available in Numbers 09.

All statistical functions are listed here:

http://www.apple.com/iwork/numbers/functions.html#statistical

Reply

Answer 3

Jan 8, 2009 7:51 AM in response to RonAnnArbor

I noticed on the list that several of the functions refer to "regression" in the explanation of the function. For example, "Forecast" seems to do something that looks like a regression analysis, but I'm not sure if it will work will multiple independent variables.

Does anyone out there have experience using the "Forecast" function?

Reply

Answer 4

GBH

Level 1

73 points

Jan 8, 2009 9:21 AM in response to GBH

By the way, the add ins also work in Excel Mac 2008.

Reply