View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default 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