This discussion is archived
16839 Views 4 Replies Latest reply: Jan 8, 2009 9:21 AM by GBH
Currently Being ModeratedJan 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#statisticalMac OS X (10.4.10), Macbook Pro -- iPhone 3G
Currently Being ModeratedJan 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?iMac Core 2 Duo, Mac OS X (10.5.1)
Currently Being ModeratedJan 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: