Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Residual plots in excel 2007

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default Residual plots in excel 2007

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


"bscra" wrote in message
...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regression Residual Plots Andrew Excel Discussion (Misc queries) 0 July 6th 07 08:14 AM
CAR LEASE CALCULATION WITH RESIDUAL FIN Excel Worksheet Functions 1 January 19th 07 12:31 AM
How can you create Box Plots (Box-and-Whisker Plots) in Excel? Amy Bass Charts and Charting in Excel 3 December 28th 06 12:18 AM
residual plot Erin Charts and Charting in Excel 2 October 4th 06 07:02 PM
Excel gives me line plots - I want scatter plots Pangloss Charts and Charting in Excel 1 October 14th 05 02:15 PM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"