Multiple Regression Function

  • Thread starter Thread starter bcb
  • Start date Start date
B

bcb

How to I get the regression function under Data Analysis
to generate a multiple regression equation for 16
independent variables?

Thanks
 
You just do it. The limit is 17 variables.
http://groups.google.com/groups?selm=409B84FF.4040101@no_e-mail.com
If you are having problems, then you are likely either making an entry
mistake in the dialog, or have variables that are confounded in your
data set.

Sixteen is a very large number of predictors. Are you sure that you are
not overfitting your data? All else being equal I would still have
numerical concerns about fitting such a complex model in Excel versions
prior to 2003.
http://support.microsoft.com/default.aspx?scid=kb;en-us;828533

What error message are you getting?

Jerry
Excel MVP
 
Back
Top