multiple regression function?

[Joe B.]

Is there an add-in function for Excel to do "multiple
regression"? I found the linear regression but not the
multiple. Used to do this with lotus and symphony 17
years ago. Does Excel not have it?

Thank you!

Joe

 

[Jerry W. Lewis]

Help for LINEST is extremely misleading. It does multiple linear
regression (polynomials, multiple predicter variables, etc.). If you
are wanting multiple non-linear regression (which I doubt that Lotus or
Symphony does), then you can use Solver to minimize the sum of squared
deviations (or whatever else your favorite fitting criteria happens to be).

Jerry