Linear Regression graphs

T

tmason68

I need instruction on developing a linear regression chart. Excel is doing
the calculations, but not a graph that accurately reflects them.
 
M

Mike Middleton

tmason68 -

Assuming pre-2007, here are some ways:

(1) Choose Tools | Data Analysis | Regression, and let Excel do the
calculations and the chart.

(2) Create an XY (Scatter) chart, and use Add Trendline to get the chart and
fitted formula.

(3) Create an XY (Scatter) chart with the data, and use worksheet functions
SLOPE and INTERCEPT (or LINEST) to put data for fitted values on the
worksheet and add them to the chart.

(4) Search Google for "excel linear regression chart" (without the quotes)
and follow some of those instructions.

- 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

Top