How do you run regression in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to run regression in excel and just can't remember how to do it
with it producing a graph.
 
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
 
eg y=a+B+E

where do i put this to get the regression to run

please help me
Jerry said:
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
I'm trying to run regression in excel and just can't remember how to do it
with it producing a graph.
 
Back
Top