Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Linear Regression graphs
I need instruction on developing a linear regression chart. Excel is doing
the calculations, but not a graph that accurately reflects them. -- And thanks for helping! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Linear Regression graphs
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 "tmason68" wrote in message ... I need instruction on developing a linear regression chart. Excel is doing the calculations, but not a graph that accurately reflects them. -- And thanks for helping! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Linear Regression graphs
In addition to Mike's instructions, perhaps this example can help.
http://www.cellmatrix.net/index.php/...ear_regression -- John Mansfield http://cellmatrix.net "Mike Middleton" wrote: 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 "tmason68" wrote in message ... I need instruction on developing a linear regression chart. Excel is doing the calculations, but not a graph that accurately reflects them. -- And thanks for helping! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linear Regression in Excel | Excel Worksheet Functions | |||
non linear regression in excel | Charts and Charting in Excel | |||
How do I perform linear regression? | Excel Discussion (Misc queries) | |||
How do I perform linear regression? | New Users to Excel | |||
linear regression | Excel Worksheet Functions |