Multiple Regression Output

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

R2 for regression with 2 depending variable 3
Regression gives slope of zero when x values smaller than 10^-7 2
regression analysis 6
multivariate regression 1
multiple polynomial regression in Excel 4
How to print LinEst result to a spreadsheet using VBA 3
Regression Analysis Error message 3
Regression with zero intercept 2

Top