Residual plots in excel 2007

B

bscra

When I run a multiple regression in Excel 2007, it only puts up the residual
plot for one of the variables, unlike Excel 2003 which will put up a plot for
every variable. How do I set it up where I can see all residuals for 2007.
 
M

Mike Middleton

bscra -

I cannot replicate your problem using Excel 2007 (12.0.6024.5000), the
current release-to-manufacturing commercial Pro version.

That is, the Regression tool creates a residual plot for each X variable. To
see them clearly, I can click and drag. And to make them redraw properly, I
must resize them slightly. But they're all there.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

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

Top