Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 drawing Trend lines on a chart for a given set of point
I have encountered a very stupid result while drawing a Trend line on number
of points given on a chart. The stupidity reflects in the resulting equation. The resulting equation gives rise to Y values, for the same X-values it used in the first place, very divergent from the Y values that it is supposed to predict. Has any body encountered this problem before? What is the algorithm that is used by Excel to draw the Trendlines,any body could educate me,please? -- beetal |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 drawing Trend lines on a chart for a given set of point
beetal -
Such differences are often due to (1) using a Line chart type instead of an XY (Scatter) chart type, in which case Excel uses 1,2,3,... for the x values or (2) not showing enough significant digits for the trendline equation. If you think your results have another cause, please describe your data, trendline type, and results in detail. As far as I know, the algorithms implement ordinary least squares, in some cases using transformed x or y values (or both). - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "BEETAL" wrote in message ... I have encountered a very stupid result while drawing a Trend line on number of points given on a chart. The stupidity reflects in the resulting equation. The resulting equation gives rise to Y values, for the same X-values it used in the first place, very divergent from the Y values that it is supposed to predict. Has any body encountered this problem before? What is the algorithm that is used by Excel to draw the Trendlines,any body could educate me,please? -- beetal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create chart from daily data and add trend lines for each week | Excel Discussion (Misc queries) | |||
Get value equal to final point of chart trendline [=Trend( )] ? | Excel Worksheet Functions | |||
Possible to change colors 3d bar chart by point in Excel 2003? | Charts and Charting in Excel | |||
Chart point colours to show time trend | Charts and Charting in Excel | |||
= Drawing more lines in a OHLCV chart = | Charts and Charting in Excel |