multiple regression

G

Guest

I need to know how to plot a multiple regression and also get the equation
and Rsquare...I'm totally lost
 
M

Mike Middleton

marikita -
I need to know how to plot a multiple regression and also get the equation
and Rsquare...I'm totally lost <

One way to get the best-fit equation and R-Square (and a lot more) is to
use the Regression tool of the Analysis ToolPak.

But "multiple regression" means two or more explanatory variables, and an
appropriate "plot" requires three or more dimensions, so by itself Excel is
not the ideal tool for the "plot" task.

- Mike
www.mikemiddleton.com
 

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