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

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" <(E-Mail Removed)> wrote in message
news:b4470d2c-6616-42c4-9bc9-(E-Mail Removed)...
> 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