Data analysis toolPack
 

Hello,

I wonder is there is some way to collect programatically the different
statistics associated with the regression module of the toolpack, so
that I can display them on a userform

Is it possible?

Thanks
Avi

Data analysis toolPack
 

Avi -

The Regression tool uses the LINEST worksheet function and probability
distribution worksheet functions, so one approach would be to use those
functions to compute your own results (instead of trying to "read" the
Regression tool results).

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



"avi" wrote in message
...
Hello,

I wonder is there is some way to collect programatically the different
statistics associated with the regression module of the toolpack, so
that I can display them on a userform

Is it possible?

Thanks
Avi