| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple regression
I need to know how to plot a multiple regression and also get the equation
and Rsquare...I'm totally lost |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i graph multiple linear regression? | Excel Discussion (Misc queries) | |||
| How do I put days of the week into a multiple regression model? | Excel Worksheet Functions | |||
| multiple regression template | Excel Worksheet Functions | |||
| How do I perform multiple regression in Excel using two independe | Excel Worksheet Functions | |||
| multiple regression | New Users to Excel | |||
Linear Mode
