View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default 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