Multiple Regression Output

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Data Analysis Toolpak|Regression to do a multiple regression
analysis of 3 data variables and 11 dummy variables (14 total). The ANOVA and
Statistics output is correct, but the coefficients for some dummy variables
and the intercept do not match the expected output.

Any thoughts?

I am using Excel 2003 SP1.
 
Likely you have an ill-conditioned problem (easy to do with that many
variables) that requires more than double precision to accurately calculate.
There may be workarounds, if you post your data.

It is not clear to me how this is causing Excel to crash. Otherwise the
"Worksheet Function" group would be a more appropriate location, and one that
would have gotten you a much faster response.

Jerry
 
Back
Top