View Single Post
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default 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.