multiple regression
 

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

multiple regression
 

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

multiple regression
 

How about using the LINEST function
If you are fitting a polynomial see
http://www.stfx.ca/people/bliengme/E...Polynomial.htm

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"marikita" wrote in message
...
I need to know how to plot a multiple regression and also get the equation
and Rsquare...I'm totally lost