Linear Regression graphs

[tmason68]

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

 

[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

 

[John Mansfield]

In addition to Mike's instructions, perhaps this example can help.

http://www.cellmatrix.net/index.php/site/analysis/linear_regression

--
John Mansfield
http://cellmatrix.net