Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you run regression in excel?
I'm trying to run regression in excel and just can't remember how to do it
with it producing a graph. |
#2
|
|||
|
|||
How do you run regression in excel?
You can either
- plot the data [use "XY (Scatter)", not "Line" chart] then Chart|Add Trendline (don't ignore the Options tab). - Tools|Data Analysis|Regression (requires the Analysis ToolPak add-in that was shipped with Excel, but may not have been installed). Jerry heatherm wrote: I'm trying to run regression in excel and just can't remember how to do it with it producing a graph. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you type in the equation
eg y=a+B+E
where do i put this to get the regression to run please help me Jerry W. Lewis wrote: You can either - plot the data [use "XY (Scatter)", not "Line" chart] then Chart|Add Trendline (don't ignore the Options tab). - Tools|Data Analysis|Regression (requires the Analysis ToolPak add-in that was shipped with Excel, but may not have been installed). Jerry heatherm wrote: I'm trying to run regression in excel and just can't remember how to do it with it producing a graph. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I conduct linear regression in Excel with more than 16 x's | Excel Worksheet Functions | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |