|
Although Manifold does not directly furnish regression tools, with the magic of Microsoft automation techniques, you can directly connect to Excel's object model and do what you are talking about. You don't need to exit Manifold, you can script an ActiveX connection to Excel and export your array(s) to Excel and bring the results back into a Manifold table and then into a drawing, etc. You need to be able to write a script to do this. Art Lembo's GisAdvisor.com website has an excellent tutorial for sale, called Manifold Scripting in version 6.5, I think, that has an good example on how to do this. In fact, he uses Excel in the example to run a correlation analysis, a close cousin of your regression analysis, so it should be fairly easily to modify for your needs. It's really not that hard, of course, after you see it done. There are many examples on the web showing how to automate Excel from within other programs, if you don't want to purchase Art's tutorial. I recommend the tutorial, it's cheap for the value.
|