How do you run regression in excel?

G

Guest

I'm trying to run regression in excel and just can't remember how to do it
with it producing a graph.
 
J

Jerry W. Lewis

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
 
P

pressure

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.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Structured References - Regression Analysis 6
how do i graph a regression analysis? 1
Error Message - Input Range must be a contiguous Reference Help!!! 0
If you have missing data in a regression, what goes in the cell? 1
regression analysis 6
How to add a regression line to an XY scatter plot 2
multiple polynomial regression in Excel 4
null vs zero in regression analysis 2

Top