Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"advanced statistics" in Excel/VBA
I'm looking for software for doing advanced statistics (such as the General
Linear Model) within Excel. Furthermore, the software would have to be accessible through VBA meaning that I could call subroutines using VBA code. Does anyone have a recommendation? Best regards, Thomas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"advanced statistics" in Excel/VBA
The Excel function LINEST (as implemented in Excel 2003 or later) will do a
General Linear Model (but not a Generalized Linear Model), you just have to supply the appropriate X matrix. Help for LINEST misleads you into thinking that it is much more limited than it really is. You can call worksheet functions (including LINEST) from VBA. You might also find PopTools http://www.cse.csiro.au/poptools/ and Morefunc.xll http://xcell05.free.fr/english/index.html to be useful. There are also various commercial add-ins that I am less familiar with. Unless you are quite good at both statistics and statistical computing, you will be less likely to get into trouble with a real statistics package. R is free, highly capable, and well respected http://www.r-project.org/ There is an R package that allows you to call R functions from Excel. Jerry "Thomas" wrote: I'm looking for software for doing advanced statistics (such as the General Linear Model) within Excel. Furthermore, the software would have to be accessible through VBA meaning that I could call subroutines using VBA code. Does anyone have a recommendation? Best regards, Thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In descriptive statistics, what does the "confidence level" mean? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
In descriptive statistics, what does "confidence level" mean? | Excel Discussion (Misc queries) | |||
Created date in "General" tape and "Statistics" tape | Excel Discussion (Misc queries) | |||
Excel will not "show all" from an Advanced Filter on a sheet with protected cells. | Excel Programming |