Data analysis toolPack

  • Thread starter Thread starter avi
  • Start date Start date
A

avi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help - Calling Analysis Toolpak Functions from Outlook Macro 2
Excel - Analysis Toolpack loading problem 2
how to use histogram in vba code - analysis toolpack 1
analysis toolpack? 1
Excel VBA help - Range selection 5
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) 1
Excel 2000 Analysis Toolpack add-in 2
Problem using analysis toolpack when automating EXCEL 1

Back
Top