Looking for a macro to curve fit using multiple regression
 

Richard -

You can use LINEST for multiple regression, and get out some of the
goodness of fit data you need (at least t-tests on the coefficients,
F-test on the model, and R-squared). The Analysis Toolpak has a
regression module (Tools menu Data Analysis...) that will spit out
lots of that stuff, too. If you don't see Data Analysis under the Tools
menu, go to Tools Addins and check the box in front of Analysis
Toolpak. If Analysis Toolpak isn't listed, you need to get your Office
or Excel CD and reinstall the toolpack.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Richard wrote:
I am looking for a macro to curve fit using multiple
regression. I want to do the fit and then estimate the
quality of the fit in terms of a statistical function such
as RMS error. Thanks