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.
|