how do i graph a regression analysis?

G

Guest

i am learning (slowly) how to perform a regression analysis on two columns of
data. Excel has given me a formula and i came up with an answer using the
LINEST function. How do i turn this into a graph or does Excel do it for me.
I'd like to see the different points scattered. thanks
 
M

Mike Middleton

Brad -

Arrange data with X values on the left and Y values on the right. Select
both ranges. Create an XY (Scatter) chart.

Or, use the Regression tool of Excel's Analysis ToolPak, in which case Excel
automatically provides a scatter chart of the original data with the best
fit line.

Or, after creating an XY (Scatter) chart of the original data, select the
data series (click on a point), and insert a trendline.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

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

regression analysis in excel 2007? 1
Correlation or Regression Analysis 3
LINEST() function returns error. 1
Problem with Regression function in 2007, Analysis Tool Pak 2
how do i graph multiple linear regression? 1
Error Message - Input Range must be a contiguous Reference Help!!! 0
Time Series Regression Analysis 1
Trendline s. regression analysis 4

Top